Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 hide column

Author  Topic 

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2013-01-25 : 14:03:46
I have a field set in the dataset in the report, but it is uses a stored proc. The fields are dynamic, so if the field is not selected in the query, how can I check the report to see if it is nothing?

Dave
Helixpoint Web Development
http://www.helixpoint.com

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-25 : 14:12:24
Use an expression such as this for column visibility (right click on the column header and select column visibility) :
=IIF(Fields!YourColumnNameHere.IsMissing,true,false)
Go to Top of Page
   

- Advertisement -