Friday, February 24, 2012

List control visible

I want my list control only be visible if there is data. So, in my report I
have several list controls, one of the list controls shows alias data for a
customer. If the customer has no alias data then I don't want the alias list
control to show. In the alias list control I have several textboxes.
In the list properties, visibility tab, I set the expression to
"=IIf(Fields!IndAliasID.Value > 0, true, false)" but the list control always
shows, even if the IndAliasID is null or zero.Hello Mike,
Based on my test, I was not able to reproduce the issue. Please note when
the expression is =true, the list item is hidden. When it is =false, it is
shown. You may test to see if it make any difference
=IIf(Fields!IndAliasID.Value = 0 or Fields!IndAliasID.Value is nothing,
true, false)
Also, the visiblity is for the item of list. If there is any item in the
list are >0, the list shall be visible with the items.
If you have any update, please feel free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I figured it out on my own. This post is no longer required.
Thank you for responding.
"Peter Yang [MSFT]" wrote:
> Hello Mike,
> Based on my test, I was not able to reproduce the issue. Please note when
> the expression is =true, the list item is hidden. When it is =false, it is
> shown. You may test to see if it make any difference
> =IIf(Fields!IndAliasID.Value = 0 or Fields!IndAliasID.Value is nothing,
> true, false)
> Also, the visiblity is for the item of list. If there is any item in the
> list are >0, the list shall be visible with the items.
> If you have any update, please feel free to let's know. Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

No comments:

Post a Comment