How can i filter the following in the picture? the one with closed by entry no 17966. is the invoice the other is the credit memo 17966. How can i filter that when they are in the different row. What will i do is to remove those field when the report run. Thank you!
*This post is locked for comments
that needs a customization. edit the report, add following to the dataitem-onaftergetrecord trigger:
entryNo = 17966; // declare variable entryNo of type integer
if ("document type" = "document type"::invoice) and ("closed by entry no." = entryNo) then
currreport.skip;
if ("document type" = "document type"::"credit memo") and ("entry no." = entryNo) then
currreport.skip;
i mean. The report will automatically filter because there are many entry number and closed by entry number have the same value so i want to filter those value and remove it from the row.
You can filter by type first , then you can filter 17966.
then what is the next will i do?
Click on the line ( Exactly on cell that contains 17966 )==> ALT+F3
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
