Exclude NULL & Zero data records from Crystal Report
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
Hi mfamim,
This is an extremely inefficient way to handle this!
If you're reporting off of a SQL Query and want to get rid of rows where the Qty is NULL or zero, you should add a where clause to the query (assuming qtys are summed up in the source table)
This way you help CR in reading limited rows (as opposed to reading ALL rows) thereby improving the report's performance.
-Abhilash
Hi Abhilash, i'am only trying to provide simple workaround at crystal report level.