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

Prevent drilldown based on parameter

Status
Not open for further replies.

CFDude

Programmer
Nov 7, 2001
316
US
Hello! I have a report that has a number of regions with a total for each region (from there you can drill down to the districts in that region and so forth). I have about 7-8 regions and I have a web page that the users log into -- I can pass a parameter to the report for their region. What I want to do then is to allow the user to see the first page with all the totals for all the regions, but only allow them to drill-down on their region only. (e.g, I show totals for regions 1-7, but if my region is 5, I can drill down just on region 5)

Does this make sense? If so, can it be done?

Thanks!
Tim P.
 
I too ran into a similar problem when doing a drill down or on demand sub report in that it won't pass to the subreports conditions or parameters used in the main report or non drill down subs. I do not believe it can be done.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top