I have a simple report that involves two tables. It is the clasic products/orders senario.
I want to produce a chart that shows all the products and how many orders they have.
I have included both tables in my report but can not get a join to work where the products with zero orders come up.
Both tables have the columnn prodId (product id). The product table has product name which i want to have as the x-axis.