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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it. But how do I supress the formula? It is displaying 'True' on RF where the subreport is placed.
ASKER
Worked.. Thanks!!
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
No points necessary for this. I just wanted to throw it out there as a possible alternative.
James
ASKER
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..?!
I did nothing special. I followed the Shivkasi's steps. Initially, I was looking at a wrong place. Can somebody explain how it works..?!
ASKER
On the section expert, if I check the box, then it will not work. What is the difference between checking and uncheckinh the box.
ASKER
I created a formula as mentioned by Shivkasi and supressed the formula and put that formula on RF and it worked .
ASKER
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.