[Text Alignment issue JasperSoft Studio 6.1.1[fixed]]

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

[Text Alignment issue JasperSoft Studio 6.1.1[fixed]]

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"!!??

[*FIXED* date query in PostgreSQL db]

 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

[iReport on Lion and java 1.6.0_31]

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

[iReport 3.7.1 won\'t start after Java for OS X Lion 2012-001 update]

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

[(page)variable value issue in JasperReports]

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

[variable for current page number issue]

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.

[variable for current page number issue]

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

[variable for max page numbers issue]

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

[how to show a variable not on last page?]

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

[how to show a variable not on last page?]

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

[Carry over variable]

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