Order by or sort in Parameter for Report Builder

• jefobr

  Old Hand

  Points: 342

  More actions

  January 6, 2009 at 10:53 am

  #197943

  In Report Builder 2.0 I don't see a way of Sorting Parameters while using a Model. Semantic Queries are generated automatically when adding Parameters. Most report building products allow you to sort Alphabetically. If this were T SQL I could easily do this. Does anyone know of a workaround?

• jefobr

  Old Hand

  Points: 342

  More actions

  January 22, 2009 at 2:46 pm

  #931495

  Bump.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  January 22, 2009 at 8:06 pm

  #931595

  You could create a view with OrderBy and use it as your report datasource. There are known issues with Orderby in views but you could try.

  Kind regards,
  Gift Peddie