Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Grouping Problem

Status
Not open for further replies.

UHNSTrust

Technical User
Dec 2, 2003
262
GB
Can somebody help me on how to hide headers and footers on a report (sounds easy)

I have a report that displays a page header on every page.

I then have two groupings on Type and Site.

Each Type can have one or multiple sites. What I want to do is when there is only one site for a type then to hide both the header and footer for that site.

From this
Type 1(header)
Site (header & footer)
Site (header & footer)
Type 1(footer)
Type 2(header)
Site (header & footer)
Type 2(footer)
Type 3(header)
Site (header & footer)
Site (header & footer)
Type 3(footer)

To this
Type 1(header)
Site (header & footer)
Site (header & footer)
Type 1(footer)
Type 2(footer)
Type 3(header)
Site (header & footer)
Site (header & footer)
Type 3(footer)

I hope this makes sense. I can get it to hide the Type footer when there is only one site (but not the other way round)

Thanks

Jonathan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top