dynamic generated chart
Hi,
Is it possible to automatically generate tables based on a multi-value parameter?
For example: If I want to see the amount of sales per employee per department, where department is a multiple-value parameter, and for each department a new chart is generated.
Greetings,
SauliusSCSM-apprentice
April 28th, 2011 10:21am
If you create a report that as a chart with the necessary parameter in your case the department
Save the chart and add it as a sub report into a tablix row details group in the report u have created already
Group the details row by department fields
That should create a new chart for every department group returned based on the parameters.
Note that you will have to configure the sub report with same department parameters
You can find more info on subreport here
http://msdn.microsoft.com/en-us/library/ms159837%28v=SQL.100%29.aspx
and an example step by step help here
http://msdn.microsoft.com/en-us/library/ms160348.aspx
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 12:22pm
wouldn't have thought of it :-), I'll try it today and keep you posted, but sounds promising :-)SCSM-apprentice
April 29th, 2011 2:03am