Article:  |
Using the SQL Server 2000 Reporting Services | |
| Subject: | Dynamically Remove Rows In Report | |
| Date: | 2005-09-23 10:50:56 | |
| From: | TJWARD | |
| How can remove a row from my report if the results is empty or a null? | ||
Showing messages 1 through 1 of 1.
-
Dynamically Remove Rows In Report
2006-01-18 09:49:22 Drutch [View]
"SELECT * FROM [TableName]WHERE [ColumnName] IS NOT NULL AND [ColumnName] <> ' '". I'm not sure if Reporting Services has a Filter option to get the same results, but if you filter your query the dataset used in the report will not contain those values.