?
Solved

Padding for tables in report ignored

Posted on 2008-06-18
6
Medium Priority
?
2,208 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
[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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

719 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