Report Running Total
Hi I have a report with The following: Fiscal_Year, Period, Amount_Base and Group. I have a line graph that has a series with 4 values (4 lines). I need to have a running total for each group. THe graph is limited to one fiscal year with a parameter. The Amount_Base and Period are the axis values. I have tried sever different entries in the RunningValue and nothing seems to work. I keep getting an error stating the Y expression for the chart 'YTDConsolRev2' has a scope parameter that is not valid. I tried this with the chart name and it returns data, but the values do not look right. =RunningValue(Fields!AMOUNT_BASE.Value,sum,"YTDConsolRev2") This results in a running total on the 4 groups togther. I need each goup to have it's own running total, by each series group. How do I specify the variable? Any helpo would be appreciated. Thanks, Trish Trish Leppa
April 18th, 2011 4:12pm

Never mind I figured out my problem. I needed to use the series group name. =RunningValue(Fields!AMOUNT_BASE.Value, sum,"YTDConsolRev2_SeriesGroup") Thanks, Trish Trish Leppa
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 12:14pm

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

Other recent topics Other recent topics