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
Is this something as simple as grouping on the Region?
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.