Section Footnote

steffenn

New member
Local time
Today, 08:34
Joined
Jan 14, 2002
Messages
7
My table has a field called 'Comments'. Very few records in the table have a comment.
In the report, most of the record's fields are listed in the Details section. I would like the corresponding comments (for the few records that contain comments) to list in the Section Footer. Only 1 comment will display.
How can I display multiple comments in the Section Footer?
Thank you for your help. nls
 
I'm not totally sure why you want them to appear in the footer (if it's just that you don't want to enlarge the detail section, have a look at the CanShrink property in help.

However, if you do need them in the footer, your best bet might be to create a subreport. Base the subreport on a query which returns records with a non-blank comments field. This query would return the comments fields plus whatever other value(s) is needed to identify the section of the report the entries should appear on.

Use this subreport in a subreport control in the footer, remembering to link it via appropriate fields so that only comments for the current section appear.

Simon
 

Users who are viewing this thread

Back
Top Bottom