I have to create a report as following: Its very Urgent
The above 4 are the hierarchies.
Each hierarchy should behave as a drill down.....I have to write a stored proc...for that.
At first the report show only Europe and all the RBU's...Then when I click any RBU--- It should display the Countries Below for the Selected RBU...Same with the Country....If I click the Country the Dealers under selected country should be displayed...
Without using the drill down functionality in SSRS...we need to acheive it in T-sql...
If you are using PerformancePoint Services , decomposition tree as an interactive arrangement of bar charts that
makes it easy to explore contribution relationships. It provides an effective alternative to the “Drill Down To” feature in analytic charts. While in Reporting service, I think we could only utilize the drill-down function to achieve this function
effect, I am a little confused about how to achieve this using store procedure.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.