Using an OR filter in a report

jorgito

Hi all.

I have a report that displays the Sales Orders. I have two Data Items

Sales Header
-> Sales Line

But I want to display only the Sales Lines that the Quantity is zero OR the Qty. to Ship is other than zero.

What do I need to enter in the DataItemTableView property??

If I use the SHOWOUTPUT function on the Sales Line - Body section, I have the problem that the Sales Headers that do not have any Lines will also be displayed.

How can I solve this?

Thanks in advance
Jorgito

sgg

if you want to filter on more than one field simultaneously with the OR option, then you will have to write codes such as the following in the
OnAfterGetRecord() Trigger of your Sales Lines DataItem :

if (("Sales Lines".Quantity<>0) and ("Sales Lines"."Qty. to Ship"=0)) then
CurrReport.SKIP;

This will show only Those with Zero Quantity or Non-Zero Qty. to Ship

However to skip Sales Headers with no Lines, set the PrintOnlyIfDetail property of the Sales Header DataItem to True