Can you reorder columns in Report designer (bids 2005)
I have a reporting service report and I can't seem to figure out how to reorder the columns in the table control. Is this possible with editing the rdl file directly?
Answer
You can highlight a column (make sure to hightlight the entire column) then rightclick->CUT. Then highlight another column and rightclick->PASTE. The column will paste itself to the left of the column you had highlighted.
This is the quickest way to re-order a column.
Instructions for Visual Studio 2010 SP1:
In order to get the "Cut/Copy/Paste options to show up, you must highlight the header and detail row of the column by first clicking in the header row, then shift-clicking in the detail row. This will give you a grey outline around both. If you have the grey empty box at the top highlighted, then the cut will not work.
You will also need to pre-insert a column before pasting, and delete the blank column after pasting.