Hi
I'm a Jet Reports newbie and I need some assistance. I am using Jet Reports 2012 with Navision and the report I am writing is a simple Sales Invoice Report that can be filtered by Vendor Name. In order to achieve this I need to fetch the Item No from the Sales Invoice, retrieve the Vendor No from the Item Card and then filter on the Vendor Name. In short, I need to do something like this:
Sales Invoice Line.No. (Item no)–> Item.No. –> Item.Vendor No. –> Vendor.Name
How can I include the above links in the filter on the Sales Invoice Line data set that I am retrieving in Jet Reports so that the report retrieves only those Sales Invoices that pertain to items from the selected Vendor?
Any assistance will be greatly appreciated.
Best regards
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
You could use the Table Builder tool to create this report. You can add the Sales Invoice Line table, then the Item table, then the Vendor table. I don't think it will automatically detect the link between the Sales Invoice Line and the Item table so after you add the item table, you'll probably have to manually add the linking fields (No. = No. I think in that case). It should automatically detect the linking fields between the Item and Vendor tables. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi
Thanks for your reply. Actually this bit is part of a bigger report where I cannot use table builder. I did manage to create this with the builder. It's very straight forward. But I'm using the functions to build this report so I need the "harder" solution. Any other thoughts?
Please sign in to leave a comment.