Drilldown report isue

[dzavad]

Hi, I have drilldown chart report which is working good , However,Second layer screens are repeating the Third layer data. Only the first screen stays, the others need to be removed/supressed.The only way I want the user to acces the layer data is by clicking on the chart itself not by navigating the report.
It took me a while to figure this out.
EX: If I Click on a month for Bedford 2005 (ie, 09/2005) 6 screens of data is presented.
Using the arrow to page through them, they break down the events into departments
BUT
Only screen 1 of 6 is valid at this layer. It is the same exact data as shown on the third layer.
Note...I am suppressing this extra pages by suppressing it with the Pagecount >1. However , I do have an extra empty page right after the first one.
Any sugestions?

 

[BruceBussell]

Have you looked at using DrillDownGroupLevel to decide when to print pages for various drill down levels

DrillDownGroupLevel -- Returns a number that indicates the group level of the current drill down view, or 0 if it is not a drill down view.

Examples
If a report has groups on Country and Region, then DrillDownGroupLevel returns 0 in the view without drill downs. Within the drill down view for a Country, DrillDownGroupLevel returns 1, and within the drill down view of a Region, DrillDownGroupLevel returns 2.

To check if you are in a drill down view, test to see if DrillDownGroupLevel > 0 returns true.

 

[dzavad]

Thanks a lot that helped....