weihuo
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by weihuo
-
-
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
Problems with JasperReports in Eclipse
in Products
Posted
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