dduke

Hi giulio, can we spect for a solution or can we forget about it? Answer our questions please. Regards: DarkDuke

hi giulio, i would like to know if i can still wait for a solution to this bug or if i can quit waiting for a solution. regards

i hope this can be fixed on a short time, i'm missing the new features off the new versions of iReport, please, take this bug seriously. I do not think removing 3.0 support option is a good solution.

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

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

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

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++.

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

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