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
 Hiding specific rows

Author  Topic 

Tart_SQL
Starting Member

41 Posts

Posted - 2008-04-10 : 17:13:47
How do I prevent certain rows from displaying in a table. I tried the hiderows property but it will only work if their is no data in the table.

In this scenario I want to hide rows that have certain fields as nulls, while display the ones that are not nulls in the table.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-10 : 17:17:56
It sounds this decision can be made with a simple WHERE statement in the underlying query.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-11 : 13:07:11
You can do this by adding a filter to the table. Just right click table take properties and move to filter tab to set the filter.
Go to Top of Page
   

- Advertisement -