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

Answer 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.