Crystal Reports wont load data

Question

Hello guyz ,

i tried to load Bill between two numbers using crystal Reports am getting these errors:

what could be the problem?

thanks

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

using CrystalDecisions.CrystalReports.Engine;

namespace NSPM_Sales_Invoice

{

public partial class BillsBetweenTwoNos : Form

{

SqlConnection con = new SqlConnection(Properties.Settings.Default.NSPM_Sales_InvoiceCon);

ReportDocument Cryrpt = new ReportDocument();

SqlDataAdapter dr;

public BillsBetweenTwoNos()

{

InitializeComponent();

}

private void btnFindJobs_Click(object sender, EventArgs e)

{

try

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer,Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo Between '"+textBox1.Text+"' and '"+textBox2.Text+"' ", con);

DataSet dst = new DataSet();

da.Fill(dst, "PrintBills");

Cryrpt.Load("BillsBetweenTwoNumbers.rpt");

Cryrpt.SetDataSource(dst.Tables[0]);

crystalReportViewer1.ReportSource = Cryrpt;

con.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

private void BillsBetweenTwoNos_Load(object sender, EventArgs e)

{

textBox1.Text = Class1.strinv;

try

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer,Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo Between '" + textBox1.Text+"' and '"+textBox2.Text+"' ", con);

DataSet dst = new DataSet();

da.Fill(dst, "PrintBills");

Cryrpt.Load("BillsBetweenTwoNumbers.rpt");

Cryrpt.SetDataSource(dst.Tables[0]);

crystalReportViewer1.ReportSource = Cryrpt;

con.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

Class1.strinv = "";

}

Chidiebere Mgbemena · Answer

Hello Lax, am still having the error of "Report Load Failed"   If i dont use crystaldocument what else can i use?   set the codes for me, i dont understand what to do   here is my report path:  C:\Users\g\documents\visual studio 2015\Projects\NSPM_Sales_Invoice\NSPM_Sales_Invoice\Reports.rpt   Please help am running out of my mind.   thanks

Laxmidhar Sahoo · Answer

hi 1 - Do not use crystaldocument 2- when you add the report to your solution ,a name is provided to that report 3- that is the object name 4-supose you provide the name CustomerReport.rpt then cor code should CustomerReport Cryrpt = new CustomerReport(); Customers dsCustomers = GetData(); Cryrpt.SetDataSource(dst.Tables[0]); this.crystalReportViewer1.ReportSource = Cryrpt; this.crystalReportViewer1.RefreshReport();

Chidiebere Mgbemena · Answer

Lax, please how to I check the report path and name?

Laxmidhar Sahoo · Answer

Cryrpt.Load("BillsBetweenTwoNumbers.rpt");   In the above line check the report name and path

Chidiebere Mgbemena · Answer

Its closed now but it still cant load field what should i do?

Rajanikant Hawaldar · Answer

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
namespace NSPM_Sales_Invoice
{
public partial class BillsBetweenTwoNos : Form
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.NSPM_Sales_InvoiceCon);
ReportDocument Cryrpt = new ReportDocument();
SqlDataAdapter dr;
public BillsBetweenTwoNos()
{
InitializeComponent();
}
private void btnFindJobs_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer,Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo Between '"+textBox1.Text+"' and '"+textBox2.Text+"' ", con);
DataSet dst = new DataSet();
da.Fill(dst, "PrintBills");
Cryrpt.Load("BillsBetweenTwoNumbers.rpt");
Cryrpt.SetDataSource(dst.Tables[0]);
crystalReportViewer1.ReportSource = Cryrpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void BillsBetweenTwoNos_Load(object sender, EventArgs e)
{
textBox1.Text = Class1.strinv;
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select Tbl_HeaderData.JobNo,Tbl_HeaderData.Date,Tbl_HeaderData.GoodValue,Tbl_HeaderData.Vat,Tbl_HeaderData.StampDuty,Tbl_HeaderData.DeliveryCharges,Tbl_HeaderData.OtherCharges,Tbl_HeaderData.Total,Tbl_RowData.SINo,Tbl_RowData.Customer,Tbl_RowData.Description,Tbl_RowData.Price,Tbl_Rowdata.Quantity,Tbl_RowData.Value,Tbl_RowData.JobNo from Tbl_HeaderData Inner Join Tbl_RowData on Tbl_HeaderData.JobNo = Tbl_RowData.JobNo Where Tbl_HeaderData.JobNo Between '" + textBox1.Text+"' and '"+textBox2.Text+"' ", con);
DataSet dst = new DataSet();
da.Fill(dst, "PrintBills");
Cryrpt.Load("BillsBetweenTwoNumbers.rpt");
Cryrpt.SetDataSource(dst.Tables[0]);
crystalReportViewer1.ReportSource = Cryrpt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Finally
{
con.Close();
}
Class1.strinv = "";
}
}
}