Hide blank pages

Hi,
Can someone help me identifying a way to hide blank pages in Reporting
services 2000.
Thanks.On Mar 2, 11:15 am, Helpseeker <Helpsee...@.discussions.microsoft.com>
wrote:
> Hi,
> Can someone help me identifying a way to hide blank pages in Reporting
> services 2000.
> Thanks.
Do you mean when you export data? Please explain.
Enrique Martinez
Sr. SQL Server Developer|||In a report I am displaying data using table. And I am hiding the data using
some expression. What is happening is the table is hiding the data...but for
the records its hiding it is showing them as blank in blank pages following.
Like if there is data shown in first 3 pages... but actual data spans 10
pages...the remaining 7 pages are shown blank ('coz i am hiding it). Hope you
understand.
Bmanchi.
"EMartinez" wrote:
> On Mar 2, 11:15 am, Helpseeker <Helpsee...@.discussions.microsoft.com>
> wrote:
> > Hi,
> >
> > Can someone help me identifying a way to hide blank pages in Reporting
> > services 2000.
> >
> > Thanks.
>
> Do you mean when you export data? Please explain.
> Enrique Martinez
> Sr. SQL Server Developer
>

Hidding region of a report

Hi,
i have a report with 5 regions. and when all those regions are filled may
report stand on 2 pages. my Pb is that event if the region are empty, the
space use by each region do not desapear.
Is it possible to hide a data region with no row ?
i wnat my report to apear on 1 page when all the data region are not filled .
Think you for your answer.
Kind RegardsDid you look into Hidden property of a report item? You can conditionally
hide the data region based on its number of rows.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> Hi,
> i have a report with 5 regions. and when all those regions are filled may
> report stand on 2 pages. my Pb is that event if the region are empty, the
> space use by each region do not desapear.
> Is it possible to hide a data region with no row ?
> i wnat my report to apear on 1 page when all the data region are not
filled .
> Think you for your answer.
> Kind Regards|||thank you for you reply.
but when i use this expression in the visibility proprety of my data region
i get this message :
r:\samples\reports\Product Line Sales.rdl The hidden expression for the
table â'TopStoresTableâ' has the value â'Iif(CountRows() = 0, "false", "true")â',
which is not a valid Boolean value.
what can i do ?
thank you for help
"Nico Cristache [MSFT]" wrote:
> Did you look into Hidden property of a report item? You can conditionally
> hide the data region based on its number of rows.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
> in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> > Hi,
> > i have a report with 5 regions. and when all those regions are filled may
> > report stand on 2 pages. my Pb is that event if the region are empty, the
> > space use by each region do not desapear.
> >
> > Is it possible to hide a data region with no row ?
> >
> > i wnat my report to apear on 1 page when all the data region are not
> filled .
> >
> > Think you for your answer.
> >
> > Kind Regards
>
>|||i can now hide the data region with the expression CountRows().
But would like to move data region below to the place of the one hidden.
Is it possible to modify dynamically the position of my data region.
Regards.
"Nico Cristache [MSFT]" wrote:
> Did you look into Hidden property of a report item? You can conditionally
> hide the data region based on its number of rows.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
> in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> > Hi,
> > i have a report with 5 regions. and when all those regions are filled may
> > report stand on 2 pages. my Pb is that event if the region are empty, the
> > space use by each region do not desapear.
> >
> > Is it possible to hide a data region with no row ?
> >
> > i wnat my report to apear on 1 page when all the data region are not
> filled .
> >
> > Think you for your answer.
> >
> > Kind Regards
>
>

Help: Multiple sub-reports creating extra blank pages on print

I have a project with multiple pages of reports. I am using one main page with all the other reports added through the sub-report control. The only problem is, after the first page and a couple of the other pages, it inserts a blank page in the print preview. If I view and print the reports seperately, and not all on the main report page they print fine, they don't roll over, don't print any extra blank pages. This only occurs when I add all them all as sub-reports. The last 5 pages don't suffer from this problem either.

Can anyone think of what the problem could be, or a way to solve it? All the pages are 8.5x11 with no margins. As I said, the pages alone print fine without any extra blank pages, so I'm confused why they would create extra white pages when added as sub-reports. The other thing is, I thought that perhaps pages having text that go all the way to the bottom were causing the issue, but some of the reports don't have text that extend to the bottom, so that rules that out.

I'd really appreciate any help. Thanks in advance.

We have seen a similar problem before. Can you try making the subreport element in the main report wider (enough to contain the entire subreport) and see that helps?|||The sub elements are all 8.5 inch,.25inch. The main report is 8.5,11 as are all the other reports. I initially had just placed them on there and they were seperated by a grid space or so, and their heights were all different (widths all stayed constant at 8.5). When I did this, though, the formatting was even worse and some of the reports would run into eachother. I would try making the main report length the size of all the subreports * 11 but I have 21 pages of reports and the maximum length is 160 inches.

Right now my main report is setup with each sub report element set at 8.5,.25 and starting from the very top of the main report, they are placed one below the other right where the previous one ends.
|||Any MSFT people who can provide any help? :||||I'm sorry to bump this again, but I could really use some assistance. I've tried everything and I can't get it to work.|||Can you attach your rdls? That'd help us repro and investigate the problem.