x

Data bars with recursive hierarchy

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?
more ▼

asked Mar 13, 2012 at 06:02 PM in Default

xnl28 gravatar image

xnl28
895 56 60 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

What if you leave out the recursive? Like so:

=Sum(Fields!Sales.Value, "Details")

For some more data bar fun, check out this article on [implementing data bars in a grouped table][1].

[1]: http://blog.hoegaerden.be/2010/05/27/implementing-data-bars-in-a-grouped-table/
more ▼

answered Mar 21, 2012 at 08:33 AM

Valentino Vranken gravatar image

Valentino Vranken
1.5k 1 2 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x84

asked: Mar 13, 2012 at 06:02 PM

Seen: 1250 times

Last Updated: Mar 21, 2012 at 08:33 AM