Hi All,

I have a requirement where I need to print all records in Detail Section on a new page if field values meet condition and if such records are more than 3.

The condition is that the values in the table field should not be equal to 'Y' and such records need to be more than 3.

This condition needs to be calculated for the records in the Detail Section so I need formula to count number of records based on condition and dynamically enable the 'New Page After' option so that it pushes the section on a new page.

I have a grouping on the report so i m assuming i would need to use the "New Page After" option on the Group Header immediately above the Detail section since I m planning on displaying the records mentioned above in the Detail section.

It would be great if this can be done using a formula because I have some more requirements that are based on the condition mentioned above i.e. if there are more than 3 records that are matching a criteria then I need to display a message etc.

Please help me with your suggestions.

Thank you.

Hi Kevlray,
Thanks for your prompt reply. I have tried using the shared variable option in a formula & placed it in the DETAIL SECTION to count records based on condition like this:

shared numbervar x;
if ({table.fieldname}) <> 'Y' then
x:=x+1;

but when i place the below formula in GROUP HEADER "New Page After", it doesnt work (i think it is because Group Header is ABOVE the Detail Section and the shared variable has not calculated records in the Detail section, but then how do i count Detail Section records dynamically i.e. before they print):

shared numbervar x;
if x > 3 then
true

Please help...


Edited by forum_usr - 17 May 2012 at 6:32am

Then again maybe you need to put the check in the details section.

Thanks for your suggestions Kevlray. I'll try these options and hopefully get it to work.