Solved

Padding for tables in report ignored

Posted on 2008-06-18
6
2,021 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

803 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