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.
4) group on market , choose add group header row.
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.
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):
for solution have add other rows in detail section other fields on want apply group by.
Comments
Post a Comment