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