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.
Beverly PenneyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

planoczCommented:
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.
0
Beverly PenneyAuthor 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?
0
planoczCommented:

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.
=Fields!MyNewData.Value

I think this might work for you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.