Running Value Chart in SSRS – How to get each series to start at 0

reporting-servicessql-server-2008

enter image description hereenter image description here

I have a table in SSRS, with income from two campaigns.

My columns are:

  • serialnumber
  • DateOfPayment
  • PaymentAmount
  • DaysSinceCampaign
  • Campaign

I want my chart to plot a running total of paymentamount by DaysSinceCampaign for each campaign (bs13 and bs12). I'm pretty close, as shown above – but for some reason, the BS13 campaign starts at 20,000, appearing to be adding on to BS12 – when it is supposed to start at 0.

In the Values section for Chart Data, I have used this formula:

=RunningValue(Fields!PAYMENTAMOUNT.Value,SUM,nothing)

I have tried changing 'nothing' to "campaign", and have tried defining 'Campaign' as a row group and a column group – but it keeps returning the same error: that the scope parameter must be set to a string constant equal to a containing group.

Best Solution

The scope here needs to be the name of the Series Group you set up in the chart, not the Column Group of the Tablix that is set up below, something like:

enter image description here

I created a simple test based on:

enter image description here

With the Chart data expression set to:

=RunningValue(Fields!PaymentAmount.Value, Sum, Nothing)

I got the following:

enter image description here

Which is incorrect, but similar to what you're seeing.

If I change the expression to:

=RunningValue(Fields!PaymentAmount.Value, Sum, "Chart1_SeriesGroup1")

I get the following:

enter image description here

Which is correct, so it seems like you're just going to have to set the Scope to the correct Series Group name.

Related Question