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.

This is supposed to be similar to what I do using tables. I make a report with a table and then in the new data set --> groups --> properties there is a check box to start on a new page. This keeps all of the grouped results on a page by themselves. I haven't used cross tabs yet but it should be similar.

Have you tried to add all of those items to the default value expression in your parameter? I also think there is a limit of 500 something when selecting all results.

No problem Mike, someone else just saved mine so it all goes around. Glad to help, had the same issue and struggled through that one.

The where clause changes when doing more of an IN statement. It would be Where $X{IN,field_name,string parameter} but the Parameter Class needs to be changed from a string to 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.

Thanks jlongoria I had to add another paren at the beginning and then change AVG_Talk to a java.lang.Double from java.math.BigDecimal and now I get 2.4222 (($F{AVG_TALK} / $F{CALLS}) / 60) - ( (($F{AVG_TALK} / $F{CALLS}) / 60) % 1) + ( (($F{AVG_TALK} /$F{CALLS}) % 60) / 100.0 )

The where clause changes when doing more of an IN statement. It would be Where $X{IN,field_name,string parameter} but the Parameter Class needs to be changed from a string to 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.

Have you tried to add all of those items to the default value expression in your parameter? I also think there is a limit of 500 something when selecting all results.

Hello, I have a text field expression of $F{AVG_TALK}/$F{CALLS}/60 which gives me 2.70 as the average time for a call and I want to format that to 2:42 or minutes and seconds. ($F{AVG_TALK} = 32444 and $F{CALLS}=200) I'm very new to jasper reporting and don't know how to get the decimal part converted.

I will try to explain this for you just in case it will help someone else that is new. I have two reports one called MLR and one called MLR2. The main report, MLR, shows employee info, like empno, firstname and lastname. MLR2 has the employee's detailed information with address, phone, etc. In MRL, or main report, I used empno for the variable to pass. So in the main report I make a parameter of EmpNum that is equal to $F{EMPNO} Then I right click on empno and select hyperlink. Hyperlink target is set to self Hyperlink type is changed to Reference On the reference tab add the url to the second report, in my case it is MRL2. Go to your jasperserver and open the second report and copy in the url like "http://linktoreport/MLR2&EmpNum="+$F{EMPNO} You can see I added EmpNum, the parameter to the end of the url with &EmpNum=" then added the field to be passed to the second report. So before the quote add &Parametername= Then after the quote add +$F{whateveryourcolumn name is to be passed} On the Link parameters tab add EmpNum for name and $F{EMPNO} for Expression Save that and upload it to the server Go to your second report and add and input controls, for me it is EmpNum all the way through for the names. Now when you run the first report it passes the employee number to the second report.