Hello,
I need to build a report to list production order component lines where at least one line doesn't have a location code. This is how I'm selecting the records:
=NL("Rows","Prod. Order Line",,"Status","<>Finished","Remaining Quantity",">0")
Then I have a column that counts the rows with no location code:
=NL("Count","Prod. Order Component",,"Prod. Order No.",$E4,"Item Code",$G4,"Location Code","=@@")
Then I can create hide logic to hide the rows where the Count is = 0.
But instead of doing that, can I combine the NL Rows and NL Count formulas into one so I don't have to use the Hide logic?
Thanks for any help!
Date
Votes
1 comment
-
Jet Reports Historic Posts Yes, you can!
Here is a discussion very much related to your question –> http://community.jetreports.com/viewtopic.php?f=7&t=4862&p=13495&hilit=sort+by+sum&sid=0503851898c9d8121013d981d9255a8b#p13495
I hope that helps.
Please sign in to leave a comment.