Skip to Content

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

Rows with all values as zero should be suppressed

Hi all,

We have a requirement in crystal reports to display all the zeros as blank (suppress zeros) and if a row contain all values as zero we have to suppress the entire row.

Please help me in achieving it. Please find the screen shot attached for your reference.

Note: In the screenshot attached, the GL “100002- Petty Cash clearing account” (highlighted in yellow) has all values as zero and hence the row is blank. So the entire row should be suppressed/hidden in the report.

Tags:
Former Member
replied

Hi Abdul,

I can't see what section that row is in, however if it's the details section then you can go to the Section Expert > Select the Details Section > Click on the formula button beside Suppress and use this code:

if {Curr_Year} = 0 and {Prev_yr} = 0 and {field3} = 0 and {field4} = 0 then

     True

If this is a group, you can use the same formula with a Not condition in the Group Selection formula or the section expert for the group.

-Abhilash

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question