Object reference not set to an instance of an object error i

Question

How to solve this error- Object reference not set to an instance of an object error in crystal repor t in asp.net c#

Manish Dwivedi · Answer

Hi Zaid, First it is necessary to know when object reference error generate. Suppose you have one object for example dataSet and you access table like that dataSet.Tables[0] and your object dataSet is null, in that case you will get the error Object Reference not set to an instance of an object. I think you got my point. Debug you code and check where you are accessing the null object.

Mohammed Zaid Meraj · Answer

order1 is my database table name and qur is a query from date to date

Manish Dwivedi · Answer

What is order1 in you code. Make sure it's not null before accessing order1.sdate i think error will be on this statement. comment this code CrystalReportViewer1.SelectionFormula = qur; and then try.

Ranjit Powar · Answer

check parameter values

Mohammed Zaid Meraj · Answer

what I do after this code CrystalReportViewer1.RefreshReport(); cryRpt.Load(Server.MapPath("~/Report/BillR.rpt")); cryRpt.SetDatabaseLogon("root", "admin", "localhost", "restaurent_web"); qur = "{order1.sdate} >=date('" + datefrom + "') And {order1.sdate}<= date('" + dateto + "')"; CrystalReportViewer1.SelectionFormula = qur; CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind();

Ranjit Powar · Answer

As manish said, there must be some null values. Debug your code and check values.

Mohammed Zaid Meraj · Answer

Yes ReportDocument cryRpt = new ReportDocument(); string qur = "";

Ranjit Powar · Answer

Did you create object of report document?

Mohammed Zaid Meraj · Answer

CrystalReportViewer1.RefreshReport(); cryRpt.Load(Server.MapPath("~/Report/SalesReport.rpt")); cryRpt.SetDatabaseLogon("root", "admin", "localhost", "restaurent_web"); qur = "{order1.sdate} >=date('" + datefrom + "') And {order1.sdate}<= date('" + dateto + "')"; CrystalReportViewer1.SelectionFormula = qur; CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); error- Object reference not set to an instance of an object.

Ranjit Powar · Answer

Share code where you get error

Ranjit Powar · Answer

Share code where you get error