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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics