Distributing Report based on a SQL Query 1

[Paul256]

I have written a Crystal Report based on a SQL Query which is then run via a VB screen. When the VB package is distibuted to another PC the Report will not run. I have included the runtime files P2IXBSE.DLL and P2LODBC.DLL as part of the distributed package. If I change the Report to be based on a Database the distributed application works OK.

Am I missing something which is specific to reports and qry files?

 

[dcm]

Paul256: A simple question I know but are you also distributing the qry file as well.I assume that you have Saved Data turned off in both rpt and qry files and if so then as long as the data source for the query is identical on both machines this should work David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner