tgs

I could fix the problem by setting the JasperReports Version to 5.5.1 over toolbar > compilation button > drop down "Manage JasperReports Versions".

The Text Alignment function (vertical + horizontal) for a Textfield is not working on a printed Report or JasperViewer created with JasperSoft Studio 6.1.1. This is a major problem for correct printed forms (i.e. invoices) and lists! Edit: The "Text Alignment" Properties of the TextField are set to "right". The xml source code is: <textField pattern="#,##0.00" isBlankWhenNull="true"> <reportElement x="310" y="0" width="70" height="20" uuid="47bff71d-1207-4a34-a61b-dee99e9a3c4a"/> <textElement textAlignment="Right"> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{order_sum}]]></textFieldExpression> </textField> But in JasperViewer the value is displayed as alignment "left"!!??

I have a Parameter DATE (java.lang.String) for a clause like WHERE table.date = ${DATE} in a PostgresSQL 9.1.4 db, but I get the error: operator does not exist: timestamp without time zone >= character varying How can I fix this? How must I format the Parameter DATE and/or set the property? Regards, Thomas *EDIT* I could fix it by changing the column type in the PostgreSQL db from timestamp to date and setting the parameter class of the $P{DATE} to java.util.Date. Post Edited by tgs at 07/21/2012 15:30

I have also the same issue! Does anybody have a solution for that? Downgrading Java on Mac ends mostly in a complete reinstall of OSX and the Java vers. 1.6.0_31 should be installed because of security. Regards Thomas

I have the same issue! iReport 4.0.0 and 4.5.1 won't open after installed Java 1.6.0_31 on my Mac (10.7.3). Thomas

Hi, in iReport 3.7.3 I need a variable "$V{max_page}" for my report, because fields should only be printed on the first page if there is a second. The preferences are: $V{max_page}: Var Class: java.lang.Integer Calc: Highest Reset type: Report Increment type: None Variable Expr.: $V{PAGE_NUMBER} Initial Value Expr: new Integer(0) But I don't get the value of the number of pages! What is wrong and how could I fix that problem? Thomas Post Edited by tgs at 02/07/2011 15:26

Thank you for the link, but this do not fix my problem. I'm struggeling to get the PAGE_NUMBER variable value at the evaluationTime = Report for a Print When Expression. My variable (max_page_no) and/or (cur_page_no) does not always return the PAGE_NUMBER variable value by evaluationTime.

I have created a variable $V{current_page_no} to get the value of the current page of the report. The properties for that variable are: Class: java.lang.integer Calculation: Nothing Reset type: Page Increment type: None Var Expression: $V{PAGE_NUMBER} Initial Value Expr.: new Integer(0) If the report has only one page I get "1". If items in the Detail band displayed on the second page I get "2". If the items of the Detail band are on the first page and only the Summary band is displayed on the second, I get "1" on the first but "0" on the second page!?? Every idea is welcome how I could fix that. Regards, Thomas

I have created a variable $V{max_page_no} to get the value of how many pages the report has. The properties for that variable are: Class: java.lang.integer Calculation: Highest Reset type: Report Increment type: None Var Expression: $V{PAGE_NUMBER} Initial Value Expr.: new Integer(0) If the report has only one page I get "1". If items in the Detail band displayed on the second page I get "2". If the items of the Detail band are on the first page and only the Summary band is displayed on the second I get "1", but the report has two pages!?? Every idea is welcome how I could fix that. Regards, Thomas

The soultion I need should normally quite be easy. - A carry over sum on the first page if there are invoice items and/or the total sum on the second page - Not if there is only one page - Not on the last page if two or more pages I have tried a lot (look at the topic above) but without a professional result. Any help is appreciated, Thomas

Hi, I'm struggeling in creating an invoice report with a variable carry over total sums in the column footer band on the first page if there is a second page, but not on the last page. I'm using iReport 3.7.3. This is what I have done: Variables: v_total_sum Class: java.lang.Double Calc.: Sum Reset: Report Increment: None Expression: $F{total} Init. Value Expr.: new Double(0) v_cur_page Class: java.lang.Integer Calc.: Nothing Reset: Page Increment: None Expression: $V{PAGE_NUMBER} Init. Value Expr.: new Integer(0) v_max_page Class: java.lang.Integer Calc.: Highest Reset: Report Increment: Report Expression: $V{PAGE_NUMBER} Init. Value Expr.: new Integer(0) Now I have placed the variable v_total_sum on the Column Footer. The properties are: Print When Expr.: new Boolean($V{PAGE_NUMBER}.intValue() < $V{v_max_page}.intValue()) I also tried: new Boolean($V{v_total_sum}.doubleValue() < $F{total}.doubleValue()) with totally different results but not the right!? Text Field Expr.: $V{v_total_sum} Evaluation Time: Now This is working if invoice items on a second and further page, but not if only the Summary band is on the second page. I tried a lot and never got the results I need. I would be appreciate for help. Thanks in advance, Thomas Is nobody here to have to create invoices with carry over sum? Post Edited by tgs at 10/15/2010 09:09

Hello slow, your samples helped me a lot. Thank you for that. But I have a problem with the variable: 'max_page' = Class: java.lang.Integer Calc: Highest Reset type: Report Increment type: Report Var Expression: $V{PAGE_NUMBER} Init. value Expr.: new Integer(0) -- I have set the 'Print When Expression' of the $V{carry_over} on the column footer to: new Boolean($V{cur_page}.intValue() < $V{max_page}.intValue()) -- 'cur_page' = Class: java.lang.Integer Calc: Nothing Reset type: Page Increment type: None Var Expression: $V{PAGE_NUMBER} Init. value Expr.: new Integer(0) -- But the $V{carry_over} is not printed (or in the viewer) if the report has more than one pages!? I tried: new Boolean($V{carry_over}.doubleValue() < $F{total}.doubleValue()) and this is working if rows are also on the second, third... page. If all rows on the first page and 'Summary' Band is on the second page, the carry over variable is hidden. What is wrong? Regards, Thomas