views:

584

answers:

2

In some of our SQL Server Reporting Services reports we wrote for SQL 2005, we used the Me.Value in the hidden expression to determine if the cell should be shown. This worked fine with SSRS 2005 (even though it probably shouldn't have).

However, it no longer works with SSRS 2008. Is there an alternative (other than using the actual field) that we can use?

Edit: I need something that works in both SSRS 2005 & 2008 as these reports will be distributed to multiple places.

+1  A: 

Have you tried using the Control?

Something like:

ReportItems!TextBox1.Value

ReportItems on MSDN

toast
Cool, although I can't just copy and paste the expression to all my controls that need it, it still allows me to change the expression for the value of the textbox without changing the visible expression.
Ray
It's ReportItems!TextBox1.Value
Ray
A: 

Are you getting an error using Me.Value? I'm currently using that in 2008, and it's working.

Yeah I am. Strange one.
Ray
What does your expression look like?