FILTERRING A REPORT

Hi guys,

I have a built a report based on the Purch. Inv. Line table and have grouped it by Posting Groups.

When I view it shows all posting groups including ones that don’t have Posting Group assigned to

them. I just want to show only the ‘PKGMAT’ and ‘RAWMAT’ Posting Groups.

All what I tried shows just one of them either ‘PKGMAT’ or ‘RAWMAT’ but I want both.

Cany abyone please give me some ideas?

Thanks.

have you try this in data item property filter ?

Posting Date = VALUE1|VALUE2

or if it didn’t work, try using C/AL codes inside OnAfterGetRecord inside DataItem Purch. inv… Lines.

example :

  1. using CurrReport.SKIP by condition :

IF Purch.Inv.Lines.Posting Date <> VALUE THEN

CurrReport.SKIP;

  1. Or using Mark functions

like : IF Purch.Inv.Lines.Posting Date = VALUE THEN

Purch.Inv.Lines.Mark(true)

else

Purch.Inv.Lines.Mark(false);

Purch.Inv.Lines.Markedonly(true);

and by the way the :

Posting Date = VALUE1|VALUE2

its not L or i between VALUE but it’s straight line character you could find it in keyboard left of ] character…