Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a 'Report Footer'
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Miscellaneous
Thread ID:
01373630
Message ID:
01373648
Views:
21
>>>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?
>>
>>Simple. Add Print when condition for recno() = Total number of records in the table.
>
>Not that simple if you have some active ORDER ;-)

Right. We may also try to use report variable to count number of records and then compare it with the recno(), not sure if this would need to be adujsted by +/-1.

Oops, this would not work, e.g. we can not use recno() here.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform