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

SSRS Dashboard-Passing Parameters in the same page Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 9:35 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
Hi All,

I have to create a SSRS dashboard which would contain many reports in the dashboard main page.

Say, I have a Tablix report containing two fields:-

Country Total Regions
India 5
Sri Lanka 2

Now, when I click on the field total regions, say in this case If I click on 5, a chart to be displayed on the same report page showing the 5 different regions

Is that possible in SSRS?? I don't want to jump to a new report via actions. I wanted the chart to be displayed in the same main page. How would I pass parameter Country and display the chart in the same report page

Any help on this?

thanks,

Varsha
Post #1352320
Posted Monday, October 08, 2012 7:01 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, December 19, 2013 10:40 PM
Points: 116, Visits: 395
Hi,
Go to this link
http://www.bi-rootdata.com/2012/10/drilldown-dashboard-in-ssrs.html
Post #1369789
Posted Tuesday, October 09, 2012 4:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:18 PM
Points: 234, Visits: 2,615
Use a toggle for the hidden field to show or hide the chart
Post #1370291
Posted Tuesday, October 09, 2012 12:02 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
Okay Thanks !! I shall try it ..
Post #1370520
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse