DataItemTableView Filter in Report Dataset

(0) Share

Report

Posted on by Lars Hædersdal

750

I have a copy of the Sales - Invoice Report that I want to modify.
On the "Sales Invoice Line" I want to use a filter so that only certain lines are removed from the dataset.

As default it is "SORTING(Document No.,Line No.)"

In pseudocode I want a where claus that says

Where ("No."<>"" and "Quantity">0) or ("No."="" and "Quantity"=0)

Is that possible?

*This post is locked for comments

All responses (4)

Answers (2)

keoma 32,675 on at

Like (1)

Report

RE: DataItemTableView Filter in Report Dataset

i'm sure lars would have checked that for himself. ;-)
Lars Hædersdal 750 on at

Like (0)

Report

RE: DataItemTableView Filter in Report Dataset

Great I just modified the solution to

if (("No."<>'') AND ("Sales Invoice Line".Quantity > 0)) or (("No."='') and ("Sales Invoice Line".Quantity = 0)) then begin

//Process code

END

ELSE

CurrReport.SKIP;
Verified answer

Saurabh Shah 4,560 on at

Like (0)

Report

RE: DataItemTableView Filter in Report Dataset

Just slight difference, I guess

if (("No."<>'' ) and (Quantity > 0)) or ( ("No."='' )and (Quantity = 0) )then

CurrReport.Break;
Verified answer

keoma 32,675 on at

Like (0)

Report

RE: DataItemTableView Filter in Report Dataset

add following at the beginning of trigger "Sales Invoice Line - OnAfterGetRecord()":

if ("No."<>'' and Quantity > 0) or ("No."='' and Quantity = 0) then

CurrReport.Break;