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"Kevin B" <No-SPAM@.misnet.info> wrote in message news:<uoXYuR8gEHA.4092@.TK2MSFTNGP10.phx.gbl>...
> 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
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,
MN
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment