Click here to Skip to main content
15,884,838 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
C#
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
C#
rsc.SetDataSource(list);

error is: The data source object is invalid.



Thanks in advance...............
Posted
Updated 11-Jun-13 3:27am
v3

 
Share this answer
 
Comments
Siva Prakash Nammi 11-Jun-13 6:01am    
By using .ToList()


i got this error


DataSet does not support System.Nullable<>.
You can try debug,you can see list has data.
alternatively you can do it by dataset i think it easy than linq
 
Share this answer
 
Comments
Siva Prakash Nammi 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 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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900