Can I mix Asc & Desc in Sort Expression?

[dianemarie]

Hello, SSRS 2005. I am using a sort expression on a group. In English: If @Parameter = "A", then sort by Field1 ASC else if @Parameter = "B" then sort by Field2 DESC. This doesn't seem possible in the sort properties of the group, as the Direction does not allow expression. I'm wondering if I can create a calculated field and then sort on that. Any help is appreciated. Thanks much.

 

[PWise]

Try

order by
case when @Parameter = "A" then field1 end asc,
case when @Parameter = "b" then field1 end desc