Skipping Record Problem

CHAMBERS

Hello,

I have a proprietry table named sales analysis, my report hierarchy is as follows, Item Category Then the Indented Item Table.

Item Category: Following Setrange done.

SalesAnalysis.SETRANGE(SalesAnalysis."Item Category Code","Item Category".Code);

Item Table: Following Setrange done.

SalesAnalysis.SETRANGE(Type,SalesAnalysis.Type::Item);
SalesAnalysis.SETRANGE(SalesAnalysis."No.",Item."No.");

The problem I have is that I want to omit any sales analysis entries where a qty 0 exists. I have attempted to place the SKIP feature in the OnAfterGetRecord of Item but this fails to omit them.

Any ideas on how I can do this?

Cheers

DenSter

You can't do that, because your dataitem is on the Item table, not on your analysis table.

Add another filter:
SalesAnalysis.SETFILTER(SalesAnalysis.Quantity,'>%1',0);

I don't know if this is the right way with the data type, but setting a filter on quantity is greater than 0, you should eliminate them.