Expression help

i have a dropdownlist(it is filled with cities) as parameterin my report
i have matrix and table in my report
matrix shows data for all cities
Table shows data for one city
i want to write exprssion or custom code to hide table or matrix.
when user selects ALL in dropdown list then i want to show MATRIX
else i want to show table
can some one tell me how to do this in reporting services
ThanksEach RS region has Visibility property (on the Visibility tab) which can be
expression-based, e.g. =Iif(Parameters!City.Value='All', True, False).
Please note though that hiding a region doesn't reclaim the space occupied
by the region, nor does prevent executing of the dataset query bound to the
region.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"repalley" <repalley@.discussions.microsoft.com> wrote in message
news:FC61C985-0FF1-4AD2-9AFA-A1932A89980A@.microsoft.com...
> i have a dropdownlist(it is filled with cities) as parameterin my report
> i have matrix and table in my report
> matrix shows data for all cities
> Table shows data for one city
> i want to write exprssion or custom code to hide table or matrix.
> when user selects ALL in dropdown list then i want to show MATRIX
> else i want to show table
> can some one tell me how to do this in reporting services
> Thanks|||Thanks for info
"Teo Lachev [MVP]" wrote:
> Each RS region has Visibility property (on the Visibility tab) which can be
> expression-based, e.g. =Iif(Parameters!City.Value='All', True, False).
> Please note though that hiding a region doesn't reclaim the space occupied
> by the region, nor does prevent executing of the dataset query bound to the
> region.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "repalley" <repalley@.discussions.microsoft.com> wrote in message
> news:FC61C985-0FF1-4AD2-9AFA-A1932A89980A@.microsoft.com...
> > i have a dropdownlist(it is filled with cities) as parameterin my report
> > i have matrix and table in my report
> > matrix shows data for all cities
> > Table shows data for one city
> > i want to write exprssion or custom code to hide table or matrix.
> >
> > when user selects ALL in dropdown list then i want to show MATRIX
> >
> > else i want to show table
> >
> > can some one tell me how to do this in reporting services
> >
> > Thanks
>
>