LINQ Datasource

[Norsten]

Will Telerik Reporting 2008 Q1 support LINQ datasources?

[Svetoslav]

Hello Norsten,

Currently Telerik Reporting (incl. Q1 2008) is compiled against .NET 2.0 which restricts its data processing engine from working with the LINQ data sources. To support LINQ we have to move to .NET 3.0/3.5 that I hope we will do soon.

 
Regards,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Ian Blackburn]

You can of course use Linq to provide data to the report at runtime, just not in the designer.  For example the following is an example that we have used:

        Reports.Courses courseReport = new Reports.Courses();

        MyDataContext db = new MyDataContext();

        var data = from c in db.UserCourses

                   where c.Course.CentreId == int.Parse(DropDownList1.SelectedValue)

                   && c.Course.Start >= RadDateTimePicker1.SelectedDate

                   && c.Course.End <= RadDateTimePicker2.SelectedDate

                   select new { c.Course.Centre.Name, c.Course.Subject, c.Course.Tags, c.Course.Start, c.Course.End, c.User.Username, c.Comment, c.Public, c.CourseId, c.User.Email, c.User.MobileNumber };

        courseReport.DataSource = data;

        ReportViewer1.Report = courseReport;

        ReportViewer1.Visible = true;

[Steve]

Hello Ian,

You are of course correct that you can provide data programmatically, but the main benefit we would get when moving to LINQ, would be the faster filtering, grouping, sorting etc.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Doug Odegaard]

any ideas or plan on which release this might come out in?  I know that is a magic question and i won't hold you to it.  TIA....d

[Doug Odegaard]

I can set the Q2 2008 report to a business object and then choose one of my LINQ to SQL class objects with all of the fields and objects showing up.  But upon Preview it crashes Vsiaul Studio 2008.  Would this be an expected behavior at this point?

[Svetoslav]

Hi Doug Odegaard,

Although we plan to switch to .NET 3.0 we haven't set any time frame for it.

A possible reason for VS to crash when previewing a report is because of an exception while instantiating the report for the preview. According to our observations this often is a problem with the data source object that is usually prepared in the report's constructor right after the InitailizeComponent() method call. If this is your case please surround your code in a try-catch block and see what is the actual problem (exception) if any.

Kind regards,
Svetoslav
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.