MS guys...can i do this is RS... Pls respond -- sql server reporting services

Sunny
8/13/2004 8:45:01 PM

I got a suggestion to use Previous method to get the value from previous row.
What i am doing is as below

the expression i have written is
Current = Previous(ReportItems!Current.value) - Fields!P.Value +
Fields!C.Value

-------------------------------------------------------------------------------
Name Prev C P A Curren
-------------------------------------------------------------------------------
ABC 50 10 60 (Prev + C )
20 40 (Prev row Current - P)
15 55 (Prev row Current + P
--------------------------------------------------------------------------------
25 20 0
--------------------------------------------------------------------------------
But i am getting error as
"The value expression for the textbox 'Current' uses an aggregate function
on a report item. Aggregate functions can be used only on report items
contained in page headers and footers."

This is possible in crystal..what is the problem here
Can i get the same I want by some... other way !!!!!!!!!!!!!!!!!!

Please help...i am going nuts on this!!!!!!

Brian Welcker [MSFT]
8/15/2004 1:18:09 AM

Have you tried using Previous with a field reference instead of a ReportItem
reference? You can also define a custom field and then use Previous on that
one.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

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

[quoted text, click to view]

sql server reporting services : MS guys...can i do this is RS... Pls respond