I am using crystal reports for printing the fees details of students but i am getting exception.

Question

0.00/5 (No votes)

See more:

Hello there ,

I am using crystal reports for printing the fees details of students but i am getting exception.
Exception is "Object reference not set to an instance of an object."

My code is:

C#

public Payreport(int studid) //studid is the student id which admin is selecting
        {
           
            this.studid = studid;
            
            ClsConnection.Conn.Open();
            string sql = "SELECT ADD_Master.FName, ADD_Master.MName, ADD_Master.LName, tbinst_details.inst_id, tbinst_details.inst_amt, tbinst_details.note,tbinst_details.inst_date, tbinst_details.inst_type FROM tbinst_details INNER JOIN ADD_Master ON ADD_Master.ADD_No = tbinst_details.stu_id where stu_id= '" + studid + "'";
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, ClsConnection.Conn);
            DataSet ds = new DataSet();
            //DataSet ds = new DataSet();
            dscmd.Fill(ds);
           
            

            Pay objRpt = new Pay();
            objRpt.SetDataSource(ds.Tables[0]);
            crystalReportViewer1.ReportSource = objRpt;//getting exception here. 
            crystalReportViewer1.Refresh();
            ClsConnection.Conn.Close();

Posted 6-Feb-12 21:18pm

SantoshRohinSantosh

Updated 6-Feb-12 21:23pm

v3

Add a Solution

Comments

thatraja 7-Feb-12 3:22am

Error on which line? Debug & see the values.

SantoshRohinSantosh 7-Feb-12 3:24am

Ya I debug values are coming right but still I am getting exception.

OriginalGriff 7-Feb-12 3:22am

Which line is it excepting on?

zyck 7-Feb-12 3:26am

does objRpt has value?

try to debug if objRpt is not empty

SantoshRohinSantosh 7-Feb-12 3:31am

Ya it have value.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-02-06T21:32:00

The most likely reason for that error is that you haven't assigned anything to crystalReportViewer1:

C#

CrystalReportViewer crystalReportViewer1 = new CrystalReportViewer();

Or similar.

Put a breakpoint on the line:

C#

crystalReportViewer1.ReportSource = objRpt;

And you will see that it contains null

zyck · Answer 2 · 2012-02-06T22:22:00

Solution 2

try to replace this code

HTML

crystalReportViewer1.ReportSource = ds.Tables[0];           
crystalReportViewer1.Refresh();
ClsConnection.Conn.Close();.

Posted 6-Feb-12 22:22pm

zyck

Updated 6-Feb-12 22:27pm

v3