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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics