SSRS Switch Sort

Question

I have the following switch statement on a text box:

=Switch(Fields!Column1.Value ="V10", "A", Fields!Column1.Value ="V2", "B", Fields!CColumn1.Value ="V7", "C")

Then it has been sorted on Fields!Column1.Value.

When I run the report the data it shows like this.

B
C
A

how can I sort the data so it show like this?

A
B
C

can you please give some screenshots of your report table or tablix. — Jacky Montevirgen, Dec 20 '16 at 06:53
@netraider Use the switch expression as the sort expression in the Tablix — R. Richards, Dec 20 '16 at 13:38

score 1 · Answer 1 · answered Dec 20 '16 at 09:08

1

You could create a calculated field on your DataSet to hold your A, B, and C values, then just show that calculated field on your report and sort by it.

answered Dec 20 '16 at 09:08

3N1GM4

3,372
3
19
40

SSRS Switch Sort

1 Answers1