Thanks for your response Malcolm. This report will run against either a SQL or Visual FoxPro database using ODBC. Following is the SQL statement you asked for, however the bulk of the real processing is done in subreports, of which there are many. Testing shows the report executes nicely in the Crystal Designer, from within the VB environment, from the distribution files when installed on the machine it was developed on (Crystal and VB installed) and the same distribution files when installed on a system that does not have Crystal or VB runs extremely slowly. I am now trying to determine exactly which DLL's I need to make sure are included with the distribution package. I have a list of the ones the report is using from the About box in Crystal, however many of themn are system and or part of the Crystal Designer.
SELECT
jhead."jhhist", jhead."jhjob", jhead."jhrqdt", jhead."jhpart", jhead."jhrev", jhead."jhdesc", jhead."jhpqty", jhead."jhssdt", jhead."jhsddt", jhead."jhplan", jhead."jhschd", jhead."jhrelf", jhead."jhpcmp", jhead."jhcmpd", jhead."jhclsd", jhead."jhqtys", jhead."jhqtyi", jhead."jhqtyc", jhead."jhquot", jhead."jhqtln",
jjasm."jyjob", jjasm."jylevl", jjasm."jypart", jjasm."jyrev", jjasm."jyum", jjasm."jydesc", jjasm."jyextd", jjasm."jypqty", jjasm."jynote",
rcshp."rscust", rcshp."rsname",
qdqty."qsseq", qdqty."qsqty", qdqty."qsscrp",
rslsp."rrname"
FROM
{ oj ((("jhead" jhead INNER JOIN "JJASM" jjasm ON
jhead."jhjob" = jjasm."jyjob"

LEFT OUTER JOIN "qdqty" qdqty ON
jhead."jhquot" = qdqty."qsquot" AND
jhead."jhqtln" = qdqty."qsline"

LEFT OUTER JOIN "RCSHP" rcshp ON
jhead."jhcust" = rcshp."rscust"

LEFT OUTER JOIN "rslsp" rslsp ON
rcshp."rsslsp" = rslsp."rrslsp"}
ORDER BY
jhead."jhjob" ASC,
jjasm."jylevl" ASC Jim Varco
Varco Consulting
varco@compuserve.com