Search code examples
visual-studio-2005reporting-servicesrdlbids

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?


Solution

  • 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.