Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Dynamic charts Expand / Collapse
Posted Tuesday, April 2, 2013 10:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 6, 2016 2:29 AM
Points: 45, Visits: 145

I need a little bit of advice on the following:
I have a simple matrix in my report showing company name as a row and date as a column.
The value in the report shows the number of employees per company on a specific date.
So when I run the report it shows the number of employees per company per date.
When I click on a random row (representing a certain company) I would like a chart to appear with only the values for that selected company. When I click on another company the chart has to show the number of employees for that other company. So the chart has to change dynamically depending on the company you click on.
My starting point is always the table.

I think it sounds quite simple but I am wondering how to do this in SSRS 2008 R2 ...

Hopefully there is someone to give me an advice.

Post #1438008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse