joel.carlson

You can highlight the default IBM JDBC driver and then paste in com.ibm.db2.jcc.DB2Driver to change it to the right one. Also you don't need the db2java.jar that is the older version. Then test again.

I don't think it's a bug perse, more of just the way it works. A java.util.Date does just that, gets a Date only and if you wanted a date time then you just need to select the sql.TimeStamp which includes the date time.

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

If the report is in the details section try moving it to the summary section, that should get rid of the repeating pages.

You can use iReport Designer 5.6.0 with Ubuntu 15.04, I do. Extract the tar, then I created a .desktop launcher that points to iReport-5.6.0/bin/ireport I use openjdk7-jre and it works fine. I had to up the memory in iReport-5.6.0/etc/ireport.conf to make it run better but it works fine.

try adding Declare to validation.properties file, /{yourinstallpath}/jasperreports-server-cp-6.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/classes/esapi Look for Validator.ValidSQL= then add declare where you see select and call and see if that helps.

Have you tried setting the class to java.sql.TimeStamp

Does your report have a report table in it and are you passing parameters to it?

The app is looking for a java/jre folder so I would try to make a folder under /usr/lib/jvm called jre. Copy everything from java-7-oracle into the jre folder and for the path use jdkhome="/usr/lib/jvm/java/jre" and see if that works.

No problem, I had a similar issue.

I only got this working in version 6.1.0. You have to add With to the validation.properties file. By default it only allows select and call. So go to /{yourinstalldirectory}/jasperreports-server-cp-6.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/classes/esapi There you will find validation.properties file, search for Validator.ValidSQL= and add with where you see select and call. I use linux so I am not sure your platform. I also tried this in version 5.5.0 but couldn't get it to work. It works fine for me in the latest version and I use a lot of CTE queries now to build temp tables in db2 because it is easier that way than declaring temp tables.

The where clause changes when doing more of an IN statement. It would be Where $X{IN,field_name, parameter} but the Parameter Class needs to be a java.util.Collection. Defaults can be assigned there as well. This is one I use: Where $X{IN,agent_name,agent_namelist} agent_name is my table column and agent_namelist is the parameter I use as a collection for the in statement. Then for the multi select statement on jasperserver I just use Select Distince agent_name from table order by agent_name You have to make sure that the parameter name used in the report is the exact same as the input control name and it should work. I just changed to jasperserver a few months ago from SSRS for 10 years. There is a little learning cliff but it seems to do everything I did in SSRS.

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.

All I do is extract the folder and place it in /opt and it just works but I am using openjdk-7-jre with 14.04. I have had this error on windows and had to configure the report.conf there. Have you tried creating a folder call jre and copy the java contents into that and then change the path in report.conf? So you have the java folder then inside of that make a jre folder and copy everything in the java folder into the jre folder and supply the path. Inside the report.conf you will find #jdkhome="/path/to/jdk". Just take off the # and add the path. jdkhome="/path/to/jdk"

Upload your image to Images. Say your image is named Company_Logo.jpg upload that so the name on JasperServer says Company_Logo under images. Then edit your report so that under Controls and Resources you have the image named Company_Logo, you don't need the .jpg in the name and find it in the select a resource from the respository. If you used iReport to create the report layout, for the image path just have "Company_Logo" in the path properties.