Hi All,
suppose i have the following data in detail section:
column A Column B
A…NY
B…London
C…Paris
D…London
E…London
F…Berlin
G… London
also, suppose that I have a group on some other field in the report besides the fields that i m mentioning above (just trying to say that there is group header and footer in report as well)
In this scenario, how will i make a formula that counts the number of times ‘London’ appears and if it appears more than 3 times, it moves the records to the next page.
Please help…
forum_usr (BOB member since 2012-02-15)
So to clarify, you would like to only display the following on page 1:
A…NY
C…Paris
F…Berlin
and on page 2, you would like the following:
B…London
D…London
E…London
G… London
If the example on top is accurate, I would first create 2 identical tables. For the first table, I would create a condition limiting the data set to cities that have a count of less than ‘3.’ In the second table, I would create a second table and only display objects when the city count is 3 or greater. Be sure to create a page break so the information on table 2 displays on a seperate page.
And as far as grouping goes, would you be able to simply create a section based upon the other object you want to incorporate?
I’m hoping I understood your question correctly and hope this helps!
indy (BOB member since 2004-04-08)