Adding long blocks of text at the end of a report

[Guest]

Hello,
I have created a series of reports. At the very end of each report after
the last record, I wish to have an area of text where I can explain the
report and offer suggestions/examples on how to understand the data. Being
very long-winded, I can't fit all my explanation text into a single 255
character text field - most would be around 2000 characters. I tried
combining multiple fields into one but that multiplied the number of records
shown in the report.
Any suggestions on how to show my explanation notes at the very end of the
report will be appreciated. Thank you.

 

[Guest]

Why the 255 character limit? You can either use a field from the database
(create a table with the info about the reports), then you can make the field
as long as you need.

Alternatively, you can set the control source of the field at run time. J.

 

[Guest]

Thank you for your speedy reply.
As I'm typing this, I think I realized my ROOKIE mistake. I should have
used a memo field, not a text field and the 255 limit would be raised to
65,535 or in some cases unlimited.
Now, putting this text into the report at the very end...
I put the text box in the Report Footer. Then, I put the memo field in the
query that feeds this report and it added these fields to each line of the
query - unnecessary and does no harm so that's fine. When I run the report,
the full text shows on its own page at the very end. Good!
My last question (for now) is whether it is possible to get rid of the Page
Header for that last page and either leave it blank or have a new header for
that last page.
Thank you.

 

[Steve Schapel]

PZ,

Have a look at the Page Header property of the report. One option is
you can set it to "Not with Report Footer", which generally means it
won't print on the last page of the report. This may serve your purpose.

 

[Guest]

Steve,
Thanks for your reply. That was just the answer I needed! Thanks.