Set Up iReport

Contents
uim901
Contents
ireport
After you install Unified Reporter (UR), use the steps in this section to set up iReport. You can install iReport on any system with network access to the system on which you installed UR.
The iReport application must be correctly configured before you can modify, copy, or run reports that use a query executer language. You can view out-of-box reports in UR, however, you cannot edit or copy out-of-box reports without iReport.
Set Up iReport
Follow these steps:
    1. Download the appropriate version of iReport from the Downloads page at http://support.nimsoft.com.
    2. Install iReport on a system with network access to the system on which you installed UR.
    3. Obtain libraries from the UR deployment:
      1. Enter the following URL in a browser: http://<
        UMP_server
        >/jasperserver-pro/ireport-config.jar.
      2. Save the JAR file to a location of your choice.
      3. Start iReport.
      4. Add the JAR file to the iReport classpath:
        • In the menu bar in iReport, select
          Tools > Options > Classpath
          .
        • Click
          Add JAR
          , and browse to the location where you saved the JAR file. Click
          Open
          .
    4. Add query executers:
        1. In the menu bar in iReport, select
          Tools
          >
          Options
          >
          Query Executers
          .
        2. Add query executers (see following instructions).
    5. Connect iReport to your UMP server:
      1. In the menu bar in iReport, click
        Window > JasperReports Server Repository.
        The Repository Navigator pane opens.
      2. Click the
        Add new server
        icon to connect to the UR instance.
      iReport_add_new_server_icon
      The JasperServer Plugin dialog opens.
      Do not enter an Organization name.
    6. In the
      ID
      field, provide a name for your UMP server. For example, enter
      Unified Reporter.
    7. In the
      JasperReports Server URL
      field, edit
      localhost:8080
      so that it points to your UMP server and refers to the UMP port number. The UMP port number is 80 by default. 
    8. Provide a valid Nimsoft username and password.
    9. Set up the data source:
      1. Click the
        Report Database
        icon.
      UR--Set up iReport (1)
      The Connections / Datasources
      dialog opens.
    10. Select
      New > Database JDBC connection
      . Click
      Next
      .
      The Database JDBC connection dialog opens.
    11. Provide a name, such as
      NIS
      , for the database JDBC connection.
    12. Click the drop-down list in the
      JDBC Driver
      field, and select the appropriate JDBC driver for your database.
      The JDBC URL field updates and displays a URL template for the specific JDBC driver you selected. For example, if you selected MS SQLServer (2005) (com.microsoft.sqlserver.jdbc.SQLServerDriver), the JDBC URL field displays jdbc:sqlserver://localhost:1433;databaseName=DatabaseName. If you are using Windows integrated security to connect, add the 
      IntegratedSecurity=true ;
       option after the database name.
      The JDBC drivers that are available are shown in black font; the JDBC drivers that are not available are shown in red font. If the appropriate JDBC driver is not available, verify that you added the JAR file to the classpath as described in step 3.
    13. In the
      JDBC URL
      field, enter the IP address (or host name) of the database server, and the database name. For example, if you selected MS SQLServer (2005) (com.microsoft.sqlserver.jdbc.SQLServerDriver), enter jdbc:sqlserver://<
      IP_address
      >:1433;databaseName=<
      NimsoftSLM
      >.
      In most cases, the JDBC connection uses the same information as the data_engine database configuration.
    14. Provide a username and password.
DB_JDBC_connection3
    1. Click the
      Test
      button.If the connection was successful, click
      Save
      .
      If the connection was unsuccessful, verify the following items:
      • You selected an appropriate JDBC driver for your database.
      • You entered valid information in the JDBC URL field, and valid credentials.
      • The system on which you installed iReport has network access to the database.
iReport is now installed and you can start using it to modify, copy, or run reports.
Query Executers
The following table lists the Nimsoft query executers you can add in iReport.
Language
Query Executer Factory
Fields Provider Class
NimsoftJSONTopN
com.nimsoft.ur.jrs.executer.NimsoftJSONTopNFactory
com.nimsoft.ur.ireport.fieldsprovider.NimsoftJSONTopNFP
NimsoftJSONTimeSeries
com.nimsoft.ur.jrs.executer.NimsoftJSONTimeSeriesFactory
com.nimsoft.ur.ireport.fieldsprovider.NimsoftJSONTimeSeriesFP
nimsoft
com.nimsoft.ur.jrs.executer.NimsoftFactory
com.nimsoft.ur.ireport.fieldsprovider.NimsoftFP
ServiceDesk
com.nimsoft.ur.jrs.executer.ServiceDeskFactory
com.nimsoft.ur.ireport.fieldsprovider.ServiceDeskFP
ServiceDeskNMS
com.nimsoft.ur.jrs.executer.ServiceDeskNMSFactory
com.nimsoft.ur.ireport.fieldsprovider.ServiceDeskNMSFP
NMS
com.nimsoft.ur.jrs.executer.NMSFactory
com.nimsoft.ur.ireport.fieldsprovider.NMSFP
Installing the iReport Commercial License
iReport initially uses an evaluation license that provides commercial-license functionality for 30 days after the installation. iReport is still usable after the evaluation license expires, but certain features are no longer available.
You can install the commercial license that is provided in the UR installation files to continue using all the commercial iReport features.
Follow these steps:
  1. Open iReport.
  2. Select
    Help
    >
    License Manager
    in the toolbar.
  3. Click
    Install License
    and browse to the license file in <
    nimsoft_installation
    >\probes\service\wasp\conf\jasperserver.license.