Wednesday, March 7, 2012

Error with MSDE with Crystal Report - From VB

Hi groups,
(1) How can i pass MSDE connection Parameter -> Crystal Report from VB...?
Let say, While designing cr.report - the server name & DB name is embedded
in report. But now we removed the server & DB name from the Table Name.
After doing this the report does'nt show anything eventhough we pass the
connection strings from VB.
Is there any solution to achieve my connection with DB from VB.
Mahehskumar.R
"? Mahesh Kumar" wrote:

> Hi groups,
> (1) How can i pass MSDE connection Parameter -> Crystal Report from VB...?
> Let say, While designing cr.report - the server name & DB name is embedded
> in report. But now we removed the server & DB name from the Table Name.
> After doing this the report does'nt show anything eventhough we pass the
> connection strings from VB.
> Is there any solution to achieve my connection with DB from VB.
>
> Mahehskumar.R
>
Try this:
Dim Report As CRAXDRT.Report
Dim crxDBT As CRAXDRT.DatabaseTable
For Each crxDBT In Report.Database.Tables
crxDBT.SetLogOnInfo ServerName, DatabaseName, UserName, Password
Next
Bye
Nedi Freguglia

No comments:

Post a Comment