Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parameter Order-how change? Expand / Collapse
Author
Message
Posted Sunday, December 21, 2008 9:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 2:48 PM
Points: 2, Visits: 26
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



Post #623708
Posted Sunday, December 21, 2008 10:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, January 30, 2014 12:45 PM
Points: 339, Visits: 716
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
Post #623719
Posted Monday, December 22, 2008 1:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 2:48 PM
Points: 2, Visits: 26
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????



Post #624214
Posted Tuesday, December 23, 2008 12:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
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
Post #624938
Posted Monday, August 26, 2013 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:36 PM
Points: 2, Visits: 22
Five years later, and Siva's reply solved my problem... thanks!

-Thomas
Post #1488456
Posted Monday, August 26, 2013 11:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:50 AM
Points: 11,264, Visits: 13,022
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.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1488466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse