Again Crystal Report
-
again I am sending the same problem but this time I searched in google for the code,and use the code that I got from this forum what I have found i am sending, --------------------------------------- CrystalReport1 report=new CrystalReport1(); report.ReportOptions.EnableSaveDataWithReport = false; CrystalDecisions.Shared.TableLogOnInfo myLogin; CrystalDecisions.Shared.ConnectionInfo oCRConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables) { myLogin = myTable.LogOnInfo ; //myLogin.ConnectionInfo.ServerName="(local)"; myLogin.ConnectionInfo.ServerName="."; myLogin.ConnectionInfo.UserID = "sa" ; myLogin.ConnectionInfo.Password = "123456" ; myLogin.ConnectionInfo.DatabaseName="temp"; myTable.ApplyLogOnInfo(myLogin) ; myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1); } OleDbConnection oleConn = new OleDbConnection("Provider=sqloledb; data source = .; initial catalog = inventory; user id = sa; password = 123456"); oleConn.Open(); OleDbDataAdapter da = new OleDbDataAdapter("select * from student",oleConn); DataSet ds=new DataSet(); da.Fill(ds); CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument; myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); myReportDocument.Load(@"C:\Inetpub\wwwroot\temp\CrystalReport1.rpt",CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy); myReportDocument.SetDataSource(ds); this.CrystalReportViewer1.ReportSource =myReportDocument; CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.DisplayToolbar = true; CrystalReportViewer1.DisplayGroupTree = false; oleConn.Close(); I did not got any error but my crystal Report Viewer contains no data i.e. it contains only Crystal Report Toolbar ,no data(Blank Report) If I use F11 to run step by step ,I found the execution did not enter in the following Code. foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables) { myLogin = myTable.LogOnInfo ; //myLogin.ConnectionInfo.ServerName="(local)"; myLogin.ConnectionInfo.ServerName="."; myLogin.ConnectionInfo.UserID = "sa" ; myLogin.ConnectionInfo.Password = "123456" ; myLogin.ConnectionInfo.DatabaseName="temp"; myTable.ApplyLogOnInfo(myLogin) ; myTable.Location.Substring(myTable.Locatio