[How to connect to DB2 databse from ireport 3.7.5]

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. 

[Time part of date being ignored on parameter shown in textfield]

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.

[How to connect to DB2 databse from ireport 3.7.5]

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

[JasperServer Generating Identical Pages]

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

[Jasper iReport on Ubunutu 15.04]

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.

[Jasper reports SQL query error upgraded to v6.1]

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.

[Time part of date being ignored on parameter shown in textfield]

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

[JDBC Oracle 12c connect successful but no data returned]

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

[How to rectify this issue in ubuntu 14.04]

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. 

[Input Parameters]

No problem, I had a similar issue.

[Recursive Query]

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.

[Multi-select Query produces one result]

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.

[Input Parameters]

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.

[How to rectify this issue in ubuntu 14.04]

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"

[adding image path in jasper report]

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.

[Can page break be set in iReport cross-tab?]

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.

[Need-help urgently : multi-select input control]

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.

[Multi selection input control]

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.

[Multi selection input control]

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.

[how to convert decimal to mm:ss ireport]

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 )

[Multi selection input control]

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.

[Need-help urgently : multi-select input control]

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.

[how to convert decimal to mm:ss ireport]

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.

[hyperlink]

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.