Link to home
Start Free TrialLog in
Avatar of Shamanth
Shamanth

asked on

Hide Main report headers at sub report level

I have a subreport on RF and I am showing it in the end of the report and ion a new page(Checked the 'New Page Before' option in section expert)

I don't want the main report page headers to show up above Subreport. The sub report already have headers at RH and it has completely different data. How do I hide the main report headers while displaying the sub report?
ASKER CERTIFIED SOLUTION
Avatar of Shiv
Shiv
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shamanth
Shamanth

ASKER

Shivkasi,

I did te above with Supressed box checked and pasted the two formulae on PHb and RHb. Now I don't see the sub report at all !!   It is completely supressed.

PHa Has Logo -- I need it for Sub reports too.
PHb has Main report Headers--- I don't want them to showup on subreport page
RHa has Counts/Total of Main report -- I don't need them at sub report page
RHb is where the subreport is placed.
Got it. But how do I supress the formula? It is displaying 'True'  on RF where the subreport is placed.
Worked.. Thanks!!
Avatar of James0628
FWIW, you may also be able to just use OnLastRecord as the suppression formula for the page header section.  When you get to the last page with the subreport, the last record should have been read and the page header should be suppressed.

 No points necessary for this.  I just wanted to throw it out there as a possible alternative.

 James
Mlmcc,
I did nothing special. I followed the Shivkasi's steps. Initially, I was looking at a wrong place.  Can somebody explain how it works..?!

On the section expert, if I check the box, then it will not work. What is the difference between checking and uncheckinh the box.
I created a formula as mentioned by Shivkasi and supressed the formula and put that formula on RF and it worked .