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?
Select your report from the navigation tree, and click the Report tab. Click and hold the column to drag it to the new position, then release the mouse button. That's it! The columns now appear in the new order.
You can cut and paste - click the column you want to move and cut with Control-X. Then select a different column and paste with Control-V. That will place the old column to the left of the selected column.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With