Solved

SSRS Report Layout

Posted on 2014-09-17
3
237 Views
Last Modified: 2014-09-22
Hi,

Is it possible to expand a table to the bottom of the report page? I have two tables side by side and would like them to have different colour backgrounds. But the problem is that the colour only goes to  the end of the table, which is depends on the data rows and not to the end of the page. I have tried putting the tables inside a rectangle and setting the backcolour of the rectangle but this does not work as the rectangle size increases as the table increase...

so the reports end ups looking like this:

picture 1
But I would like it to look like this:

picture 2
Thanks, Greg
0
Comment
Question by:spen_lang
  • 2
3 Comments
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40328542
If the blue one is always longer, you can create a red rectangle and put the both tablixes into it - the rectangle will be as long as the longest one and the blue tablix will cover the red background in its "column".
0
 

Author Comment

by:spen_lang
ID: 40329773
Sorry, in my actual report I have 5 columns, but to illustrate it I only showed 2. Any of the columns could be the longest. Surely there must be a way in SSRS to fix the size of a rectangle, i just cant find out how.
0
 
LVL 13

Accepted Solution

by:
Russell Fox earned 500 total points
ID: 40330864
Unfortunately, the Height property can't be set dynamically, and because the elements are separate the CanGrow property will not have an effect between the columns. However, I think I have a solution that involves embedding the column/tables into a new, blank table:

1. Add a new Table object to the report with no data source.

2. Delete the details row, click Yes when is asks to you if you want to delete the associated group.

3. Add as many columns as you need, select each column separately and add the appropriate background color to the entire column.

4. You should only have the header row left: set the row height equal to the table height for the column tables, and set the width equal to the table width.

5. Drag and drop each column/table into the appropriate cell in the header row.

Now when you run the report, the container will grow to the size of the largest sub-table, and the background color will continue to the bottom for each column.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question