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

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

Other recent topics Other recent topics