Link to home
Start Free TrialLog in
Avatar of soozh
soozhFlag for Sweden

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


SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of soozh

ASKER

i think i see what my problem is...

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.


SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of James0628
James0628

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