Post reply

How to get NONE if no rows are returned in a report

  • May 14, 2014 at 12:01 am

    #307941

    How can I get None in each cell of a table in the report if no rows are returned? If I use "No rows message" property, header is not displaying on the report but I would like to get headers along with "NONE" in each column if no rows returned

  • May 14, 2014 at 12:20 am

    #1713318

    You add a row to your table with all of the columns set to NONE. Make sure it is outside the group of the detail rows.

    Then set the visibility of the row with the following expression:

    iif(CountRows() = 0, True, False)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 14, 2014 at 9:42 am

    #1713532

    Koen,

    That worked. Thanks for you help! Like you said I used =iif(CountRows() = 0, False, True) expression for Hidden Property.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply