CSLA Business Objects + SQL Reporting Services 2005CSLA 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