Grouping in SSRS?

I am new to SSRS and have the data below:

RCnt Jobnumber NJCT JD pmt flag cnt1 cnt2 2 001008 0 PRESSURE SEAL PSI Y 0 0 2 2 001008 0 PRESSURE SEAL PSI Y 0 0 10 2 001008 0 PRESSURE SEAL PSI Y 0 0 1 1 001009 0 Single Sheet Duplex Legal PSI Y 0 0 1 1 001009 0 Single Sheet Duplex Legal PSI Y 0 0 4 6 001010 0 Single Sheet Duplex Legal PSI Y 0 0 6 5 001011 0 Single Sheet Duplex Legal PSI Y 0 0 5 5 001011 0 Single Sheet Duplex Legal PSI Y 0 0 3 13 001012 13 Single Sheet Duplex Legal PSI Y 0 13 0 13 001012 17 Single Sheet Duplex Legal PSI Y 0 17 0 13 001012 8 Single Sheet Duplex Legal PSI Y 0 8 0 

And I want to display it as below,

 jobNumber NJCT JD cnt2 Rcnt 001008 0 PRESSURE SEAL 13 2 001009 0 Single Sheet Duplex Legal 5 1 001010 0 Single Sheet Duplex Legal 6 6 001011 0 Single Sheet Duplex Legal 8 5 001012 38 Single Sheet Duplex Legal 0 13 TOTAL 38 32 27 

I know that this grouping can be performed at the server level in the request, but I do not have access to the request, and I need to format this data as shown in the report below using SSRS , maybe this is a simple grouping I donโ€™t know when I googled about grouping it gave me a level column and grouping at the row level, which left me very confused, so any help related to this would be very helpful. All links can also be obtained by grouping like this in SSRS .

+6
source share
1 answer

Your data set has the following data:

enter image description here

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 .

enter image description here

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

enter image description here

It will look like this:

enter image description here

Right-click on the first column and select Delete Columns .

Right-click on the details row and select Delete Rows :

enter image description here

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 :

enter image description here

It should look like this:

enter image description here

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 :

enter image description here

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

enter image description here

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.

+14
source

Source: https://habr.com/ru/post/952279/


All Articles