Monday 30 January 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)
at

3 comments:

  1. Unknown28 June 2018 at 00:48

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

    ReplyDelete
  2. Unknown28 June 2018 at 02:48

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

    ReplyDelete

Subscribe to: Post Comments (Atom)

Adding a newline into a string in C# and X++

Below is the sample code we can use for  adding a newline after every occurrence of "@" symbol in the string in C#   using System...