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!

Group header in each page

Status
Not open for further replies.

AurobindoSaha

Programmer
Mar 11, 2004
57
US
Hi,

I have a report with two drill levels where each level is shown or supressed on the level one is in. Clicking on the records in the top level takes supresses the group footer and header of the first level and displays the second level.

The problem is that the headers are not displayed in the first page only and not in the following pages. I like to display the headers and footers in each page of the drill level the user is in. I have already checked the option show group header in every page. In the supress formula the following formula is used.

Supress Formula
===============
WhilePrintingRecords;
if {@DrillLevel} <> 0 then
true
else
if OnFirstRecord and {@DrillLevel} = 0 then
FALSE
else if not OnFirstRecord and {@DrillLevel} = 0 then
TRUE
else
FALSE

Note: {@DrillLevel} is a formula which returns 0 for top level and 1 for 1st level.

Your sugession will be appreciated.
 
There is an option under File, Report Options called "Show All Headers on Drill Down".

Also, if you are using CR9 or 10, there is a function that you can test for called "DrillDownGroupLevel". It returns a number indicating which group you are drilled into and you can test for it accordingly. Take a look at it in help if you are using one of the above versions.

~Brian
 
Hi,

Thanks for your reply.

Well I am using CR 8.5. I used "Show All Headers on Drill Down". It doesnot work. I donot have the problem to identify the drill level I am in. My problem is to show the group headers in all pages of that level.

Aurobindo
 
Right click the group and select change-group->Repeat Group Header on Each Page

-k
 
That option is already checked. Is there any way I can email you this report and discuss the issue over phone? That's the best way to explain and work on this problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top