How to create chart off table in SSRS
Hi,
I have created a report in SSRS. All good.
This report shows a simple table containing monthly totals and used a running value expression to cumulatively add up the monthly totals per year.
For example:
Aug Sep Oct Nov Dec Jan
....
2008/09 1 6 18 25 44 54
2009/10 2 5 15 22 43 61
2010/11 1 9 18 29 49 63
What I would like to do , is create a chart based on this data. But I cannot used the running value to graph the cumulative totals.
Can anyone help please?
April 19th, 2011 6:01am
I have figured it out.
I ignored the table and used my dataset values.
Then in the grpah , I used the following to calculate the running total in the chart series.
=RunningValue(Fields!*******.Value, Sum,
">chart member group name , found in properties>")
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 7:16am