I have several SSRS reports to create for a client that need to have a table layout. I know that some people frown on using the Tablix only for this purpose, but trying to align rectangles and other controls is extremely time consuming.
Many of these tables have over 50 rows (with multiple columns) and I constantly need to perform the sequence "Right-Click >> Insert Row >> Below". This is extremely repetitive and I would like to know if anyone knows of a better way to accomplish the task.
I tried to find a similar question on SO, in addition to Googling a possible solution, but I was unable to locate someone with my exact question that had a solution.
One option I've tried was to create my own keyboard shortcut using the custom shortcuts in VS2008 options. There are four possible options that do not have a shortcut assigned:
Unfortunately, I my attempt to map either of the four commands was unsuccessful. If these are the commands, and someone has successfully accomplished what I am trying to do, please let me know. If these commands do not apply to the Tablix designer, does anyone else have a solution that works for them?
Edit: The main report on which I will be using this table only populates a couple textboxes at the top of the page. The table itself does not contain any data and is used to hold student's grades. The 50+ rows are categories that are graded and there are 12 columns representing the students in the class.
I agree with your basic approach - a table is a much easier way to control the layout.
To quickly copy rows, right click the report in the Solution Explorer and choose View Code. Find the TablixRow XML node in your table you want to copy, and then Copy and Paste it as many times as needed. Make sure you copy the entire node from start to end tag.
Tip - use the expand/collapse toggles on the left to collapse your source TablixRow XML node before you copy it - helps avoid copy errors.
Obviously make sure you have a backup of your report in case you screw this up!