CODEWITHSUNDEEP
sqlssrs-2012ssrs-grouping
Novice_Techie
Novice_Techie

Reputation: 444

Multiple grouping in a tablix

I have a data set something like this.

I Need to create Report something like this. enter image description here

Took a tablix, inserted category then added a row group by category as group header. Then sub-category as category. I am able to get till Amount, however stock and piece are not in (category & sub-category group span). I am not able to get after amount field. Please give some workarounds.

Upvotes: 0

Views: 147

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Create a tablix with the following Row Groups settings.

enter image description here

Add a column to the right side of Subcategory and select Inside the Group for Amt.

enter image description here

For Piece sum add a column to right side of Stock.

Also delete the details group and hide the details column by right clicking on it and going to Column Visibility, select Hide.

You will get the expected result:

enter image description here

Let me know if this helps.

Upvotes: 1

Related Questions