ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Using the SQL Server 2000 Reporting Services
Subject:   Dynamically Remove Rows In Report
Date:   2006-01-18 09:49:22
From:   Drutch
Response to: Dynamically Remove Rows In Report

Include in your query "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.