Solved

SSRS Report Layout

Posted on 2014-09-17
3
246 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

707 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