Karen,
If you are using Macola SQL, you can create views in Enterprise Manager that use a UNION query to combine fields from OEORDHDR_SQL and OEHDRHST_SQL and another one for OEORDLIN_SQL and OELINHST_SQL which would give you one place to see things that are both open and shipped. From Crystal, you would use the two views for the header and line information and then link into it the item, customer and any other relevant information you would want.
If you are using Btrieve, you can start a crystal report with the customer table ARCUSFIL_SQL and from that link to the OEORDHDR_SQL and OEHDRHST_SQL at the same time. If you check the Options of one of the links, you'll have a checkbox that says "Look up all of one, then all of others". You would then create a formula for each field that you want on the report. The formula for the item number would be like the following:
if isnull({OELINHST_SQL.Item_No}) then {OEORDLIN_SQL.Item_No} else
{OELINHST_SQL.Item_No}
The Btrieve bookings report will take some time to run because it reads all of your open order data and all of the order history data as well but both have worked for getting the information onto one report.
Kevin Scheeler