May 14, 2014 at 12:01 am
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy