Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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}).FirstOrDefault();
 

                if (list != null)
                {
                    rsc.SetDataSource(list);
                    CrystalReportViewer1.ReportSource = rsc;
                }
            }
Please any one help me: i got an error at
rsc.SetDataSource(list);
error is: The data source object is invalid.
 

Thanks in advance...............
Posted 11-Jun-13 0:33am
Edited 11-Jun-13 4:27am
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Siva Prakash Nammi at 11-Jun-13 6:01am
   
By using .ToList()
 

i got this error
 

DataSet does not support System.Nullable<>.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

You can try debug,you can see list has data.
alternatively you can do it by dataset i think it easy than linq
  Permalink  
Comments
Siva Prakash Nammi at 12-Jun-13 0:31am
   
ya it is easy using dataset, but in my whole project i am using linq queries so thats why i want to use linq in crystal reports also,...................
Thắng Cv at 12-Jun-13 3:01am
   
I think you must add new row
rsc.Load(Server.MapPath("Name_Crystalreport"));

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

  Print Answers RSS
0 OriginalGriff 390
1 Jochen Arndt 165
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,032
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,220


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 11 Jun 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100