Solved

SSRS Report Layout

Posted on 2014-09-17
3
235 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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…

777 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