RunningValue can't use a group clumn as scope if another row is using a row group scope?

dcmorrell
dcmorrell used Ask the Experts™
on
I came across this bizarre behaviour in SQL 2008 R2 express + Report builder 3.0

Step 1: make a trivial matrix with row grouping, column grouping

Step 2: Make a second row (insert row outside group)

step 3: on the first row do =RunningValue(field!<valuefield name goes here>,Sum, "<name of row group>"

So far so good

step 4: on the second row do =RunningValue(field!<valuefield name goes here>,Sum, "<name of column group>"

Now it refuses to run, why? O___O

Yes, I know,

"You cannot aggregate values across both a row group and a column group in a single expression. Writing an expression that includes an aggregate with a row group scope and another aggregate with a column group scope is not supported. "

But we're on a different cell, we're even outside the row group on the second row.

 

Thanks in advance for any words of wisdom

ReplyQuote
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try this on second row
=RunningValue(field!<valuefield name goes here>,Sum, Nothing"
and if that doesn't work then just use a regular sum
=Sum(field!<valuefield name goes here>)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial