Matrix Tips and Techniques to Display Data in SQL Server


show more A matrix in an SQL Server is a configurable data region or tablix that can expand vertically by increasing or reducing the number of columns. It can also expand horizontally by increasing or reducing the number of rows needed to meaningfully express data. This online video helps you learn about displaying data in a matrix and embedding the data in a report. show less
please wait ...

Displaying data in a matrix

When we have repeating data in our report, when we know that we have multiple rows of data to show, we're going to end up using one of three different options here in Report Builder-- the Table, the Matrix, and the List-- and these are known as data regions. So what's the difference? Well, the list is the simplest. This is just a free-form region that will repeat whatever you drag and drop into it, and we'll see that one later. Tables and matrixes, or matrices, are more common, more interesting, and more configurable. But whether you select a table, a matrix, or a list, you're really using the same thing.

It's an element called a tablix. So working with these is all very similar. I've already shown a couple of table examples, and what I'm looking at right now is the Products By Category report I created earlier. It doesn't really matter. There's nothing special about this one. But if I grab this table by clicking anywhere inside it and then clicking that top...

Displaying data in a matrix
Video duration: 8m 12s 3h 44m Advanced

Viewers:

A matrix in an SQL Server is a configurable data region or tablix that can expand vertically by increasing or reducing the number of columns. It can also expand horizontally by increasing or reducing the number of rows needed to meaningfully express data. This online video helps you learn about displaying data in a matrix and embedding the data in a report.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...