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
 Development Tools
 Reporting Services Development
 Suppress blank rows in table SQL Server 2005 RS

Author  Topic 

marina1966
Starting Member

10 Posts

Posted - 2008-04-16 : 15:29:54
Hello! I have a question how to suppress(this is used in Crystal reports)blank detail line (a row) in the table( in SQL server 2005 Reportinfg Services), if the specified field, for example =0.
Thank you!

MY

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-17 : 12:33:48
Change the visibility property of row to make hidden property true for field=0

i.e IIF(Fields!YourField.Value=0,True,False) for hidden property
Go to Top of Page
   

- Advertisement -