Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SSRS 2008 Report Parameters Ordering

Posted by admin On January - 14 - 2009

Yes, okay, call me a dolt for having to take five minutes to find this but I’ve seen this question asked so many places I figured I’d throw it up here.

In Visual Studio 2008 when working on a SQL Server Reporting Services report, you may find that you want to change the order in which the parameters are listed to the end user. Or perhaps you are using unnamed parameters, such as with ODBC, and need to change the order for token replacement in your query. Well in 2008 this is not where you expected it to be if coming from 2005.

To start with, see if you have the Report Data region showing. If not, go to the toolbar and click View –> Report Data as shown below.

Now, find the parameters section and expand it. Pick a parameter that needs re-ordering. Click and highlight the parameter. Now a little further up you will see a set of up and down arrows. Use these to move the parameter, re-order the list of parameters.

I know, too simple right? Well, sometimes the obvious things are easily overlooked.

Blessings to you!


Popularity: 25% [?]

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • email
  • LinkedIn
  • PDF
  • RSS
  • Slashdot
  • StumbleUpon
  • Technorati
  • Twitter

3 Responses to “SSRS 2008 Report Parameters Ordering”

  1. Ted says:

    Thanks.
    I figured it was that easy and you and Google came through faster than I would have.

  2. Suresh says:

    I too overlooked it :(

    Thanks for the post.

    Regards
    Suresh

  3. Manoj says:

    This is not working for me. Also, I could n’t view the images in the blog. Can you explain me in detail?

Leave a Reply