I have a pre query in which the display properties of the query are set to suppress 0 rows and columns is active. The pre query results are correct at this point. But, the 0 row records that were suppressed in the pre query are shown in the main query.
How can I stop the 0 rows that are suppressed in the pre query from being passed to the main query and shown in the report output?
Thank you for your help in advance.