SSRS Repeating group headers?

debugcn Published at Dev

user2553512

I have this data

DateRecived      JObNumber         REcCnt
20130626          1234               1
20130627          1238               11
20130628          1240               2
20130629          1242               23

I applied the group by on dateRecieved in ssrs and get the output as

DateRecived      JObNumber         REcCnt
20130626          1234               1
20130627          1238               11
20130628          1240               2
20130629          1242               23
                  Total              37

But i want the output as

DateRecived      JObNumber         REcCnt
20130626          1234               1
                 Total               1
DateRecived      JObNumber         REcCnt
20130627          1238               11
                 Total               11
DateRecived      JObNumber         REcCnt
20130627          1240               2
                  Total              2
DateRecived      JObNumber         REcCnt
20130628          1242               23
                  Total              23

I don't know how to repeat the group header and calculate the sum for each group in SSRS any help would be great .

Mahesh

Here's a small example with some mock data that should be more or less analogous to your situation.

The dataset:

 Market    SubMarket
 ------    ---------
  A         1
  A         2
  A         3
  B         4
  B         5
  B         6
  B         7

Here are the steps I've taken to create the table:

1) Drag/drop a new, fresh table to the designer.

2) Drag/drop the SubMarket field to the first column.

3) Right-click the detail row and add a new parent group.

enter image description here

4) Group on Market and choose to add a group header row.

enter image description here

As you've already noted, SSRS "helps" and adds an extra column.

5) Right-click the extra (first) column and delete it.

6) Select the cell in the header row for the group and enter "[Market]", or pick it from the quick-list.

enter image description here

7) Finish up by filling in the other fields/columns/cells. For the header row drag/drop won't work, you'll have to pick the fields for that row yourself (or type 'em).

This is the resulting table in preview (with some emphasis on the header row):

enter image description here

For your solution you have to add all the other rows in detail section other than the fields on which you want to apply the group by.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-20

Comments

0 comments

From Dev

Related Related

Article

SSRS Repeating group headers?

SSRS Repeating group headers?

SSRS remove repeating group rows

Prevent section headers from repeating in SSRS groups

Counts repeating for groups in ssrs report

SSRS repeating background image issue

Print repeating Page headers in Chrome

Using a header of headers instead of repeating

Repeating a capturing group

Refining a regex repeating group

django urlpattern for repeating group?

Repeating an expression group

SSRS. How to group in a group?

How to group ssrs report with a group

SSRS sum max by group

SSRS Group by in the List Report

SSRS - Group By Multiple Values

SSRS Group Properties

SSRS group by ranges

how to colour the group in ssrs

Controlling row group in ssrs

Rotate secondary group in SSRS

Tablix Headers repeating on PDF exports, but not Word

group headers in Jqgrid treeGridModel

JavaScript regexp repeating (sub)group

Running count of repeating values by group

Postgree double group by repeating attribute

SSRS Matrix Bespoke Headers (Still from datasource!!)

SSRS Multiple Headers-Footers /Single List

SSRS Details Group Header Label

SSRS Group By Data in Row but Vertically