Hide an entire row if data in one firld is 0 or null

I want to be able to remove rows from the report if certain data in the row is 0. If a sales division has no sales for a district. there is no reason to show the district name or even to show an empty space for the row. I want to suppress the entire row without the user being able to see it or unhide it.

Is this possible?

You can accomplish this using filters. You can filter at the dataset, data region and grouping levels. You could also modify the SQL query to filter the data using the WHERE clause.

Here is more information on filter data in a Report.

http://msdn2.microsoft.com/en-us/library/ms157307.aspx

Ian|||This will not work in the current context. There are multiple fields that get grouped at a division/region level