All geek questions in one place

SSRS expression reference This is a text box

I have a fairly wide Tablix, and I would like to add similar expressions for each of the text fields in the line. For instance:

TextAlign: =iif(ReportItems!TextBox1.Value<>0, "Right", "Center")

But I do not want to edit the formula in each text field. I want to say:

 TextAlign: =iif(Me.Value<>0, "Right", "Center") OR =iif(This.Value<>0, "Right", "Center")

SSRS is currently used for SQL 2008R2 and VS2008. Is there a way to do this, or am I stuck? Will I get it if I upgrade to SQL 2012 and VS2010?

+4
source share
2 answers

MSDN says Me.Value should work. See http://msdn.microsoft.com/en-us/library/dd255285.aspx

Example below

 =IIF(Me.Value > 0,"Black","Red")

Having said that, I just tried it for SSRS 2008 R2 inside BIDS and it does not work.

"The reference to the object is not installed in the instance of the object."

Documentation-related information dates back to 2012, but changing the documentation version to 2008 or 2008 R2 still has the same display on the page.

+6
source

Me.Value , which worked fine in the 2005 SSRS version, got an error that appeared in the 2008 version.

Robert Bruckner (who wrote the book on SSRS) claims to have been fixed in version 2008 R2, but may not be the way it does not work for you.

I tested it in SSRS 2012 and it does not work for me.

See this talk for more details. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/98f0e6a0-108c-44bb-8730-5e90cf1fa5a4/mevalue-bug-in-ssrs-2008

Robert Bruckner suggests you contact Microsoft directly if you want to fix it.

+1
source

Source: https://habr.com/ru/post/1445103/

More articles:


All Articles