Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Padding for tables in report ignored

Posted on 2008-06-18
6
Medium Priority
?
2,264 Views
Last Modified: 2008-06-19
Hi.

I'm experiencing a frustrating problem with SSRS.

I have a SSRS report with several tables, each one butting up one on
top of the other with no white space between them in the designer.
Most of these tables have an expression for their Visibility property
that determines whether the text and data within the table is shown
when the report renders.  This is to create a report with sometimes-
there-sometimes-not data elements.  This part works fine.

The problem is my settings for the tables' Padding properties are
being ignored.  I can set the Bottom Padding for a table to 100pt and
when the report renders, there's no padding; it's like it's ignored
completely.  I can set a table to page break, that's working, but I
can't add padding to make the report look better.

Please advise and thanks.
0
Comment
Question by:query_squidier
  • 3
  • 2
6 Comments
 
LVL 21

Expert Comment

by:Yurich
ID: 21819396
Try putting your tables into rectangles and toggling visibility of the rectangles. You can have a rectangle bigger than a table, but it will not render if it's not visible. May work just fine; I can't check it any earlier than tomorrow morning (that's about in 15-16 hours here).

Cheers,
Yurich
0
 

Author Comment

by:query_squidier
ID: 21827873
I created a rectangle and dropped one of the tables into it.  I made the width of the rectangle the same as the table but added some whtie space at the bottom of the rectangle until the rectangle butts up against the top of the next table.

I played with the visibility of the rectangle and, while setting its Hidden property to True does indeed cause the rectangle and its contained table not to be rendered, the space for the rectangle is still taken.  So the report ends up with a big blank spot where the rectangle and table would've been.

Any ideas?
0
 
LVL 21

Expert Comment

by:Yurich
ID: 21827920
:(,

I'll create a test report and see if I can figure out something...
0
 
LVL 21

Accepted Solution

by:
Yurich earned 2000 total points
ID: 21828099
OK :) figured out.

Drop a table on your report. Remove details and footer of this table and leave only the header. Add enough rows to your header to have one for each of your tables. Drop your tables INTO the header rows of the table you just created (each table into a separate row). You then can set visibility of the rows of this table. The gap between tables can be set with the footer of your inner tables and when they're not visible, you won't have then taking any space up. Ant that's exactly what you want.

There is a chance of having it done without an outer table, but just with manipulating extra rows in footer, but I didn't check that as the one above will work for sure and it's not very hard to do.

Good luck,
Yurich
0
 

Author Comment

by:query_squidier
ID: 21828155
That sounds nearly crazy enough to work.  I'll give it a go.  If it works I'll Accept the Solution.

Thanks for your effort, Yurich.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

885 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