Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with _pageno variable...
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00186805
Message ID:
00186809
Views:
22
Now I've re-read your post and I'm a bit confused. Always print on the last page is exactly what the summary band does. Is your problem that you don't want it to creep up if there aren't enough records to put it at the bottom?

Darn. I was all set to say "try setting all the objects in it to [ ] Fix relative to bottom of page". But that option is disabled for items in the summary band, for some reason. And there's no option for "Put it at the bottom of the page" in the report's Title/Summary dialog. I'd swear there was a box to check for this in 2.x Report Writer. Where'd it go?

Sorry,
Rich.

>Well, you could create a variable just before you issue the REPORT NOCONSOLE and store _PAGENO to it in a one-line UDF called from an object in the summary band. (i.e. make a report object whose expression is SavePageNo() or whatever, and SavePageNo can be Var = _PAGENO, RETURN CHR(0).)
>
>But someone else will probably have a "slicker" solution.
>
>HTH,
>Rich.
>
>>I am trying to have my report summary band ALWAYS print at the botom of the last page on the report. (using VFP6)
>>
>>My idea was...
>> ...run the report once with the the NOCONSOLE parameter to see how many pages there are (by examining _pageno) ... Then I add a blank record to the temporary report table, and "report form ... noconsole" again and again until I finally roll over to the next _pageno, then I delete one record, and then I know my summary wil be just at the end of the last page.
>>
>>However, the _pageno variable does not seem to give the correct page count after the report is completed. In preview mode, the report prints about 4 lines on the second page, then prints the summary band which is about 5 lines long). But after the report runs, _pageno is equal to 1.
>>
>>How can I capture the real exact page count? Or, how can I get the summary band to the bottom?
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform