Your data set has the following data:

Drag the table into the report and set its data set in the properties. Right-click on the left of the table with three rows and click Add Group โ Parent Group .

Group in the Jobnumber field and check the Enable group header box:

It will look like this:

Right-click on the first column and select Delete Columns .
Right-click on the details row and select Delete Rows :

Click OK when prompted with Delete Rows and Related Groups?
Finally, we need a table footer row - click on the bottom row and click Insert Row โ External Group - below :

It should look like this:

Now add your details! Add new columns if necessary. When adding numeric data to these group and header fields by default, it will be Sum :

Now the table is mostly similar to requirements; just to taste:

In addition, some links on request:
Books on the Internet, Adding Grouping and Totals (Reporting Services) .
SQL Server Central, Tablix Tutorial .
This should be a good introduction and part of a larger series of articles.
source share