Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Total No. of Pages in a Report
Message
 
À
19/08/1998 21:45:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00128007
Message ID:
00128352
Vues:
23
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."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform