|
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 =Sum(Fields!Sales.Value) 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?
(comments are locked)
|
|
What if you leave out the recursive? Like so: For some more data bar fun, check out this article on implementing data bars in a grouped table.
(comments are locked)
|
Your answer
