Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Setting Parameter or Variable

Author  Topic 

cornall
Posting Yak Master

148 Posts

Posted - 2010-10-25 : 06:36:55
Hi,

I want to set the value of a peram or variable (not sure which I should use) to the value of a calculated field.

So my expression is

=Sum(Fields!MonthActual.Value)

is there a way in the expression to also store the value to use later?

cornall
Posting Yak Master

148 Posts

Posted - 2010-10-26 : 08:10:17
Worked out how to add custom functions and just pass my value into that seting the variable and doing my calculations.

Cheers
Go to Top of Page
   

- Advertisement -