Suppressed 0 Records from Pre Query Shown in Main Query

[Former Member]

Hello,

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.

[Former Member · Accepted solution]

Does anyone have an idea about this or is my question not clear?

Thanks.

[former_member188975 · Accepted solution]

Hi Chris,

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...

[Former Member]

I applied a condition that included each KF <> 0 and that worked great. Thanks for the help.