This week I was asked twice, by two different (luckily) colleagues, if I knew how to change the order of the parameters in a report in SQL Server Reporting Services. I still remember that the first time when I needed this after my upgrade to 2008, I also spent some time looking for it. Apparently it’s still hard to find so I’ve now decided to write a quick post about it. I promise you, once you know it you’ll say “how silly”.
The following screenshot should say it all:
That’s right, those two small arrow buttons in the Report Data pane can be used to move the parameters up or down. They may be difficult to spot but once you’ve found them you’ll never forget. Why are they difficult to spot?
For several reasons:
- they are greyed out when no parameter is selected
- they may not be visible when your Report Data pane is too small
How silly huh?