I have a table in my R2 report that has a parent-child recursive hierarchy. In the Details row group, I have a data bar with the series expression
However, I want the length of the bar on the parent record to be the sum of all descendents. When I change the data bar series expression to
=Sum(Fields!Sales.Value, "Details", recursive)
I get the following error:
"The maximum expression for the chart DataBar1 has an inner aggregate that specifies the recursive flag. Nested aggregatres cannot specify the recursive flag."
Can anyone advise how to get around this?
asked Mar 13 '12 at 06:02 PM in Default