Controlling Vertical Spacing in Table/Report

Developers,
I'm VERY new to MRS and I'm trying to format a report. I have a Header,
Detail, and Footer. In the Detail section, I have a table containing my
report items. Each cell contains variable(s).
Well, I have an address, and I want the Verticle Spacing between the lines
to be less than it currently is. I've been collapsing the table so that the
cells are so small I can't even read my variable names. This seems to work,
but I'm wondering:
Q. Is there a more graceful way to reduce the vertical spacing in my
table/report?
Please write soon! Thanks!!I dont think there is any. The only other thing you can try if making
the top and bottom padding 0.

Control w/hidden=true displays as white space

We have a section of a report that should only be displayed if we have data
for it. We have tried putting all of the controls in a rectangle, and then
setting the visibility based on the record count. If we have zero (0) rows,
the controls are hidden, but white space is now displayed equal to the
height of the rectangle that is hidden.
We have tried moving these controls to a sub-report and we exerience the
same thing. However much vertical space the sub-report control consumes at
design time is replaced with whitespace when we hide the report. While this
is a bit better since the height of the sub-report control can be much
smaller than the report itself, it is still frustrating.
Example:
Rec A
Rec B
Rec C
When we hide Rec B, we see:
Rec A
Rec C
What we want is:
Rec A
Rec C
It seems when we hide textboxes, they do not consume any vertical space.
1) How can we also remove the white space when hiding a rectangle or
sub-report?
2) Out of curiosity, what is the rational behind this behavior? Why would
one hide a control and not want subsequent controls "moved up" to take the
hidden controls place.
SQL Server 2000 SP4
MS Reporting Services 1.0 SP2
Visual Studio.NET 2003
Thanks,
Chris?
"Chris Walls" <chwalls@.community.nospam> wrote in message
news:e2jC%23$nMGHA.3648@.TK2MSFTNGP10.phx.gbl...
> We have a section of a report that should only be displayed if we have
> data for it. We have tried putting all of the controls in a rectangle,
> and then setting the visibility based on the record count. If we have
> zero (0) rows, the controls are hidden, but white space is now displayed
> equal to the height of the rectangle that is hidden.
> We have tried moving these controls to a sub-report and we exerience the
> same thing. However much vertical space the sub-report control consumes
> at design time is replaced with whitespace when we hide the report. While
> this is a bit better since the height of the sub-report control can be
> much smaller than the report itself, it is still frustrating.
> Example:
> Rec A
> Rec B
> Rec C
> When we hide Rec B, we see:
> Rec A
> Rec C
> What we want is:
> Rec A
> Rec C
> It seems when we hide textboxes, they do not consume any vertical space.
> 1) How can we also remove the white space when hiding a rectangle or
> sub-report?
> 2) Out of curiosity, what is the rational behind this behavior? Why would
> one hide a control and not want subsequent controls "moved up" to take the
> hidden controls place.
> SQL Server 2000 SP4
> MS Reporting Services 1.0 SP2
> Visual Studio.NET 2003
>
> Thanks,
> Chris
>|||Have you tried using a table instead of independent text boxes to
display your results? If you hide the entire row (not just a single
cell) then the row below moves up.|||Hi Chris (I'm sorry to bother you but I think you could help me)
The reason I'm sending you this email is that I did find a question (see
below) which you did post in this newsgroup for almost a year ago which
indicates that you already have went through the same problem situation as
I'm right now.
May I ask which product you are using when you are merging your PDF
documents into one single document? Are you happy with your choice?
Many thanks and best regards
/Anders
To get around a MS Reporting Service limitation, instead of using
sub-reports, we may have to create individual reports in PDF format and then
merge them into a single PDF report. We have found tools that can merge PDF
files, but this presents us with another issue: page numbers. We want the
resulting merged PDF files to have continous page numbers. Is there a way
to tell MS Reporting Services to start with a specific page number when
rendering a report. Can we some how do this with a report parameter?
"Chris Walls" <chwalls@.community.nospam> wrote in message
news:e2jC%23$nMGHA.3648@.TK2MSFTNGP10.phx.gbl...
> We have a section of a report that should only be displayed if we have
> data for it. We have tried putting all of the controls in a rectangle,
> and then setting the visibility based on the record count. If we have
> zero (0) rows, the controls are hidden, but white space is now displayed
> equal to the height of the rectangle that is hidden.
> We have tried moving these controls to a sub-report and we exerience the
> same thing. However much vertical space the sub-report control consumes
> at design time is replaced with whitespace when we hide the report. While
> this is a bit better since the height of the sub-report control can be
> much smaller than the report itself, it is still frustrating.
> Example:
> Rec A
> Rec B
> Rec C
> When we hide Rec B, we see:
> Rec A
> Rec C
> What we want is:
> Rec A
> Rec C
> It seems when we hide textboxes, they do not consume any vertical space.
> 1) How can we also remove the white space when hiding a rectangle or
> sub-report?
> 2) Out of curiosity, what is the rational behind this behavior? Why would
> one hide a control and not want subsequent controls "moved up" to take the
> hidden controls place.
> SQL Server 2000 SP4
> MS Reporting Services 1.0 SP2
> Visual Studio.NET 2003
>
> Thanks,
> Chris
>