views:

178

answers:

2

The situation: I am generating reports using Report Builder 2.0 and a Report Model that I have created.

The question: How does one sort a parameter list alphabetically? Simple question, but I can't find the answer for the life of me. Kudos to whoever can provide an answer.

+1  A: 

Depends how your defining the list, but most commonly by adding an order by statement to the sql that defines the parameter list.

Paul Creasey
As the question states, I am tied to a Report Model, and therefore do not have direct database access.
James Jones
A: 

As it turns out, the answer to my question does not exist because it is not possible. There is an open issue at connect.microsoft.com for this missing feature. Please upvote it on Microsoft's site so that they will fix it in the upcoming version of Report Builder. Thanks.

James Jones