Crystal report with Application variables

[Karine Proot]

Hello,

I would like to use crystal report .NET component. My first problem comes
when I try to specify the data source.

The server, database, userID and password are application variables. How
do I tell the report ?

Karine

[Karine Proot]

[Sorry, I don't remember which adress was set up for msdn support...]

Hello,

I would like to use crystal report .NET component. My first problem comes
when I try to specify the data source.

The server, database, userID and password are application variables. How
do I tell the report ?

Karine

[Gorm]

Are you looking for something like this? Change the strings with the info
from the Application hash.
TableLogOnInfo logonInfo = report.Database.Tables[0].LogOnInfo;
logonInfo.ConnectionInfo.ServerName = "<server>";

logonInfo.ConnectionInfo.UserID = "<user>";

logonInfo.ConnectionInfo.Password = "<password>";

logonInfo.ConnectionInfo.DatabaseName = "<databasename>";

report.Database.Tables[0].ApplyLogOnInfo(logonInfo
"Karine Proot" <ms**@g-fit.fr> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hello,

I would like to use crystal report .NET component. My first problem comes when I try to specify the data source.

The server, database, userID and password are application variables. How do I tell the report ?

Karine

[Karine Proot]

Great, this is exactly what I needed, and a good start to search further
info. Thanks.

Are you looking for something like this? Change the strings with the info
from the Application hash.
TableLogOnInfo logonInfo = report.Database.Tables[0].LogOnInfo;
logonInfo.ConnectionInfo.ServerName = "<server>";

logonInfo.ConnectionInfo.UserID = "<user>";

logonInfo.ConnectionInfo.Password = "<password>";

logonInfo.ConnectionInfo.DatabaseName = "<databasename>";

report.Database.Tables[0].ApplyLogOnInfo(logonInfo