Crystal Report always blank but DataSet has data

Joicy Sunny

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vasanth Natarajan9y ago
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,
0
Sameer Shaik9y ago
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
0
Joicy Sunny9y ago
my source page contains :-

<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
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

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