Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Drilldown call data on request - is it possble?

Author  Topic  elinor Starting Member 1 Post Posted - 2012-09-17 : 11:42:26 Hi there, I have been looking around for something similar to what I am trying to achieve with SSRS 2008 R2, but to na avail. What I need to do is a report with drilldown to lower levels. I know I can ue the visibilty property to achieve that. However the report has some data volume concerns. What I am after is : Let's say I want a tree like structure on the report , but the lower levels to only be expanded when a user clicks on a plus sign. For example if I want Structure like Continent CountryName Cities Then on Level One I need - column names I always want on the top + Europe + Asia + America Let say user clicked on the Plus sign of Europe I need to now display: Continent CountryName Cities - Europe + France + Italy + Asia + America Then when user clicks on France I need to have : Continent CountryName Cities - Europe - France Paris Bordeaux + Italy + Asia + America this kind of drill down, but I dont want all the data to be returned at once. My idea is top level (when the report is initially ran) to be returned by the dataset first , then when a user clicks on plus sign to expand Continent , the Continent name to be bound to a parameter and passed back on to the data set and to only populate the Countries that are in that continent, then when user clicks on country name that country name to bound to a parameter and passed back to the dataset query so it only return the cities for the selected continent and country all other nodes remain collapsed. Could anyone help please. Any suggestions would be greatly appreciated