Newb to SQL Reports 2005, does this call for a matrix?

Posted By: qwert231 | Sep 22nd, 2008 @ 10:34 AM
page 1 of 1
Comments: 2 | Views: 653
#Sep 22nd, 2008 @ 10:34 AM
qwert231
qwert231
M Kenyon
I have data that I am going to use for a report. The data comes like this:

CustomerID, Zip, Age, ZipCodePopulation, ...

And they want the report to show totals like this:



I was thinking that each section (Age, Gender, Pop Density) could be different sub reports, but what is the best way to create a SQL report for this data.
#Sep 22nd, 2008 @ 2:55 PM
spivonious
spivonious
I'm not familar with SQL Reports (our company uses Oracle) but you could do it with subqueries rather than subreports.  It might be a bit faster that way.
#Sep 22nd, 2008 @ 3:48 PM
wisemx
wisemx
Live it
Are 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 2008.
http://blogs.msdn.com/sqlrsteamblog/archive/2008/08/25/ReportBuilder20-RC1-Release.aspx

btw: http://www.gotreportviewer.com/
page 1 of 1
Comments: 2 | Views: 653
Microsoft Communities