>xx = SQLSTRINGCONNECT("dsn=CSNDB02; uid=ORATEST1; pwd=mypassword")
>oCRW85 = CREATEOBJECT("CrystalRuntime.Application.8.5")
>oCRW85.LogOnServer("p2sodbc.dll","CSNDB02")
>
>Then oCRW85.OpenReport & look at it.
>The LogOnServer above gets me an error from CR ActiveX:
>"Server has not yet been opened..."
>Thanks.Todd,
I've been using 9 for a little while now, but doesn't the LogOnServer method require the database, userid and password passed to it as well?
The other thing is that if you wish to preview the report to screen, you will also need to use the CRViewer control on a form and pass the report object to the viewer control's ReportSource property. The OpenReport method only returns an instance of the report object, it doesn't show it.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer