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
>
>