Menu
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.
286
You can do this by clicking on the row number on the left side of the screen. Or, you can click on the first cell in the row and then press the Shift key and the down arrow key to select the entire row. Once the row is selected, right-click on it and select "Insert" from the menu that appears.
Right-click a row handle where you want to insert a row, click Insert Row, and then click Above or Below. Right-click a cell in the data region where you want to insert a row, click Insert Row, and then click Above or Below.
In Report Builder, the tablix data region is a generalized layout report item that displays paginated report data in cells that are organized into rows and columns. Report data can be detail data as it is retrieved from the data source, or aggregated detail data organized into groups that you specify.
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!
109
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
