Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page no.
Message
 
 
To
29/11/2000 13:39:39
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00446920
Message ID:
00446948
Views:
13
>How can I specify the last page number of each group?
>
>Any help will be greatly appreciated.
>
>Thank you.

Hi Liza,

Do you want for each group something like Page no 1 of 15 (number of pages in a group), right? It's a little tricky, but could be achieved by following:

You will have to run your report twice.

In Group Footer on entry add call to a function.
Your underlying cursor (or table) should be read-write and have a Field TotGrpPage. In this function you do replace TotGrpPage with _pageno (it would put this info in the last record for this group). Now your table has this information, so you should replace each record for each particular group with this info. (find the way by yourself).

And now you can run your report without problems.

Another similar idea would be populate another cursor with this info, like:
GroupID LastPage (in the function, what called in GroupFooter.Entry), then run SQL to append this info to your table/cursor.

Let me know, if you need some further assistance to make this idea work.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform