Hiding Report Sections

V

Vel.

Maybe I'm forgetting some elementary piece of knowledge, but I have a question.

I have a report containing client names, dates of service, and payments by
themselves or third parties. The report is based on a query which relates
client information to services performed (activities) and then to payments by
activity in a pair of 1-many relationships. It is formatted thusly:

GroupHeader/Footer: ClientID
GroupHeader/Footer: ActivityID

The detail section contains payment detail by activity. However, it also
contains vertical and horizontal lines and a calculated field based on the
type of payment. The ActivityID footer contains balance information. I do
not want to print the detail section or the balance information if there is
no payment. However, due to the calculated field and the lines it still
prints one row of the detail regardless (which is empty). Is there a way to
hide the detail section only when it has no data while still preserving my
formatting for those records which do have data in the detail section? I
tried an OnPrint and OnFormat event, but that seems to effect all records on
the page.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Footer, multi-column rpt 5
Gouping In Sub Reports Leaving Windowed Headings 2
Printing of sub-report skips to second page. 7
Grouping problem with labels report form 6
Using VBA to hide a report's detail section? 1
Box around my sub report 1
Suppress a section if the subtotals equals zero 1
Hiding Report Section on Data 2

Top