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

Skipping levels when drilling down

Status
Not open for further replies.

skicamel

Programmer
Dec 24, 2001
126
US
Example: A report with drilldowns on these groups: level 1 STATE, level 2 CITY, level 3 RATE GROUP, level 4 contains the detail.

Is there a way to set up the report to skip a level, say, drilldown CITY and receive the customer detail? I don't want to lose the RATE GROUP level data if I need it.

I've tried allowing the detail to be drilled down and suppressing the RATE GROUP header, but it won't let me drill down from the CITY group.

It's not life or death, and I can always create multiple reports, but I am very curious if there is a way to do this.

As always, thanks all.

Dan

 
It sounds like what you tried is what should be done.

On the Group Tree, right click the area of interest and select drill down, it should show the detail.

When you've suppressed a group between, I don't think that you can drill in directly on the report data.

-k kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top