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’ or perhaps ‘New Page Before’ 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.
forum_usr (BOB member since 2012-02-15)