Crystal 9.0 Report Specific Data Criteria Suppression

[JDP1860]

I'm trying to Identify the correct code/syntax for suppressing multiple rows of data on specific Crystal Report.

The Report shows "Stock Count Variance" within a Production Environment and the Data currently shows all records for the specific table. I know how to suppress the data if the Qty is the same from the Original Count.

Eg. If Stock Check Qty Count = Stock Take Qty Check then True
Else False

The problem is that if I have a Qty of "0.0" in the "Qty Count", or have not posted the new Qty into the "Take Count" it will suppress the Record. Or, if the "Take Qty Count" is "0.0", but the Quarantine or Reject Locations have Qty's then they will also be suppressed.


Eg. Some of the Table Rows;

Stock Check Qty Count
Stock Check Reject Qty Count
Stock Check Quarantine Qty Count
Stock Check Take Qty Count
Stock Check Take Reject Qty Count
Stock Check Take Quarantine Qty Count

I don't want the records that have been completed and match what the The "X Qty Count" nor do I want any record where the Take Qty for all Rows was "0.0"

Sorry if your confused.....It's pretty difficult to explain

 

[synapsevampire]

Your examples of data rows, aren't examples of data rows, they appear to be aggregates at some level within the data. A row is a set of one or more columns(fields) of data (techically it can be more thaan a set, but...).

It's easier to explain by using environmental information, technical terms, example data and expected output, especialyl when you're unfamiliar with the tools and concepts:

Database/connectivity used
Example data
Expected output

Stating "been completed and match what the The "X Qty Count" without showing what is "completed" isn't going to help either.

Show examples of the columns, then what you need as output.

You can use the Report->Select Formulas-Group to filter based on some form of group aggregate, but it's impossible to know if that's what you want.

-k