Groups | Blog | Home
all groups > sql server reporting services > august 2004 >

sql server reporting services : Previous() function not working with scope parameter.


Robert Bruckner [MSFT]
8/17/2004 1:45:48 PM
In this particular case, the documentation is ahead of its time. The MSDN
documentation describes the full implementation of the previous aggregate
function in a future release.
Currently, the previous aggregate only support the first argument.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Rick Todd
8/17/2004 4:31:47 PM
This works:
=Previous(Fields!Jobs.Value)

The following variants get this error:

"The value expression for the textbox 'textbox17' has an incorrect number of
parameters for the function 'Previous'."

=Previous(Fields!Jobs.Value,"scope")

=Previous(Fields!Jobs.Value,Nothing,"scope",Nothing)

The definition found here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/ht
m/rcr_creating_expressions_v1_61f7.asp?frame=true

Previous(Expression, AggFunction, PreviousScope, AggScope)

Ideas??

AddThis Social Bookmark Button