Parameter Order-how change?

  • Well, I've finally come over from the dark side and started using SSRS for reporting instead of MS Access. The learning curve doesnt seem to steep, but my biggest problem is finding good web based resources!

    Here is my problem:

    If you have parameters based on datasets that in-tern has a parameters in it, then you must list the parameters in the correct order or you get the error message:

    "forward dependencies are not valid"

    So far, the only way I have found to change the order is to delete all of my parameters and re-create them it the correct order. Thought I could just rename then with a numeric character to force the sort order, but they only list by creation order. I've waster half a day tracking down this problem. now I understand the problem, I'm looking for a "re-order" button, but htere doent seem to be one.

    I'm starting to think .....pretty dumb functionality (or lack of) for Microsoft's flagship reporting tool, but will withhold that comment in case there is some other way to change the order.

    Someone please tell me there is another way to change the order

    I'm using SQL Server 2008 Express.

    Thanks

    Grant

  • Hello Grant,

    Absolutely..there is a way to re-order your parameters...

    Please try this..once..

    Go to --> Report Tab--> Report Parameters Option --> You will find Parameters listed (beside that there are up and down arrows...) --> Using those...you can re-order the report level parameters.

    Thanks,

    Niraj

  • Thanks for the suggestion, but in SQL 2008 Express version Business Intelligence Development Studio (Visual Studio by any other name!@#$), its a new user interface

    There is a "Report Data" tab that sits on the left hand side of the screen which has "built in fields", "parameters" and "datasets" as separate tree nodes. I cant find any up/down arrows in the parameter tree to re-order.

    Anyone else using Vis Studio 2008 that can tell me how to re-order parameters????

  • Under Report Data, please note there is a menu bar under Report Data with New, Edit, Delete icon and two arrows. We will come to these arrows later.

    Expand Parameters node.

    Click on the first parameter.

    Once you have clicked on the first parameter, the menu bar under Report Data that has New, Edit, and Delete icon will have a up and down arrow in blue. Click on the down arrow and your first parameter will move down below the second parameter.

    This will help you re-order your params.

    View Siva Gurusamy's profile on LinkedIn

    "Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

  • Five years later, and Siva's reply solved my problem... thanks!

    -Thomas

  • Ha all the reports I've developed and I've never noticed the arrows to adjust parameter order. I've been right-clicking the report -> View Code and then manually moving parameters around in the RDL.

  • Thank you for this! Like someone mentioned earlier I never noticed the up/down arrows either!

    Color me shamed!

    Stu

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply