Good day to you all,
I am having some problems with programming a JetReport regarding vendor information.
I would like to get specific vendor details of a specific vendor and presented per company.
Please find attached the Jetreport I have build with the Report Wizard.
I only succeed getting information of one company.
I hope you can help me. Thank you in advance.
Thanks & Kind regards,
Auke (Netherlands)
5 comments
-
Jet Reports Historic Posts Official comment Hi Hughes,
Yes, that is what I was trying to create
Thank you very much !
Kind regards,
Auke -
Jet Reports Historic Posts Quick question - I see two vendor codes in your filters: VND03110 and VND01315, you have verified that both have the information you are trying to return?
I only ask because when I run this report (after changing the vendor codes in the filter to "*"), I'm getting multiple vendors out of my database. -
Jet Reports Historic Posts Hi Heather,
Yes, both vendors have data (invoices) in our bookkeeping (Navision).
The problem is that we whave multiple companies. That is why I need the vendor information of the two vendors presented per company.
Now I am getting the information only from the company which is selected as company.
Thanks & kind regards,
Auke -
Jet Reports Historic Posts Sorry - I misunderstood the question, my team often refers to our vendors as companies, as we do not have multiple company databases to deal with. So I was trying to find the problem there.
And, since I do not have multiple companies to deal with in my system, I'm probably not the best person to help with this issue. I'll do some searching, but I make no promises. :)
Once again, sorry for the confusion. -
Jet Reports Historic Posts Hi Auke,
I modified your report so that it replicates each company on a separate sheet and uses your options sheet to allow you to specify one or more companies. Is this what you were trying to do?
Regards,
Hughes