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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill Down query (Conditionally display field names)

Status
Not open for further replies.

Bunting

MIS
Mar 19, 2002
50
GB
Working with CR v9...I have a very simple report with five groups in :
GH1 Client
GH2 Contract
GH3 Load Period
GH4 Status
GH5 Agent

Each of these groups has "Hide(drill down o.k)" checked. When you drill down within the report and reach the details section I want to show field names above the details section, However I don't want them visible before you reach the details section.

Any suggestions on how I can achieve this would be welcome.

Many Thanks
Bunting
 
With CR 9 came the ability to test for what the current drill down level is (DrillDownGroupLevel). What section are your headers in? If, for instance, you had multiple GH5 sections, with GH5b containing the headers for the Detail fields, you could enter a suppression formula for the GH5b section like this:

DrillDownGroupLevel <> 5

So only when the report is drilled all the way down to the Detail level will the headers show.

-dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top