I am new to the SSRS and Have data like to be present as below. They are all from the same dataset, just like to group 2 columns, that is [WrkCrtId, Name] show on top of them. I've tried some ways to do this but still fail, I was wondering if any one can help?
p.s. the image below shows 2 groups (B3 and B7)
This is fairly simple to do. This is a quick summary of the things to do from memory so it may not be 100% correct.
details
group and chooseAdd Group -> Parent Group
. Select WrkCtrId as theGroup By
colum. and Check theAdd Group Header
option too.Insert Row -> Inside Group - Below
.Merge
. You can now centre justify the merged cells.Below is the report design. I've just used geographical data as a sample dataset but the theory is the same.
And here is the final output.
Hope this helps and good luck!