soozh
asked on
Simple crystal reports question
Hello,
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.
Any suggestions
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.
Any suggestions
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc has a good point about the chart. That probably would eliminate the subreport option (or at least make it much more complicated). I wasn't thinking about creating a chart.
James
James
ASKER
I have an extra condition on the orders table... i am only interested in orders in the last month. The query only returns the rows that have a order in the last month.
As the product rows that do not have an order are not returned I dont get a complete picture of all the products.