ADR707

Hi ilona, Nice example, thanks; got implemented successfully. I just wanted to know, is there anyway we can bring TOC to the first page of the report.

Sure thanks, I'll try that.

Hi Ryan, Any luck with this? I'm facing the same issue. Really would appreciate if anyone can help on this.

Hi Cameron, Thanks for replying, I'll try that out. Just wanted to know, can this be done at report level. What I mean is, the above solution will affect all the reports using a specific theme; but what if I want to disable it for only a specific report/dashboard. Is this possible?

Hi, I'm getting the following error while trying the above steps, Can anyone help. Error Message com.jaspersoft.jasperserver.api.JSExceptionWrapper: jxl.read.biff.BiffException: Unable to recognize OLE stream Error Trace com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: jxl.read.biff.BiffException: Unable to recognize OLE stream at net.sf.jasperreports.engine.data.JRXlsDataSource.(JRXlsDataSource.java:105) at net.sf.jasperreports.engine.data.JRXlsDataSource.(JRXlsDataSource.java:129) at net.sf.jasperreports.data.xls.XlsDataAdapterService.contributeParameters(XlsDataAdapterService.java:100) at

Hi Comsym, Any luck? I have a similar kind of a requirement. Can anyone help us out with this?

Hi Ajinkya, Any luck? I have a similar kind of a requirement. Can anyone help us out with this?

The reason for this issue is that you have deleted the default jasper users (especially "anonymousUser"). Try and import back these users; and I guess you'll get it working. I had faced the same issue earlier.

The reason for this issue is that you have deleted the default jasper users (especially "anonymousUser"). Try and import back these users; and I guess you'll get it working. I had faced the same issue earlier.

Any Solution to Ravi's issue I'm facing the same issue myself. How to use the parameter of collection type in ireports using DB2 database, where (case when ('a' = 'a') then $X{ IN ,col1,MyParam} when ('a' = 'b') then $X{ IN ,col2,MyParam} end) gives error!!!!!! Please help, Thanks & Regards, Sam Post Edited by asksam55 at 03/22/2012 10:51

Thanks, It worked.

Hi I have the same issue as yana. I'm using db2jcc.jar. I have also added it to the classpath, but still the same error. I guess I need to use db2java.jar instead of db2jcc.jar; but unable to find that jar. Can any one help me out with this. thanks.

Hi Raphael, It worked. Thanks a lot for replying, it helped me a lot.. Regards, Sam

Hi.. I'm facing an issue while passing a parameter of collection type from a crosstab element in ireports. A field in crosstab is used as a hyperlink to pass few parameters to the other report. The parameters are of String, Date and one is of Collection type. All the parameters other than the collection type are passed to the new report successfully; but the parameter of collection type is always send as blank and all the data from this parameter gets lost in transit. I am not able to solve this issue. Can anyone help me out with solving this.. Thanks.

When you use " " as the default value, jasper server expects the parameter to be of the type String. But as per your explanation, you are using parameter of collection type; hence try using [" "] instead of " "