Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Trybbe
Starting Member
27 Posts |
 Posted - 2009-07-22 : 05:23:16
|
| Hi GuysIs 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 |
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-07-27 : 09:00:28
|
| it is better to give the selected parameter back to the query/procedure and let it filter out the right values and then return them to the report. the report can use filter on the dataset but it is slow. (I hope i understood what you needed correctly) |
 |
|
|
Trybbe
Starting Member
27 Posts |
Posted - 2009-07-27 : 09:21:58
|
| Thanks for the feedback. I managed to put it into stored procedure |
|
|
|
|
|
|
Dynamic Row fields in a Matrix