Hi All. New to Jet Reports :)
The question I have is how to get data based on other table which results in multiple rows. For example I want to get sum of Amount on "Detailed cust ledger entry" table in NAV filtering on "Cust ledger Entry No." field on "Entry No." from "Cust Ledger Entry" table which returns forexample four lines. I am able to get filter Detailed Ledger entry table with first record of Cust Ledger Entry table but not the second, third and last. I hope my issue is understandable.
Thank you.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi!
I'm not sure if I understand you exactly, but I will try. I think you might want to do something like this:
=NL("Sum","Detailed Cust. Ledg. Entry","Amount",…,"Link=","Cust. Ledger Entry","Entry No.","=Cust. Ledger Entry No.",…)
I'm assuming you want to apply some filter to the Cust. Ledger Entry so you only get the sum of Detailed Cust. Ledg. Entry Amounts which correspond to some records on the Cust. Ledger Entry. So this formula sums the amount field from the Detailed Cust. Ledg. Entry table where there exists a record on the Cust. Ledger Entry table with the Entry No. equal to the Cust. Ledger Entry No. on the Detailed Cust. Ledg. Entry and some filters set. The first … represents whatever filters you want to apply to the Detailed Cust. Ledg. Entry table and the second … represents whatever filter criteria you want to apply to the Cust. Ledger Entry table. Does that do what you're looking for?
Regard,
Hughes -
Jet Reports Historic Posts Hi,
Thanks for the reply. Sorry for getting back to you after long time. The time passes quickly :).
I think what you have answers looks pretty much what I wanted. Although I have not yet tried but it looks promising :)
I will try soon and get back here if its not what I wanted and I will get back here even if it does work.
Thanks.
Please sign in to leave a comment.