Exporting report to multiple files

Set a unique key for one of the elements in the group header and then search for elements having that key on each print page. This way you can determine at which pages new groups start.

HTH,
Lucian

I don't understand what are you trying to achieve with the query filter, but you can implement such a filter in the following way:

Code:

<br /> <parameter name="SUB_GROUP_ID" class="java.lang.Integer"/><br /> <parameter name="SUB_GROUP_FILTER" isForPrompting="false"><br /> <defaultValueExpression><![CDATA[<br /> ($P{SUB_GROUP_ID} == null || $P{SUB_GROUP_ID}.intValue() < 0) ?<br /> "" :<br /> " AND SubGroupCol = $$P{SUB_GROUP_ID}"<br /> ]]></defaultValueExpression><br /> </parameter><br /> <queryString><![CDATA[<br /> SELECT ... WHERE ... $P!{SUB_GROUP_FILTER}<br /> ]]></queryString><br /> </td></tr></tbody></table><br /> <br /> Note that <i>" AND SubGroupCol = $$P{SUB_GROUP_ID}"</i> would only work in JR >= 1.3.2, if have an older version you will have to use <i>" AND SubGroupCol = " + $P{SUB_GROUP_ID}</i>.<br /> <br /> HTH,<br /> Lucian

My guess is that filling a single report would be faster. Searching for a field in a JasperPrint page only involves going through the element list and testing the element key against a String, so I wouldn't worry about that.

This is only my guess, if you want an actual comparison you should implement both solution and do some performance tests.

Regards,
Lucian

I ran into the problem once again. When implementing the hidden element solution, I put one text field holding SUB_GROUP_ID in the report group header. When this field is printed in the file (currently pdf), then the java code can find the control and can read it text property. However when I hide the field ( by setting new Boolean(false) in the print when expression, then the java code can't find the element as it seems that the method

JRPrintPage.getElements()

returns only printed elements. Then I changed the element width and height to 5px. Now the java code can find the control, but getText() returns empty string. The interesting point here is while debugging in eclipse shows the field "value" of String holding array of characters of actual value of the field, the String itself is empty with count, hash, offset all set to zero.

Then I increased the width and height of the field to only show the 1st character of it's value. Now the getText() returns only the 1st character that is printed. When I increased both height and width to show the full value, then only the getText() returned the full value. So it seems like the element holds only the printed character. But I don't want to print the value in the report.

Now, how can I read the correct value from the element ? And can we read value from hidden (not printed) elements?

Yes, I am putting key value (eg. txtSubGroupId) to a report element and I can get that object by searching for that key. But I need the value that element is holding (in this cse txtSubGroupId). So how can I read this value without printing it in the report?