CSLA Business Objects + SQL Reporting Services 2005

CSLA Business Objects + SQL Reporting Services 2005

Old forum URL: forums.lhotka.net/forums/t/7504.aspx


SouthSpawn posted on Monday, August 24, 2009

Is it possible to bind a CSLA BO to a SQL 2005 report?

It would be nice and easier if I could just take my BO and bind it directly to a report.

Is this possible?
If so, are there any performance hits to this.
Also any URLs out there explaining how to do this?

Thanks

ajj3085 replied on Monday, August 24, 2009

Yes, using local reports. I haven't tried Csla + server report.

As for urls, check out gotreportviewer.com; you give it Csla objects just as you would POCO objects.

I haven't measured performance, becuase this is the only way I do reports... but it seems to be fast.

JonnyBee replied on Monday, August 24, 2009

Hi,

It is possible to bind to objects serverside too, but very cumbersome and poorly documented so I don't recommend doing that.

www.gotreportviewer.com is an excellent starting point.

And a walkthrough example on MSDN:
http://msdn.microsoft.com/en-us/library/ms251784%28VS.80%29.aspx

You may also download the latest trunk from "Csla 3.6.3 for .Net 2.0" samples - I have added 2 reports to the PTWin solution using ReportViewer and objects as datasource. One simple list report and one report with subreport. (Solution requires Visual Studio 2008 but compiles for .Net 2.0 SP1 runtime)

/jonnybee





SouthSpawn replied on Wednesday, August 26, 2009

I am doing an ASP.net application.
So is this still possible?

JonnyBee replied on Wednesday, August 26, 2009

Yes,

ReportViewer comes in both Windows Form s and ASP.NET. You'll find several examples on www.gotreportviewer.com .

So, yes - you can use ReportViewer in ASP.NET with object data sources.

/jonnybee

Copyright (c) Marimer LLC