Stop SSRS from removing blank lines from dataset in pdf

I have a dataset that creates a blank line, but when I display the dataset in a report in print preview, or attempt to export to pdf it automatically removes those blank lines.  How do I keep them?
Who is Participating?
planoczConnect With a Mentor Commented:
It sounds like on the blank line you are posting some kind  of output..
you can try someting like this in the textbox/ line area that you are looking for.

=IIF(trim(fields!mydata.value) = "" or trim(fields!mydata.value) = nothing, " ", fields!mydata.value)
ValentinoVConnect With a Mentor BI ConsultantCommented:
Do you mean that the fields displayed on the report are empty/null for some of the records?  As far as I can tell those lines shouldn't get removed from the table when rendered to PDF.

As a workaround, perhaps you can put something (anything) in one of the fields and give it the same color as the background?  That way it still appears blank and I hope it prevents SSRS from removing them.
UnderSevenAuthor Commented:
It wasn't blank, there was a field providing data the report was making blank.  So that's probably part of the confusion.  However, that left me with data I didn't want to display so I used the first response suggested workaround to just color it white.  Thanks to you both.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.