Crystal Report always blank but DataSet has data

Question

I am trying to create a crystal report using visual studio 2015,but its not showing the output in browser. The dataset has values.

Vasanth Natarajan · Answer

First Directly Open your CrystalReport1.rpt file and Run(F5). and Parameter window will be open set the parameter and Enter the Report. If You Get result Based on Your Parameter, DataSet not a problem you are Designing the Currect way else you not Getting the result Your DataSet not Mapping to Currect rpt Please check the Dataset mapping Thanks vasanth,

Sameer Shaik · Answer

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-without-database.htm

Joicy Sunny · Answer

my source page contains :- Namespace="CrystalDecisions.Web" TagPrefix="CR" %> Code Behind : protected void Page_Load(object sender, EventArgs e) { ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("CrystalReport1.rpt")); DataSet1 dsPurchase = GetData("select * from tbl_PurchaseChild"); crystalReport.SetDataSource(dsPurchase); CrystalReportViewer1.ReportSource = crystalReport; CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.Visible = true; } private DataSet1 GetData(string query) { string conString = ConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString; SqlCommand cmd = new SqlCommand(query); using (SqlConnection con = new SqlConnection(conString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataSet1 dsPurchase = new DataSet1()) { sda.Fill(dsPurchase, "DataTable1"); return dsPurchase; } } } } dsPurchase contains records. But crystal report viewer not show data

Sameer Shaik · Answer

whats your DataSet structure.?? please make your question clear so that others can understand and answer well

Crystal Report always blank but DataSet has data

Answers (4)