Suppressed 0 Records from Pre Query Shown in Main Query
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.
Bhanu Gupta replied
Do you mean that those char values (that were suppressed in the pre-query output due to the KF values being 0) are being displayed in your result set query? If yes, then you may want to try conditions on the KF to bring in only values greater than or <> 0 in the pre-query.
Hope this helps...