I host my web asp web site two different server.Same configuration this two server.server No 1 crystal report data view Properly.Server No2 only view report viwer and Static field now display data column. Seerver No 1 connection string, SqlConnection conStr = new SqlConnection("Data Source=TESTSERVER\\SQL_08R2;Initial Catalog=ERP_DB;User ID=sa;Password=h@123;pooling=false"); SqlCommand cmd = new SqlCommand(" Select * from tblPrintCOdAdvice", conStr); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds, "TblCOD"); ReportDocument BooksReport = new ReportDocument(); BooksReport.Load(Server.MapPath("DCREPORT.rpt")); BooksReport.SetDataSource(ds.Tables["TblCOD"]); CrystalReportViewer1.ReportSource = BooksReport; CrystalReportViewer1.DataBind(); Server No 2 connection string, SqlConnection conStr = new SqlConnection("Server=WIN-QBTC29S7939;User ID=sa;Password=h@123;Database=ERP_DB;"); SqlCommand cmd = new SqlCommand("Select * from tblPrintCOdAdvice", conStr); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds, "TblCOD"); ReportDocument BooksReport = new ReportDocument(); BooksReport.Load(Server.MapPath("DCREPORT.rpt")); BooksReport.SetDataSource(ds.Tables["TblCOD"]); CrystalReportViewer1.ReportSource = BooksReport; CrystalReportViewer1.DataBind(); How Solve this Problem. Thank You.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)