Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 712
Jason Horner Avatar asked Aug 27 '09 14:08

Jason Horner


People also ask

How can you reorder the columns in the report?

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.

How do I move a column in report builder?

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.


1 Answers

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.

like image 175
jgallant Avatar answered Sep 20 '22 16:09

jgallant