Jump to content

Report Designer


Nick Brailsford
 Share

Recommended Posts

Hi, 

 

I am trying to get a list of all our suppliers out of Supplier Manager but i believe I need to make a join on the tables so i can see contact names.  I cant seem to make the join between the two tables i think i need (h_supplier_suppliers and h_supplier_contacts) 

 

Could you help please?

 

Thanks

 

Nick 

Link to comment
Share on other sites

@Nick Brailsford it should be possible - here is an example of the report on my demo instance - contacts grouped by supplier: 

image.png

I have added the report definition, so if you want to upload on your instance hopefully that should give you a base and you can configure it to suit your needs

supplier-contacts.report.txt

Hope that helps

Steve

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...