Hmmm... Clever ha! This idea works fine if your dataset have no records marked for deletion. Maybe files created using SQL-Cursor, SQL-Views which are not directly utilizing the source tables.
>>Hi To All!
>>
>> What are the ways to know the Total No. of Pages in a report. I want to appear my page number as "Page no. # of #".
>>
>>Thanks and Hope somebody can help me.
>
>
>In my view, I suggest you to find out the number of record printed per page!
>For example, if you can print 12 records per page after you try it.
>
>Then, the value of Total page will be:
>
>CEILING(RECCOUNT()/Rec_Per_Page)
>
>and thus the Page Statement will be:
>
>"Pages " + rtrim(str(_pageno)) + " of " + rtrim(str(CEILING(RECCOUNT()/Rec_Per_Page)))
>
>But if you use View with open Query:
>
>i.e. Select .... where Master.MainKey = ?PrintKey
>There will be two times to ask the PrintKey!!
>
>So, if you set the variable with value already, it will work perfectly!
>
>The most inconvient thing is to test out how many record per page!
>Good Luck!
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."