Search:

If in CR I used only one table and preview then report its work same in vb also work.If I used multi table and view in CR its work fine but in vb its shows error '20599 cannot open sql server' my...

Hi,
thanks for your good co-operations

My question if their is problem inlink then report should not work for single user table in CR8.5.
I think so sowhere multi table used setting probelm...

If I try without query in code still same message ''20599' Cannot open sql server'. IF above same vb code use for single table crystal report its work fine.

Hi,

thanks for helping , I am linking table thru visuallinkingexpert thru only. When I making report using CR 8.5 and previewing in cr 8.5 its work, but same report when calling thru above...

Hi,

Please see the attached zip file contained .rpt. If I open this file in CR 8.5 and preview its work fine. but in vb its giving error '20599' Cannot open SQL server. If I try for single table...

If Option1.Value = True Then
Rep_form.CR1.Reset
Rep_form.CR1.LogonInfo(0) = rep_con
Rep_form.CR1.WindowShowPrintSetupBtn = True
Rep_form.CR1.WindowShowExportBtn = True
...

Hi,

Thanks for reply, I am using OLEDB and DSN also created. My problemis for single table used in CR 8.5 report work fine in CR 8.5 preview as well as in VB codeing. But if I used multiple...

Please help me regarding vb6, crystal report 8.5 and mssql 2008 r2 compartibility. My old setup was vb6 , CR 8.5 and ms-sql 2000 was working fine, after migration from mssql 2000 to ms-sql 2008 r2...