Jump to content
We've recently updated our Privacy Statement, available here ×

joel.carlson

Members
  • Posts

    28
  • Joined

  • Last visited

Community Answers

  1. joel.carlson's post in How to connect to DB2 databse from ireport 3.7.5 was marked as the answer   
    Not sure if iReport 3.7.5 is the same as 5.6.0 but you need to upload the jar drivers in iReports. Tools - Options, Then under classpath tab upload the db2jcc.jar and the db2jcc_license_cu.jar. For you database connection click the button for a new connection and type a name for it, then type in com.ibm.db2.jcc.DB2Driver in JDBC Driver, for JDBC URL use jdbc:db2://{IP or hostname of server}:50000/{Database name} then enter your username and password and hit test. Should work.You should be able to find the jar files under {installation directory}/IBM/SQLLIB/java
  2. joel.carlson's post in Input Parameters was marked as the answer   
    You might have to link the parameters from the main report to the table. Right click on table in main report and edit datasource. In the parameters tab click add. In the dataset parameter name select your start date paramenter from the table query. Then under value expression select the start date parameter for the main report. Do the same for the end date and you should now get data.
×
×
  • Create New...