reporting services - SSRS Repeating group headers? -


i have data

daterecived      jobnumber         reccnt 20130626          1234               1 20130627          1238               11 20130628          1240               2 20130629          1242               23 

i applied group on daterecieved in ssrs , output

daterecived      jobnumber         reccnt 20130626          1234               1 20130627          1238               11 20130628          1240               2 20130629          1242               23                   total              37 

but want output

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 repeat group header , calculate sum each group in ssrs great .

here's small example mock data should more or less analogous situation.

the dataset:

 market    submarket  ------    ---------           1           2           3   b         4   b         5   b         6   b         7 

here steps i've taken create table:

1) drag/drop new, fresh table designer.

2) drag/drop submarket field first column.

3) right-click detail row , add new parent group.

enter image description here

4) group on market , choose add group header row.

enter image description here

as you've noted, ssrs "helps" , adds column.

5) right-click (first) column , delete it.

6) select cell in header row group , enter "[market]", or pick quick-list.

enter image description here

7) finish filling in other fields/columns/cells. header row drag/drop won't work, you'll have pick fields row (or type 'em).

this resulting table in preview (with emphasis on header row):

enter image description here

for solution have add other rows in detail section other fields on want apply group by.


Comments

Popular posts from this blog

java - activate/deactivate sonar maven plugin by profile? -

python - TypeError: can only concatenate tuple (not "float") to tuple -

java - What is the difference between String. and String.this. ? -