Solved

Padding for tables in report ignored

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
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…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

752 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