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.