Hi
I have a report which is grouped on a column. I need to start each group
on a new page and I have to reset page number on start of a new group.
Finally I have to capture the number of groups created and the no. of
pages per group on the front page followed by group details on the next
page.
Suppose 3 groups get created , Gr1 has 3 pages, Gr2 has 4 pages , Gr3
has 1 page
Front Page will have
Gr1 : 3
Gr2 : 4
Gr3 : 1
This page will be followed by the details of each group.
I use a formula field which has a shared array to capture the total page
no. created per group on change of each group. I set this at the Group
footer
something like this:
shared numberVar array PageCount;
shared numberVar PTCount;
PageCount[PTCount]:=TotalPageCount;
PTCount:=PTCount + 1;
Then I use another formula field on the front page which returns the
page no for a given group.
WhilePrintingRecords;
shared numberVar array PageCount;
PageCount[RecordNumber];
But the problem here is , when front page is being printed array
wouldn't have been populated and hence prints as 0. How do I make the
formula field in the front page evaluate in the end after all the groups
are created and their total page nos. are captured in the array. Some
thing like EvaluateAfter.
Your help is highly appreciated.
Regards
RJN
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!