protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
ListOfCustomers crystalReport = new ListOfCustomers();
string dbUser = "";
string dbPassword = "";
string server = "";
string database = "";
foreach (CrystalDecisions.Shared.IConnectionInfo dsc in crystalReport.DataSourceConnections)
{
dsc.SetLogon(dbUser, dbPassword);
dsc.SetConnection(server, database, false);
}
crystalReport.SetDatabaseLogon(dbUser, dbPassword);
foreach (CrystalDecisions.CrystalReports.Engine.Table table in crystalReport.Database.Tables)
{
table.LogOnInfo.ConnectionInfo.UserID = dbUser;
table.LogOnInfo.ConnectionInfo.Password = dbPassword;
table.LogOnInfo.ConnectionInfo.ServerName = server;
table.LogOnInfo.ConnectionInfo.DatabaseName = database;
}
// Set to sub reports
CrystalReportViewer1.ReportSource = crystalReport;
CrystalReportViewer1.RefreshReport();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
ListOfCustomers rpt = new ListOfCustomers();
rpt.Site = this.Site;
return(rpt);
}
