• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2248
  • Last Modified:

Create a Running Total for a Line Graph in SSRS 2008

I am trying to produce a monthly report of charges and then show that information in a graph in SSRS 2008.  I have the table working fine i.e. it is generating the running total using the following expression =RunningValue(Fields!Charges.Value,Sum,"Group1") .  How to do I get those values to show as the data fields in my line graph?  My query is a basic SQL that selects a couple of fields, date, service and then sums the charges for each day and service.
Rhonda Carroll
Rhonda Carroll
  • 2
1 Solution
You should be able to place a chart control on your report then you take your mouse and right click -n-hold to drag -n-drop on to the rightside of the chart and on the bottom of the chart. A easy sample would be to look at how excel  uses a chart. SSRS chart reports basically do the samething.
Rhonda CarrollAuthor Commented:
I can add a chart based on the criteria in the query ... the problem is i have a calculated field that is creating a running total by network ... basically a Month to Date report.  To calculate the running total I have used the Running Value function in SSRS .... I can't get the running total amount to show in the chart as the formula doesn't work as there is no group in the report data ... unless of course it is in the table.

Is the only way to ge this to work ..... create a running total amount in the SQL query?

Add a Field to your Report Dataset (By Right clicking on the dataset name) add Name Like MyNewData.
Use the Fx Expression button to make your IIF statement.
Example: =RunningValue(Fields!Charges.Value,Sum,"Group1")
Then add your new column and place this in it.

I think this might work for you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now