locked
Suppress Null value in Detail Section RRS feed

  • Question

  • Title

    Value1

    Value2

    Value3

    Above is sample display of report.

    Value1,2,3 are in detail section,if value3 is null, how can suppress it,for value2 also can like that?

    Wednesday, June 29, 2011 2:09 AM

Answers

  • Create a formula and test for the null:

     

    If IS NOTNULL({your field}) then {your field} ...

     

    Or something like that...

    Don


    Don Williams
    • Proposed as answer by Amit Govil (MCC) Saturday, July 2, 2011 11:54 AM
    • Marked as answer by Leo Liu - MSFTModerator Tuesday, July 5, 2011 2:59 AM
    • Unmarked as answer by wwc5225 Tuesday, July 5, 2011 5:00 AM
    • Unproposed as answer by wwc5225 Tuesday, July 5, 2011 5:01 AM
    • Proposed as answer by SAPDon Friday, July 22, 2011 8:22 PM
    • Marked as answer by wwc5225 Saturday, July 23, 2011 1:42 AM
    Wednesday, June 29, 2011 2:30 PM

All replies

  • Create a formula and test for the null:

     

    If IS NOTNULL({your field}) then {your field} ...

     

    Or something like that...

    Don


    Don Williams
    • Proposed as answer by Amit Govil (MCC) Saturday, July 2, 2011 11:54 AM
    • Marked as answer by Leo Liu - MSFTModerator Tuesday, July 5, 2011 2:59 AM
    • Unmarked as answer by wwc5225 Tuesday, July 5, 2011 5:00 AM
    • Unproposed as answer by wwc5225 Tuesday, July 5, 2011 5:01 AM
    • Proposed as answer by SAPDon Friday, July 22, 2011 8:22 PM
    • Marked as answer by wwc5225 Saturday, July 23, 2011 1:42 AM
    Wednesday, June 29, 2011 2:30 PM
  • Can your suggest solution also make the detail section less space or make it short in heigt, or need other solution?

    For me not just about the value also for the display, if less value, less space need for display.

    Tuesday, July 5, 2011 5:04 AM
  • Your new question has nothing to do with your original post. Someone just asked the same thing, sample code is in the post.

    Please mark as answered.

    Don


    Don Williams
    Friday, July 22, 2011 8:24 PM