Hi,
I got a request to grab the data from my Item ledger entry and i am figuring out how to do the filtering.
I would like to get the data by filtering by my "Interface Transaction Number" and "Source No." where if my transaction number is "SIxxxxxx" or my Source No. is "CR0101".
Meaning to say i don't want the data which does not contain Transaction number "SIxxx" or the source number is not CRxxxx.
For example in my Item Ledger Entries Table:
Data A:
Transaction Number: AI01424, Source No: ALK2020
Data B:
Transaction Number: AI01424, Source No: CR0101
Data C:
Transaction Number: SI01234, Source No: AK2029
In my jetreport, i only want to grab the data B and C which meat my criteria…..
Any idea?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment D5 : =NL("Filter","Item Ledger Entry","Entry No.","Interface Transaction Number","SI*"
D6: =NL("Filter","Item Ledger Entry","Entry No.","Source No.","CR*"
E7: =NL("Rows","Item Ledger Entry",,"Entry No.",NP("Union",$D$5,$D$6)) -
Jet Reports Historic Posts thanks… it works!
Please sign in to leave a comment.