April 2, 2014 at 8:06 am
I am working on a report that has a table with 8 rows. When the dataset is returned, I need for the table to always show 8 rows regardless even if the dataset is less than 8 rows. In my particular example, I have a dataset that returns only 2 rows. I set the visibility for the 3rd row:
=IIF(CountRows("SSC1") < 3, False, True)
This added a blank row in between the 2 returned dataset rows and after the last row. Any suggestions?
Thanks in advance.
April 2, 2014 at 9:12 am
The solution was:
=IIF((Count(Fields!Title.Value, "SSC1") < 1 AND RowNumber("SSC1") = 0) OR
(Count(Fields!Title.Value, "SSC1") < 2 AND RowNumber("SSC1") = 1) OR
(Count(Fields!Title.Value, "SSC1") < 3 AND RowNumber("SSC1") = 2), false, true)
This would make this row visible if the dataset returned less than 3 rows.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply