Runningvalue
-
Anyone know how to get a running total? I have instructions from a Microsoft SQL 2000 Reporting Services book that says the syntax is runningvalue(expression, function, scope).
I have inserted a cell into the detail row and the value looks like this:
=runningvalue(fields!wgt_plan.value,sum,"Machine")
It compiles fine but I get #ERROR in the field with a message in the output window that states "Operation is not valid due to the current state of the object. What does it mean and how do I fix it?
The detail is directly under a group called Machine.
-
Nevermind. I did not include the .value portion of the field to summarize. Once this was added, it worked fine.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply