From the course: SQL Server: Reporting Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand matrixes - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Understand matrixes
- The report builder interface seems to indicate that there are two different data region elements called tables and matrices. The reality is that they're actually the same thing with one minor difference in their configuration. Once again, I'm going to create a new paginated report. In report builder, I'll choose the table or matrix wizard. And we'll select the warehouse stock share data set. On this screen we have the familiar values, row groups, and column groups boxes. Here's what differentiates a table from a matrix. A table includes values and optionally, row groups. As soon as you add a column group you've created a matrix. That' it. That's the only difference between the two. If you have a column group, it's a matrix; if you don't, it's a table. Column groups work the same way as row groups in they'll grow the matrix horizontally to fit the data. Where, row groups expand the table vertically. Let's build a matrix that looks at two different product categories. I'll add stock…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.