[ireport 4.1.1 compatibility problem with older ireport version]

i need to design a report with jasperreport 3.0.0 compatibility, but the ireport 4.1.1 is showing this error:

Error saving the JRXML: XML writer for version 3_0_0 not found.

 

can somebody help me?

Post Edited by dduke at 09/07/2011 19:51

[how to show the ten percent of total records on ireport]

you are right about window functions, i'm using postgresql 8.3, that it does not support it (it does support limit), and i can not still migrate to a superior postgresql, so i'm convicted to find other solutions. i have another problem i have to print exactly the 10 percent, even when "where random < .1" is a fine approximation, is not good enough for that specific report, but it's a good idea to take in mind.

i was hopping to get the value of total records from some place on ireport, but it seems impossible.

regards

DDuke

 

[how to show the ten percent of total records on ireport]

the report is to be displayed on a system that display the jrxml by it self, but it does not support subreport, is a shame, but i can't use subreports, that's why i have implemented my solution 1.

Post Edited by dduke at 01/07/2011 19:09

[how to show the ten percent of total records on ireport]

no, is not an example, i need to print the random ten percent of the products of a warehouse, to make a random physical check of the stock. i have been thinking in two possible solutions:

 

1.

select

random() as random,

p.productname,

(

select

count( p.product_id )

from

product p

where

p.warehouse = 'X'

) as counting

from

m_product p

where

p.warehouse = 'X'

order by

random;

 

and then on ireport, in the detail section, print when expression: $V{REPORT_COUNT}.intValue() <= Math.round( $F{counting}.intValue() / 10 )

 

the limitations of this solution is that I use a subquery to know how many records I will have

 

2.

the second solution I was thinking about is use some variable of ireport to know how many records return the main query, but $V{REPORT_COUNT} can not be used because on each record, its value is value++.

[how to show the ten percent of total records on ireport]

i need to show the ten percent of total records on ireport, help needed

[how to show the ten percent of total records on ireport]

i need to show the ten percent of total records on ireport, as simple as that. help anyone???