How to Setup the iReport client application

Document ID : KB000047888
Last Modified Date : 14/02/2018
Show Technical Document Details
Note: iReport setup for Nimsoft and a quick start guide is attached to the article.

Add MS?SQL?Server JDBC?Driver

By Default, iReport supports only MySQL?backend database. To add support for MS?SQL?Server take following steps:

1- Download MS?SQl?Server JDBC driver from http://jtds.sourceforge.net/ . Select the jtds-<version>-dist.zip file; the latest avaialbe as of Aug 14th 2011 is version 1.2.5 http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download

2- Unpack the downloaded driver to a convenient location, preferably under iReport install folder.

3- Now, open iReport Classpath from Tools->Options and click on Add Jar button and point it to unpacked jtds jar file e.g jtds-1.2.5.jar and click Open.

User-added image


Setup iReport Environment

?

If you would like to design account aware reports, we recommend you design them using iReport and add support for our query executor. Then deploy the report to Unified Reporter and view the results. First you will need to setup iReport.

1- Choose Tools -> Options menu
2- Choose classpath tab + click Add Jar button


User-added image


3- Navigate to <NMS wwith SDP|UMP install folder>/probes/service/wasp/webapps/jasperserver-pro/WEB-INF/lib
4- Choose ?acegi-security-1.0.1.jar? and click Open

?


User-added image

5- Navigate to <NMS with SDP|UMP install folder>/probes/service/wasp/webapps/jasperserver-pro/WEB-INF/classes
6- Click Open

User-added image

7- Click Add Jar again and point to sqljdbc.jar or sqljdbc4.jar file located under \wasp\lib folder.

?

8- Your window should now look like this (if you expand the columns).
User-added image


9- Now select Query Executors tab and Click ?Add?
10 - Add these values (note that the language is nimsoft with lower case letters only):

Language = nimsoft
Factory Class = net.sf.jasperreports.engine.query.NimsoftQueryExecuterFactory
Fields provider = com.jaspersoft.ps.nimsoft.NimsoftFieldsProvider

11- Click Ok - your query executor should now be listed here.

User-added image

12- Click Ok and the query executor should now be ready to use.

Please note, there is not 100% support for query executors in iReport 3.5.0, but the problems seem to be corrected in 3.6.0.

keywords: Setup iReport Professional client application app Java JRE account aware reports iReport setup pro professional configure error popup unable Unable launch Launch

Attachments:

File Attachments:
TEC000002684.zip