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
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