http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/Newb to SQL Reports 2005, does this call for a matrix?http://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/en-usMon, 22 Sep 2008 22:48:06 GMTMon, 22 Sep 2008 22:48:06 GMTEvNet (EvNet, Version=1.0.3599.6114, Culture=neutral, PublicKeyToken=null)Are you running the reports with a SQL report server or from ASP.NET?<BR>With SQL Server 2005 the reports can handle anything SQL Server sends them, you just need to drill it down on the report.<BR><BR>This sort of thing got much easier in SQL Server 2008.<BR><A href="http://blogs.msdn.com/sqlrsteamblog/archive/2008/08/25/ReportBuilder20-RC1-Release.aspx">http://blogs.msdn.com/sqlrsteamblog/archive/2008/08/25/ReportBuilder20-RC1-Release.aspx</A><BR><BR>btw: <A href="http://www.gotreportviewer.com/">http://www.gotreportviewer.com/</A>http://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/?CommentID=429028Mon, 22 Sep 2008 22:48:06 GMThttp://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/?CommentID=4290280http://channel9.msdn.com/429028/WebViewBug.aspx?EVT=0Are you running the reports with a SQL report server or from ASP.NET?With SQL Server 2005 the reports can handle anything SQL Server sends them, you just need to drill it down on the report.This sort of thing got much easier in SQL Server&#8230;Mark Wisecarver0http://channel9.msdn.com/429028/Trackback.aspxI'm not familar with SQL Reports (our company uses Oracle) but you could do it with subqueries rather than subreports.&nbsp; It might be a bit faster that way.http://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/?CommentID=429023Mon, 22 Sep 2008 21:55:19 GMThttp://channel9.msdn.com/forums/TechOff/428984-Newb-to-SQL-Reports-2005-does-this-call-for-a-matrix/?CommentID=4290230http://channel9.msdn.com/429023/WebViewBug.aspx?EVT=0I'm not familar with SQL Reports (our company uses Oracle) but you could do it with subqueries rather than subreports.&nbsp; It might be a bit faster that way.Scott0http://channel9.msdn.com/429023/Trackback.aspx