weihuo

Hello Muyerna, one more question: Can I pass the entir query to jasperReport? I tried but I failed: I pass the query from java code to report as a parameter. In <queryString><![CDATA[ $P!{param_query} ]]</queryString> in later report, I mention the field in the query: <field name="com_due_clnt" class="java.lang.Double"/> it complains: Unable to get value for field 'com_due_clnt' of class 'java.lang.Double'. Thanks. Wei

Hello Muyerna, Thank you very much for your reply. 1. newer version can only load Jrxml file in order to use designer and preview(build). I new an empty report which auto create a Jrxml outline, then I copy my existing xml into the Jrxml. the designer will display the report layout. once I click preview with empty datasource(since I have db2 connection issue), it will display PDF view of report. at the same time it will generate .jasper file. if I use this new jasper file even I did not change anything. It can not be loaded in my java code. I already get corresponding version of jasperreports jar. 2. I will try subreport for multiple queries; 3. I notice that when writing sql in queryString tag, we can use case ... when .. then.. else... end, but all is used in select clause not where clause. for example I would like to do the following action: select * from table_a where table_a.id1 = $P{parameter_id1} if $P{parameter_id2} is not null and table_a.id2 = $P{parameter_id2} How should I write the query like above case? Thanks in advance. Wei

Thanks Muyerina. I am currently working on updating existing report. I found all my reports are very old version of JasperReport since there are only xml files for the source. If I use most current version of iReport to build the report by copying xml to Jrxml, I can get .jasper file. But my java code: JRLoader.loadObject() complains " cannot load the jasper file".... I tried all versions of iReport from V3.5 to V0.2.0. Finally I found that iReport-0.2.2 seems work for me. But when I added DB2 to the connection, I encounted the same issue as hsbgowd had. I already add db2jcc.jar and db2jcc_license_cu.jar in my classpath. my db2 version is 8.1.7 also very old. another question is for queryString tag: how can I write 2 seperate sqls? and how can I write different query based on passed in parameter is null or not? Could you please help me? Thanks in advance. Wei

Hello Matt, I am new to JasperReport. I am updating existing report. My report is a very old version of JasperReport since there is only xml file for the source. If I use most current version of iReport to build the report by copying xml to Jrxml, my java code: JRLoader.loadObject() complains " cannot load the jasper file".... I tried all versions of iReport from V3.5 to V0.2.0. Finally I found that iReport-0.2.2 seems work for me. But when I added DB2 to the connection, I encounted the same issue as hsbgowd had. I already add db2jcc.jar and db2jcc_license_cu.jar in my classpath. my db2 version is 8.1.7 also very old. Could you please help me? Thanks in advance. Wei

Hello, I am new to JasperReport. How you open jasperReports in Eclipse? Do you know what is the source file for JasperReport? xml or Jrxml or both? I found our old rpt source files are all xml files. but looks like iReport expect Jrxml as source. Thanks in advance