I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!).
It seems like it should be easy to re-arrange the columns (move column 3 to column 1, swap columns 4 & 5 etc.). But, drag and drop does not seem to work and the only solution seems to be deleting the original column and re-inserting it in the correct place (and re-applying any expressions & formatting already created for the column).
Is there any easier way of doing this? Please note that I don't want a programmatic solution, but just need to change it once in design mode.
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.
Go into the properties of your table (right-click, properties) and set the Sort property to be by completionDate in Ascending order. You can also Sort each group if you need to.
Open the report design in VS, Select from the top menu Report -> Report properties and then under Page setup, select Orientation as Landscape.
There is a way to move columns through the designer:
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