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
>