change Parameter order

Hello,

I'd like to change the order in which Parameters are displayed. When I go to the menu Report - Report Parameters and change the order with the arrows displayed - I'll get the following error msg.:The value expression for the report parameter contains an error:The expression contains a non existing parameter in the report parameter collection.

Any ideas to change the order? Edit the XML File?

Thanks!You're doing it the right way. It sounds like you have dependent parametrs in which case they have to appear in order of dependency.|||Thats right they depent on each other but this was automatically. How can I turn that on or off? And if I turn that off - will my procedure to switch the position of the Parameter fields work?

Thanks!|||

Parameters become dependent when you use parameter A in the query that populates paramter B. This usually happens in the WHERE clause e.g.

SELECT *
FROM param_b_table
where some_column = @.param_a

Removing the WHERE clause should remove the dependency between the parameter and and allow you to reorder them.

But are you sure that removing the dependency is really what you want to do for the sake of ordering?

Obviously you won't be able to put the WHERE clause back in and expect to retain the ordering.

|||I'm not using any SQL Query. I use MS Reporting Services - Design Mode and click my Measures and Dimensions together.|||right so you're querying an Analysis Services 2005 cube using MDX. Fine so in the query design mode for your parameter query, remove the dependency to the other parameters.|||Here is my query. How can I switch the dependencies off. After doing this it is possible to change the order and switching the dependencies back on again?

SELECT NON EMPTY { } ON COLUMNS, NON EMPTY { ([Organisation].[Business Unit Description].[Business Unit Description].ALLMEMBERS * [Organisation].[Room Local Code].[Room Local Code].ALLMEMBERS * [Organisation].[Business Area Description].[Business Area Description].ALLMEMBERS * [Time].[Hour Description].[Hour Description].ALLMEMBERS * [Date].[Date].[Date].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.OrganisationRoomLocalCode, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.DateDate, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.OrganisationBusinessAreaDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Organisation].[Room Type Description].&[Recovery room] } ) ON COLUMNS FROM [Clinical Performance]))))) WHERE ( [Organisation].[Room Type Description].&[Recovery room], IIF( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED).Count = 1, STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED), [Organisation].[Main Unit Description].currentmember ) ) CELL PROPERTIES VALUE|||

I'll refer you to my previous answer in which I stated that you can't expect to put the WHERE clause back in and expect to retain the order. This is equivalent to putting back the dependency, you can'y do it and expect to retain ordering.

Once again, parameters with dependency must appear in order of dependency otherwise you'll get an error.

FYI, the dependencies in this query are highlighted. However, this looks like the main dataset query rather than a parameter dataset query and if so this is not the one you want to remove the dependencies from. Paramter order will need to be enforced if the parameters are dependet on each other, so it's the queries that feed the parameters you want to be looking at and not the main dataset query.

SELECT
NON EMPTY { } ON COLUMNS,
NON EMPTY { ([Organisation].[Business Unit Description].[Business Unit Description].ALLMEMBERS * [Organisation].[Room Local Code].[Room Local Code].ALLMEMBERS * [Organisation].[Business Area Description].[Business Area Description].ALLMEMBERS * [Time].[Hour Description].[Hour Description].ALLMEMBERS * [Date].[Date].[Date].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (
SELECT ( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.OrganisationRoomLocalCode, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.DateDate, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.OrganisationBusinessAreaDescription, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( { [Organisation].[Room Type Description].&[Recovery room] } ) ON COLUMNS
FROM [Clinical Performance])))))
WHERE ( [Organisation].[Room Type Description].&[Recovery room], IIF( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED).Count = 1, STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED), [Organisation].[Main Unit Description].currentmember ) )
CELL PROPERTIES VALUE