Exclude NULL & Zero data records from Crystal Report

[Former Member]

Purpose:

     In report show records with non-zero value at report level.

Scenario:

     I have a report which will retrieve records from database using SQL Command. Command have multiple records with Null or Zero value Order Quantity and i will exclude NULL & Zero data records from report. It can be achieved using following process. Just want to share real time experience using this blog.

Following is the report output  which will show the all the records form table.

We want to suppress null and zero value records. So, for that we go to Section Expert > Suppress (No Drill-Down) .

Use the following formula to supress

Save and Preview the report.

In this way we can achieve the requirement.

Hope it will helpful for beginners.

Regards,

mfahim