Embedded credentials

[Malchik]

Is it possible to embed the credentials for the LogOn in the report itself? I am using an SQL Login and Password to connect the SQL server, but this report will reside on our Intranet, so I would like to embed the credential so the user can open the report without having to input the password

thanks for your help

Mal'chik

 

[MJRBIM]

If you are using Crystal Enterprise 10, Crystal Reports Server XI, or Business Objects Enterprise XI - then you can set-up a default DB-login on each RPT object in the CMC.

 

[Malchik]

I found actually this:

Dim cnnInfo As New ConnectionInfo


With cnnInfo
.ServerName = <put the SQL Server name>
.DatabaseName = <put the DB Name>
.UserID = <put the username>
.Password = <put the password>
End With


For Each cnInfo As TableLogOnInfo In crView.LogOnInfo
cnInfo.ConnectionInfo = cnnInfo
Next

Mal'chik