Monday, April 25, 2011

In Reporting Services 2008 is there a replacement for Me.Value?

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.

From stackoverflow
  • Have you tried using the Control?

    Something like:

    ReportItems!TextBox1.Value
    

    ReportItems on MSDN

    Ray : 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
  • Are you getting an error using Me.Value? I'm currently using that in 2008, and it's working.

    Ray : Yeah I am. Strange one.

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.