Adding Drill Down causing additional rows

[brianweb]

I have a two page report.  First Page is a list with Regions, a few values and a subtotal at the bottom .  Second page has same information with both Region and Territory (Territory is a subset of Region).

The functionality I want is for the user to click on Region in the first page and have it jump to that Region/Territory section of the list on the second page.  I am using this with Drill-down to a Bookmark driven by the Region Data Item.  The functionality works, however as soon as I add the drill down to Region on Page 1, instead of just showing the 4 Regions, it repeats the Region for each Territory.  For example if Region 1 has 14 Territories, on page 1 after adding the drill down, it will repeat the Region 1 item 14 times with each Territory value being shown.

What can I do to prevent the Region from repeating?

Thanks,

Brian

[BigChris]

Is this something as simple as grouping on the Region?

[brianweb]

So that wasn't it as grouping it displayed Region once in the first column, however the values repeated 14 times.

However I started from scratch and now it works.  I am wondering if adding the subtotals before or after doing the drilldown affected it.  So good news is that it is working, bad news is that I am not exactly sure why.  Oh well!  Thanks.