Jasper Usage

[Nagav]

Hello

Can you please point me to document, that will provide me help me/ guide me to implement reporting feature (using Jasper report's .jxml files).  Not sure from where I need to start. It will great if there is any tutorial kind of document.

Currently I am using Netxms window client version 2.0-M2(8008)

I have done following
from  "https://www.netxms.org/download/archive/reporting/" I have download "netxms-reporting-server-2.0-M2.zip"
I have unziped it in Window and copied it to unix box where my netxms server (ntxmsd) is running

copied it to location /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2
and did following steps

1. executed "nxdbmgr set EnableReportingServer 1"
2. created conf folder under "/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
3. created workplace folder under ""/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
4. created logback.xml under conf folder
5. created nxreporting.xml under conf folder
6. Now the folder looks like

    uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
    total 5920
    drwxr-xr-x  11 uspsqa1  uspsqa1      34 Sep  9 02:33 ..
    -rw-r--r--  1 uspsqa1  uspsqa1  2929061 Sep  9 02:33 nxreporting-2.0-M2.jar
    drwxr-xr-x  5 uspsqa1  uspsqa1        6 Sep  9 02:33 .
    drwxr-xr-x  2 uspsqa1  uspsqa1      79 Sep  9 02:33 lib
    drwxr-xr-x  2 uspsqa1  uspsqa1        4 Sep  9 02:48 conf
    drwxr-xr-x  4 uspsqa1  uspsqa1        4 Sep  9 02:49 workplace

    /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace
    uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
    total 13
    drwxr-xr-x  5 uspsqa1  uspsqa1        6 Sep  9 02:33 ..
    drwxr-xr-x  2 uspsqa1  uspsqa1        2 Sep  9 02:49 definitions
    drwxr-xr-x  2 uspsqa1  uspsqa1        2 Sep  9 02:49 output
    drwxr-xr-x  5 uspsqa1  uspsqa1        5 Sep  9 02:49 .

7. When I executed "java -jar nxreporting-2.0-M2.jar", it produced several errors, kindly review the errors and
   let me know the corrections that I need to do, I have attached output of execution for your review

Also here are the content of my nxreporting.xml and logback.xml,
The path "/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf" valid path were I have server configuration
I have not given <datasource> info beacause I read that database details be collected from server configuration

content of "nxreporting.xml"

<config>
  <workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>
    <netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>
    <datasources>
        <datasource>           
        </datasource>
    </datasources>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
    <netxms>
        <server>127.0.0.1</server>
        <login>admin</login>
        <password>Awesome@1</password>
    </netxms>
</config>

content of "logback.xml"

<configuration>
  <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
    <!-- encoders are assigned the type
        ch.qos.logback.classic.encoder.PatternLayoutEncoder by default -->
    <encoder>
        <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
    </encoder>
  </appender>
  <root level="debug">
    <appender-ref ref="STDOUT" />
  </root>
</configuration>

Regards
Naga

---

reportserver_debugs.txt

[Nagav]

Hello Team

I have to execute by explicity spcifying the path in the command after modifying the "nxreporting.xml" to have datasource information

java -cp /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/lib/\*.jar:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/conf:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/nxreporting-2.0-M2.jar com.radensolutions.reporting.Launcher

Now I am getting database connection error:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

I have attached full output of above command execution

The content of update "nxreporting.xml", please let me know whether this xml content is correct or not
<config>
  <workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>
    <netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>
    <datasources>
        <datasource>
            <id>ntxdb</id>
            <type>oracle</type>
            <url>jdbc:oracle:thin:@//10.80.226.18:1521/uspsq_app</url>
            <username>e1010985</username>
            <password>one2345</password>
        </datasource>
    </datasources>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
    <netxms>
        <server>127.0.0.1</server>
        <login>admin</login>
        <password>Awesome@1</password>
    </netxms>
</config>

Thanks
Naga

---

reportserver_debugs_with_explicit_path_connection_info.txt