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)

What is the primary purpose of using a Solution in Microsoft Power Platform & ALM?

As organizations embrace low-code development with Microsoft Power Platform , it becomes essential to manage and govern apps, flows, and dat...