sql server reporting services: Is it possible to move rows in a matrix up and down from its original
position? Preferably in a drag n drop structure.

Everytime I add a new field to a matrix I need to do manually change the
field names in the text box in the position I need the new field name.

Thanks.

Do you have list of fields,you want to see on the matrix
I mean when you are saying i am adding new field ,i feel you cant get
additonal column unless you add in the table or stored procedure you
have to compile
So by assuming you have the list of filed names before you run the
report,
1)have a parametre,in that go to Non -Queried values,give the field
name desc in drop down
2)in place of column header ,give expression like
iif(parametre=1,"Desc",IIF(param=2,"Desc2","desc3)))
3)In detailcell
iif(parametre=1,"Fields!Desc.Value",IIF(param=2,"Fields!Desc2","Fields!desc3.value)))

Regards
Raj Deep.A

[quoted text, click to view]