Dynamic Rows in Matrix SSRS 2005

[Trybbe]

Hi Guys

Is it possible to have the values of a matrix row change based on parameter values? Where your default value would be all regions but when a user select a particular region you display all areas under that region.

I wrote something like this on the expression area of the matrix row but it's not working:

=iif(Parameters!Region.Value = "ALL Regions", Fields!Region.Value, Fields!Area.Value)

"ALL regions" is catered for in the query.

Please help

 

[bborissov]

For what DB you want to use this
I ask because this is NOT a syntax for SQL Server.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Trybbe]

Sorry for not being specific, that's for SQL Server Reporting Services 2005

 

[bborissov]

...
CASE WHEN Parameters!Region.Value = "ALL Regions"
          THEN Fields!Region.Value
     ELSE Fields!Area.Value END

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.