Solved

SSRS Report Layout

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows Process running 3 48
From Excel how can I import data from SSRS Reporting Services ? 6 63
windbg taking it's time 32 79
Best 3rd party SQL Dashboard Reporting Tool? 4 46
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…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now