sql server 2008 - Running Value Chart in SSRS - How to get each series to start at 0? -


enter image description hereenter image description here

i have table in ssrs, income 2 campaigns.

my columns are:

  • serialnumber
  • dateofpayment
  • paymentamount
  • dayssincecampaign
  • campaign

i want chart plot running total of paymentamount dayssincecampaign each campaign (bs13 , bs12). i'm pretty close, shown above - reason, bs13 campaign starts @ 20,000, appearing adding on bs12 - when supposed start @ 0.

in values section chart data, have used formula: 

=runningvalue(fields!paymentamount.value,sum,nothing)

i have tried changing 'nothing' "campaign", , have tried defining 'campaign' row group , column group - keeps returning same error: scope parameter must set string constant equal containing group.

the scope here needs name of series group set in chart, not column group of tablix set below, like:

enter image description here

i created simple test based on:

enter image description here

with chart data expression set to:

=runningvalue(fields!paymentamount.value, sum, nothing)

i got following:

enter image description here

which incorrect, similar you're seeing.

if change expression to:

=runningvalue(fields!paymentamount.value, sum, "chart1_seriesgroup1")

i following:

enter image description here

which correct, seems you're going have set scope correct series group name.


Comments

Post a Comment