Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Summary at bottom of page?
Message
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00098885
Message ID:
00098961
Views:
33
>>>>>I have a report in FPW 2.6 that needs to print some summary info at the end. This needs to be printed at the bottom of the last page. Anybody know of a good way to accomplish this without counting lines?
>>>>>
>>>>>TIA
>>>>>Paul
>>>>
>>>>Paul,
>>>>Try using the summary band. Located under report menu title/summary.
>>>>
>>>>HTH
>>>>Jeff
>>>
>>>I can use the summary band, but how can I force it to print at the bottom of whatever page it is on?
>>
>>Maybe I did not understand. Summary will print after last detail or group footer by default. You can select a new page if you want, but it sounds like you want something else to happen? Am I correct?
>>
>>Jeff
>
>Correct. Summary prints at the right point in the document, but it needs to be forced to the bottom of the current page. Basically, the summary will include a nice little message and a prompt for a signature. This needs to print at the bottom of the last page in the report. Summary just prints wherever it is in the page.
>
>BTW: this would also be nice for people who want an invoice which prints subtotals,tax, etc in boxes on the bottom of their invoice.
>
>Thanks,
>Paul

Hi Paul.

You can do like this if you just want to display text at the bottom of
the last page:

1. Put a field in the page footer. Call a function from the
field ,FUNC("ALIAS"), with the alias of the report cursor.

2. Create the Function and do the following test:
PARAMETERS pcAlias
IF RECCOUNT(pcAlias) = RECNO(pcAlias)
*** You can replace RECCOUNT() with a variable with the number of records
*** if your not using a cursor.
*** Report has printed the last record and the text is returned.
RETURN "TEXT"
ELSE
*** The textbox is empty if your not on the last page
RETURN ""
ENDIF

/Magnus Nordin
Magnus Nordin
VFP MCP

"We have tested the GUI on 5-year olds. Why? Beacuse they aren't braindead!"
Michael Spindler, Apple

Previous
Reply
Map
View

Click here to load this message in the networking platform