Print Page | Close Window

Display page header in drill down

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6649
Printed Date: 19 Apr 2024 at 8:04am


Topic: Display page header in drill down
Posted By: bacham
Subject: Display page header in drill down
Date Posted: 10 Jun 2009 at 7:13am
I have a simple table report with a single group. For each column, I have a summary field. I hid the "Details" section using "Hide (drill down OK). So the top level of my report displays the groups with the summary information for each column. When I click on any line in the column, I get to the details for that particular line.

My problem is that the details page does not list the page header. This makes it difficult for the user to figure out what each column means (unless he has a good memory or constantly switches back and forth between details and summary).

Any ideas how I could display the page header in the details section? If I just add a header in the details section, the header gets repeated for each row.

Hicham


Replies:
Posted By: rahulwalawalkar
Date Posted: 10 Jun 2009 at 7:38am
Hi
This is what needs to be done
 
Right Click the existing Group Header and Insert Section Below it will create a New Group header GH1B .
 
Place all the labels from Page Header in the newly created GH1B .
 
Then right Click GH1B Select Section Expert then go to Common Tab and Click X+2 next to Suppress(No Drill Down) and enter the code below
 
DrillDownGroupLevel = 0
 
 
 
Cheers
Rahul

Posted By: DBlank
Date Posted: 10 Jun 2009 at 7:56am
You can also use this option (maybe in conjunction with Rahul's suggestion).
Go to File and select Report Options
There is an option for "Show All Headers on Drill Down".
If you mark this as TRUE all of the headers(and footers) will continue to appear as you drill down.
Somethimes this gets to be too much infomration and you will need to incorporate some of the conditional suppression functionality using the DrillDownGroupLevel option that Rahul suggested.

Posted By: bacham
Date Posted: 10 Jun 2009 at 8:40am
Thanks a lot Rahul! It worked.

Hicham

Posted By: bacham
Date Posted: 10 Jun 2009 at 8:45am
Hi DBlank,

I also tried your suggestion as it seems to be simpler. Unfortunately, after I check the box and dismiss the Report Options dialog, I get an error dialog saying (translating from french):

"Invalid argument. Details: Please choose a Java Bean Class"

I'm not exactly sure how my data source works as Crystal Reports is integrated with another product that seems to generate the data source on the fly and pass it to Crystal (I suppose as a Java Bean based on this message).

Any ideas?

Hicham

Posted By: DBlank
Date Posted: 10 Jun 2009 at 9:38am
Haven't heard of that causing any problems before. Too bad it does not work. It can come in handy if you use drill downs frequently.


Print Page | Close Window