Report Designer : No Fields Being Refreshed After Parameter Added...

I'm relatively new to Report Designer in VS 2005 and have been trying to get a parameterised report working.

I have an MDX query that works with the datasource I set up, but as soon as I try to add a parameter, the fields disappear from the dataset.

Here's the query:




Code Snippet
SELECT

NON EMPTY { [Measures].[Var Rc] }



ON COLUMNS,
NON EMPTY { ([Time].[Year - Quarter - Month - Date].[Date].ALLMEMBERS *



[Company Master].[Region].[Region].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM

( SELECT ( Filter( [Company Master].[Region].[All].Children,



Instr( [Company Master].[Region].Currentmember.Properties( 'Member_Caption' ), @RegionParam ) > 0) )
ON COLUMNS FROM [Supplier Spend])
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS



This is all a generated query apart from the filter. If I change the @RegionParam back to its old constant value (which was 'Europe') then the fields appear again. I've set up the Query Parameters to cope with @RegionParam and also put a Report Parameter in the Layout page that uses it.

I'm lost as to why the fields don't appear with the parameter in there...

Rob