Visibility
I have a report within SSRS 2005 and if the table doesn't contain and data (rows), then i want a message (text box) to appear notifying that there is not data available at this time.
i've written the text within the text box and on the properties of the textbox ive select Visibilty - Expression.
I want so that if the column op1 is empty then i want the text box to appear otherwise it would be invisible
=iif(ISNOTHING(First(Fields!op1.Value,
"DataSet1")),
TRUE,
FALSE)
July 1st, 2011 6:26am
Did you try the NoRows Property of the Table? Check this:
http://technet.microsoft.com/en-us/library/microsoft.reportingservices.reportrendering.table.norows(SQL.90).aspx
Property Value
A Boolean indicating whether to display the
NoRowMessage when there is an empty dataset. The value is
true if the item is not associated with any rows, and the message in
NoRowMessage is displayed.
To customize this, see:
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/c6b07d19-6d18-4f29-81de-46ab9c503c02/
Hope this helps..Chaitanya( Twitter |
Blogs )
Any documentation bug? Tell us about it at
Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 6:38am


