Hide Data Region based on Parameters

I have a report with 3 data regions. Based upon one of the Report Parms, I
wish to hide one of the data regions. I used an expression on the
Visibility property of the table like this:
=IIf(Parameters!ReportLevel.Value = "Summary",true,false)
this works, except it still displays the page header and no print details
since the report is hidden. how do i get it to not display the page at all?Hi JrMcG,
Thank you for your posting!
I am not sure why you want to hide the Page Header. Since you only hide the
table, the Page header will not be hidden untill you use the same
expression on the Page Header visibility.
I recommend you post the RDL file here with your requirement. I would like
to help you. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

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