Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Decomposition Tree in SSRS !? Expand / Collapse
Author
Message
Posted Wednesday, October 10, 2012 11:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 156, Visits: 567

Hi geniuses!
Is there a way to create some sort of 'Decomposition Tree' in SSRS?
I want to be able to click on a bar from a chart and retrieve data from that bar.

Is there a solution?

Thanks!
Regards!
Post #1371069
Posted Wednesday, October 10, 2012 2:46 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 8:25 AM
Points: 1,467, Visits: 922
Create another report that has the detail data with a parameter of whatever that bar represents.

Then on the Chart data Series Properties, in Action, Change to Go to Report. Calling your new report and passing in necessary parameters.
Post #1371121
Posted Thursday, October 11, 2012 2:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 156, Visits: 567

Thath was my plan, but it is possible to make a bar chart clickable?
What can be done, that I know of, is make all the report clickable.

Thanks
Regards
Post #1371291
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse