Crystal Reports XI – Showing records when setting criteria
Goal: To show all customer orders. Along with those orders, I want to show all related notes on the progress for filling those orders. Problem: Some orders have no notes. When I set the criteria to show all orders and to show the notes, only orders with notes now appear in the report.
Question: Is there a work-around for this goal?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 5, 2009 11:42 PM
UPDATED:
March 6, 2009 2:41 PM
Answer Wiki:
I am assuming that the notes are held in a different table to the orders, and that you have an inner join connecting the orders table to the notes table. You need to have an outer join to the notes table.
e.g.
select o.id, n.notes
from orders o left outer join notes n on o.id = n.orders_id
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
