-2

If I have a list object which groups a tablix according to a country value in my dataset, is it possible to add my own custom combinations?

E.g. If I have UK, France, Germany, US, Japan boxes, and then one for EU which puts UK France and Germany in one group?

I can do this in SQL Server 2008 with grouping sets, but can a similar thing be done in SSRS?

Anup Agrawal
  • 6,551
  • 1
  • 26
  • 32
Paul M
  • 1

1 Answers1

0

You can add a Calculated Field to your dataset (right-click on it). In the expression for it, use a Switch statement to decide the group name. Then you can use that Calculated Field in your report just like any other field.

StevenWhite
  • 5,907
  • 3
  • 21
  • 46