Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to print numbers of pages in Report Designer
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00235315
Message ID:
00235659
Views:
24
>I need to print number of pages in a report, like 1/n (page one of n pages).
>
>How Can tell me?



Well, I have thought another Formula to do, but it is hard to maintain IF
you always modify the detail brand height!!


Thm.:
Total Pages = Ceiling(RECCOUNT() / Num_of_Deatil_Per_Page)


Thus, you need to try to print over one page to obtain the
Number of Detail printed per page....

Then, simply put this number at constant to use...

Page 1 of n will give the syntax:

[Page ] + Alltrim(str(_pageno)) + [ of ] +
Alltrim(Str(Ceiling(RECCOUNT() / 12)))

but the most poor thing is if you need to modify the report detail brand height,
you need to change to correct number base. ~_~




Both methods has good and weak points.

Print twice:
Easy to maintain, but waste much time as search twice.
If each search worth more than half minute, it is not reasonable for user to wait!

Use Formula:
Fast, but hard to maintain if detail brand height always change...
Need to use Local/Remote Views to print as the RECOUNT() Don't count any deleted record after set delete on...

There is still no best solution, for me, as most report are put into standard pre-print report, the detail brand height nearly unchange...

So, I use Formula to do.

Anyway, best wish to you! ^_~
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform