jiechu
-
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
Everything posted by jiechu
-
I saw the threads that how to get total pages number / current page number from JasperPrint, but actually, I need to get total pages number / current page number from a scriptlet. For example, ReportScriptlet extends JRDefaultScriptlet. Is there any way to get JasperPrint jr from the scriptlet? Many thanks.
-
jiechu Wrote: Do you know how to transfer a value from subreport to main report? In main report, I define a variable subFee(BigDecimal) and in subreport, I define a variable fee(BigDecimal), the question is when I use <returnValue subreportVariable="fee" toVariable="subFee"/>, it always show null even if there is a valid value in subreport. How to resolve it? I test in both ireport 2.5 and ireport 3.5. Please let me have your feedback. Thanks a lot. I already use evaluated time "Band".
-
Do you know how to transfer a value from subreport to main report? In main report, I define a variable subFee(BigDecimal) and in subreport, I define a variable fee(BigDecimal), the question is when I use <returnValue subreportVariable="fee" toVariable="subFee"/>, it always show null even if there is a valid value in subreport. How to resolve it? I test in both ireport 2.5 and ireport 3.5. Please let me have your feedback. Thanks a lot.
-
I have resolved it. in oracle , add trunc function for each $P{java.util.Date} if you only want Date not timestamp. Code:trunc($P{java.util.Date}).
-
Hi I have a question for the version of oracle 8i. If I create a new report in IReport and oracle 8i, such as with the sql is "select (case when $P{InputDate}=to_date('01/01/1970', 'mm/dd/yyyy') then X.birthday else $P{InputDate} end) as trueBirthday from (select birthday from A) X". It will display "ORA-00932: inconsistent datatypes" and "at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)... " The enviroment is iReport 2.0.2, oracle client 10.2.0. In oracle, the column is Date type and in iReport the field is java.util.Date. If the oracle is 9i or 10g, it works fine. Does anybody know why it cannot work on oracle 8i and how to resolve it? Many thanks.
