How to Filter in Report?

p0wertube · 2018-10-08

Hey Guys,

i'm working on my first report, to provide informations about salescredit-memos for our sales-representatives.

Now I'm trying to add a filter to the report.
Our NAV supplier added an custom option field named "Return Operation" to the table 115 (sc-credit memolines), which
shows if the return is accepted or refused.

So I've added a CAL Global (boolean) and also an option field to the request page. (show only accepted)
Now I have to write some CAL Code so that the report will only print / display all lines (accepted and refused) or just the accepted.

I'm pretty sure that I've have to put it in the OnAfterGetRecord-Trigger, but I have no idea about the syntax.

pls help

Aluan · 2018-10-08

Hey p0wertube,

i think you get the error, because of the second line:
Try that:
IF NOT ("Sales Cr.Memo Line"."Return Operation" = "Sales Cr.Memo Line"."Return Operation"::Approved)

Question:
Do you just need to filter for the Return Operation Field?

p0wertube · 2018-10-08

I tried this, but I get the error message: "the prefix operator cannot be used on option"

IF showAccept THEN BEGIN
IF NOT "Sales Cr.Memo Line"."Return Operation"::Approved
CurrReport.SKIP;
END;
END ELSE
CurrReport.SKIP;

KTA8 · 2018-10-08

If I understand it well, that boolean field it's in the table; so your users can filter for them like if they were filtering the customer name or something like that. You shouldn't need to do anything in code.

Aluan · 2018-10-08

Hey p0wertube,

i think you get the error, because of the second line:
Try that:
IF NOT ("Sales Cr.Memo Line"."Return Operation" = "Sales Cr.Memo Line"."Return Operation"::Approved)

Question:
Do you just need to filter for the Return Operation Field?

p0wertube · 2018-10-10

Hey Aluan,

thanks that worked fine.
I have some more "hard" filters like (Type = Item) etc, but Return Operation is the only boolean filter on the request page

Howdy, Stranger!

Quick Links

Categories

How to Filter in Report?

Best Answer

Answers