Question
I am pulling some info from the Purchase Header table, but i needed to filter on data located in a different table, so i used an NL filter, it is below.
=NL("Filter","Document Dimension","Document No.","Table ID","39","Document Type","Order","Dimension Code","05 PROGRAM","Dimension Value Code","455")
This works fine for me, but i would like to add another filter to this NL, example
Dimension Code 04 BUDGET CENTER
Dimension Value Code "070"
Can i add this filter to my original NL that i have above?? Right now i have ("Dimension Code","05 PROGRAM","Dimension Value Code","455"), can i also add ("Dimension Code","04 BUDGET CENTER","Dimension Value Code","070").
Thanx
Craig
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi!
Welcome to advanced filters!
What you are looking for is probably the "NP("Union")".
Check JetReports help: "NP Function Reference", you'll find it very interesting.
Regards,
Jan
Please sign in to leave a comment.