SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Drilldown call data on request - is it possble?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

elinor
Starting Member

1 Posts

Posted - 09/17/2012 :  11:42:26  Show Profile  Reply with Quote
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




  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000