Monday, January 30, 2017

Hide Column if all Rows are empty in SSRS report - AX 2012

If there is a requirement to hide a column if all rows are empty. Use the below expression 

=IIF(Fields!ColumnSample.Value = Nothing, True, False)
-

3 comments:

  1. UnknownJune 28, 2018 at 12:48 AM

    this is not working in version 9.0 Dynamics 365
    is there any other syntax ??

    ReplyDelete
  2. UnknownJune 28, 2018 at 2:48 AM

    Use this instead
    =IIF(CountDistinct(Fields!fieldName.Value)=0, True,false)

    ReplyDelete

Subscribe to: Post Comments (Atom)

Why do users often get confused about Dynamics 365 Customer Engagement (D365 CE), Dataverse, and the Power Platform?

  The Microsoft ecosystem for business applications can sometimes be difficult to navigate, especially when discussing Dynamics 365 Customer...