>Need to determine # of pages a report will print so that I can make sure that the user is aware that there may be more pages to be printed yet:
>
>i.e. Footer on a report------------
>Page x of n
>
>Any ideas anybody?
I got another new idea but need to recalculate it manual if you resize the
height of header, footer, detail, or change paper!!
Num_of_Detail_perpage = Ceiling(PageHeight - HeaderHeight - FooterHeight)/Detailheight)
* This need calculate manually! (Double-Click Header, Detail Bar to got the
* value in Report Designer!!
* Of cos, You can count it by print a testing page!
TotalPage = Ceiling(RECCOUNT()/Num_of_Detail_PerPage)
Suppose Num_of_detail_Perpage is 18.
Then, the footer marker will be:
[Page ] + ALLTRIM(STR(_PAGENO)) + [ of ] + CEILING(RECCOUNT()/18)NOTE: The Reccount() will recall the search on View and if you have ?Variable
will ask twice time!! If you have assign the Variable first.
It will work fine!!
If have any enhance method to find the Num_of_Detail_PerPage,
pls Tell me! ^_^;
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.