Creating a matrix report

A matrix is an interesting representation format with a two-dimensional view of data, allowing capabilities to consolidate by row and column. This recipe will discuss how to add and use a matrix data region in reports. Totaling capabilities in the matrix reports will also be discussed.

How to do it…

The recipe is broken down into two sections. In the basic report design section, we will build a simple RDP that will be used in this recipe as well as in the other recipes found in this chapter; however, the actual recipe is given in the second section.

Basic report design

Before we start discussing this recipe, we will build an RDP class that can be used as a source for all the recipes in this chapter. This RDP will be used as the source of the dataset for all the reports in this chapter:

1. Create a query as seen here, the InventItemGroupItem table, which uses the existing join and is added for the purpose of limiting the sales lines data to certain item groups.
2. The...