Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a 'Report Footer'
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Divers
Thread ID:
01373630
Message ID:
01373654
Vues:
23
Can we use _PAGETOTAL in VFP9?

Here is the unrelated message, but I was just checking the variable...

Re: Page x of y in a group Thread #1334332 Message #1334483

>>Boss man wants a count to appear on the last page of the report
>>
>>Due to the vagaries of the data gathering requirements on this report, I cannot use a summing field for the count, I have to run another query and pass the count into the report as a variable. Since the count is in the Page Footer, it is showing up on every page.
>>
>>I just need it to print on the last page. Any suggestions?
>
>Add a Summary band, but all the objects will appear just at the botom of the last row. If you want something to be printed in the last page footer band you must use this:
>
>1. Add that in the page footer. Set the Print When to be RECNO("Alias") = RECCOUNT("ALIAS")
> That is valid ONLY if you base your report to a CURSOR and that cursor has NO ACTIVE INDEX opened
>
>2. Add that in the page footer. Set the Print When to be _pageno = m.lnTotalPages
>Then You should run the report that way:
>
>lnTotalPages = 0
>*** run the report only to get total number of pages
>REPORT FORM ..... TO FILE NULL NOCONSOLE
>lnTotalPages = _pageno
>*** actual report execution
>REPORT FORM ..... TO PRINTER PROMPT PREVIEW
>
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform