Crystal Report & Application variable

[Karine Proot]

[sorry if this is the second one you receive]

Hi all,

My web application has Application variables for
connection strings, as they can change often.

Global.asax.cs :

protected void Application_Start(Object sender, EventArgs
e)
{
Application["Server"]=...;
Application["DataBase"]=...;
Application["UserID"]=...;
Application["Password"]=...;
}

I'm discovering Crystal Reports, and try to use these
variables. First docs I read talk about defining a dataset
(xsd format), but this doesn't allow me to use my
Application variables. I read an example who seems to
match my needs, here is the code :

ReportDocument rd = new ReportDocument();
rd.Load (@"myReport.rpt");
int i;
for (i=0; i<=rd.Database.Tables.Count-1; i++)
{
TableLogOnInfo tloi = new TableLogOnInfo ();
tloi.ConnectionInfo.ServerName = Application
["Server"].ToString ();
tloi.ConnectionInfo.DatabaseName = Application
["DataBase"].ToString ();
tloi.ConnectionInfo.UserID = Application
["UserID"].ToString ();
tloi.ConnectionInfo.Password = Application
["Password"].ToString ();
rd.Database.Tables[i].ApplyLogOnInfo (tloi);
}
rd.ExportToDisk (ExportFormatType.PortableDocFormat,
@"myReport.pdf");

This works perfectly fine with an empty report, but
what can I do to get the database's fields on the report,
as I don't have any .xsd file ?

Thanks
Karine