Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppressed 0 Records from Pre Query Shown in Main Query

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
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question