SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Parameter Order-how change?


Parameter Order-how change?

Author
Message
grant-972568
grant-972568
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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
Niraj-627298
Niraj-627298
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 719
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
grant-972568
grant-972568
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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????
Siva Gurusamy
Siva Gurusamy
Old Hand
Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)Old Hand (347 reputation)

Group: General Forum Members
Points: 347 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
thomaswoof
thomaswoof
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 27
Five years later, and Siva's reply solved my problem... thanks!

-Thomas
Jack Corbett
  Jack Corbett
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19378 Visits: 14900
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
stuart.schmied2
stuart.schmied2
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 21
Thank you for this! Like someone mentioned earlier I never noticed the up/down arrows either!

Color me shamed!

Stu
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search