sql server reporting services: Aggregate Function on TextBoxes - a big "NO-NO"... -- sql server reporting services

Aggregate Function on TextBoxes - a big "NO-NO"...

Kevin B
8/16/2004 3:09:39 PM

sql server reporting services:

Ok...so we can't do an aggregate function on numerical values stored in
textboxes...but is there some other way to access the value(s) in the
textbox and use them in a calculation?

=Sum(ReportItems!textbox1.Value) is an invalid expression - but is there
another workaround?

-KB

Re: Aggregate Function on TextBoxes - a big "NO-NO"...

mnorman07 NO[at]SPAM yahoo.com
8/19/2004 8:16:13 AM

[quoted text, click to view]

KB

I've been using Aggregate fuctions quite a bit in the last several
months. Just be sure to specify a scope in your function (i.e. a
dataset or group, etc.)

=Sum(ReportItems!textbox1.Value, "Group1")

Hope this helps,