Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Matrix reports

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-04-14 : 10:30:45
Is matrix reports in SSRS similar to the crystal cross tab reports, if so, I am trying to create my first report using reporting services in matrix report format, can you please send me a good reference I can use to create my first report. Thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-14 : 11:32:23
A matrix basically requires a column group and a row group. the row group is given as that value which we display horizontally as each row header. the column group specifies that value which we display as columns of the report. The data portion of the report will consist of an expression using an aggregation function on any of our dataset fields. The report aggregates the field value after grouping on row and column grouping fields to render the report.

http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1168511,00.html
Go to Top of Page
   

- Advertisement -