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?
ShamanthAsked:
Who is Participating?
 
shivkasiCommented:
1. write a formula and place it on the RF where sub report is placed (suppress the formula)
whileprintingrecords;
booleanvar PHSuppress;
PHSuppress := True

2.  Now Go to page header section of the main report > section expert ( right click on page header) > open the formula box placed beside "SUPPRESS" > place the below formula
whileprintingrecords;
booleanvar PHSuppress;
PHSuppress


0
 
ShamanthAuthor Commented:
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.
0
 
ShamanthAuthor Commented:
Got it. But how do I supress the formula? It is displaying 'True'  on RF where the subreport is placed.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
ShamanthAuthor Commented:
Worked.. Thanks!!
0
 
James0628Commented:
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
0
 
ShamanthAuthor Commented:
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..?!

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.