Wednesday, January 28, 2015

SSRS - Show blank / Empty rows in Table

1.Insert a new rows in the table

2.Set the visibility using the following expression

=IIF(CountRows() < 1 = 0, true, false)

Note:
Similarly we can show multiple empty rows.
in my case ,i added 10 empty rows & set the row visibility using below expression

=IIF(CountRows() < 1 = 0, true, false) - first row
=IIF(CountRows() < 2 = 0, true, false) - 2nd row, etc..

No comments:

Post a Comment