Crystal Reports with Linq to Sql

Question

0.00/5 (No votes)

See more:

Now i modified the code as: .FirstorDefault(); to ToList();

Now I got :
Quote:
System.NullReferenceException: Object reference not set to an instance of an object.

rptStudyCertificate rsc = new rptStudyCertificate();
using (DataClasseDataContext db = new DataClasseDataContext())
{
var list = (from data in db.StudyCertificates
join clsdet in db.StudentClassDetails on data.AdmissionNo equals clsdet.AdmissionNo
where data.ID == Convert.ToInt16(sno)
select new { ID = data.ID, Class = clsdet.Class, AcademicYear = clsdet.AcademicYear, AdmissionNo = clsdet.AdmissionNo, Conduct = data.Conduct}).ToList();

if (list != null)
{
rsc.SetDataSource(list);
CrystalReportViewer1.ReportSource = rsc;
}
}

Thanks in advance...................

Posted 11-Jun-13 0:38am

Siva Prakash Nammi

Updated 12-Jun-13 21:16pm

v5

Add a Solution

Comments

Jameel VM 11-Jun-13 6:54am

in which line you got the exception?

Siva Prakash Nammi 11-Jun-13 7:08am

CrystalReportViewer1.ReportSource=rsc;

Siva Prakash Nammi 11-Jun-13 7:07am

CrystalReportViewer1.ReportSource=rsc;

Ahmed Bensaid 11-Jun-13 16:44pm

An object is necessarily null on this line.
And the winner is ... CrystalReportViewer1 ;)
Where do you declare and instantiate this object ?

Siva Prakash Nammi 12-Jun-13 0:32am

Actually i got values into the list, but it shows an error like

System.NullReferenceException: Object reference not set to an instance of an object.

Please help me...

Ahmed Bensaid 12-Jun-13 3:28am

I wasn't talking about your list, but about your CrystalReportViewer1 object ...
Where do you declare and instantiate this object ?

Siva Prakash Nammi 12-Jun-13 5:16am

i never instantiate crystalreportsviewer1,
i just drag and drop this item into my page, and used to bind datasource.

Anup Kumar Verma 12-Jun-13 8:29am

Anup Sir U r great.....aaj mai aapko jan paya............i am proud work with u

Siva Prakash Nammi 13-Jun-13 3:13am

i cant solve this error in crystal reports with linq to sql :

ERROR: "DataSet does not support System.Nullable<>".

Below is my code:

using (DataClasseDataContext db = new DataClasseDataContext())
{
var data = (from records in db.vwStudycertificates

where records.ID == Convert.ToInt16(sno)
select new { ID = records.ID, Class = records.Class, AcademicYear = records.AcademicYear, AdmissionNo = records.AdmissionNo, Conduct = records.Conduct, Name = records.Name, surname = records.Surname, SchoolID = records.SchoolID }).ToList();
if (data != null)
{

rptStudyCertificate rsc = new rptStudyCertificate();
rsc.SetDataSource(data);
CrystalReportViewer1.ReportSource = rsc;

}

Thanks in advance.........................

1 solution

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)

Andy Lanng · Accepted Answer · 2013-06-12T02:24:00

Solution 1

Try this:

C#

rptStudyCertificate rsc = new rptStudyCertificate();

//This is the instantiation that Ahmed suggested.  You can do this here or earlier
CrystalReportViewer1 = new CrystalReportViewer();

using (DataClasseDataContext db = new DataClasseDataContext())
{
   var list = (from data in db.StudyCertificates
   join clsdet in db.StudentClassDetails on data.AdmissionNo equals clsdet.AdmissionNo
   where data.ID == Convert.ToInt16(sno)
   select new { ID = data.ID, Class = clsdet.Class, AcademicYear = 
   clsdet.AcademicYear, AdmissionNo = 
   clsdet.AdmissionNo, Conduct = data.Conduct}).ToList();
 

  if (list != null)
  {
    rsc.SetDataSource(list);
    CrystalReportViewer1.ReportSource = rsc;
  }
}

Posted 12-Jun-13 2:24am

Andy Lanng

Comments

Siva Prakash Nammi 13-Jun-13 3:14am

i cant solve this error in crystal reports with linq to sql :

ERROR: "DataSet does not support System.Nullable<>".
I got this error in. "rsc.SetDataSource(data);"

Below is my code:

using (DataClasseDataContext db = new DataClasseDataContext())
{
var data = (from records in db.vwStudycertificates

where records.ID == Convert.ToInt16(sno)
select new { ID = records.ID, Class = records.Class, AcademicYear = records.AcademicYear, AdmissionNo = records.AdmissionNo, Conduct = records.Conduct, Name = records.Name, surname = records.Surname, SchoolID = records.SchoolID }).ToList();
if (data != null)
{

rptStudyCertificate rsc = new rptStudyCertificate();
rsc.SetDataSource(data);
CrystalReportViewer1.ReportSource = rsc;

}

Thanks in advance.........................

Andy Lanng 13-Jun-13 4:35am

Ok - this is a new question so should be posted as such. You'll get better responses and we get more points ^_^
Your var is an anonymous type which has a nullable value because one of you result fields is null. It cannot translate a nullable object into a datatable which is what SetDataSource is attempting to do.
You might find implicitly converting 'data' to a datatable first so you can control the conversion. take a look at this extension method that does just that
http://stackoverflow.com/questions/1253725/convert-ienumerable-to-datatable

PS: please accept the solution to the previous question. Thanks ^_^