I need to prevent blank rows from displaying in a report. The blank rows represent fields with null values, which appear in almost every record.
I have attached a simplified example with two columns. The left column contains labels and the right column contains text boxes. In this example, there are three blank rows. I would like to prevent these blank rows from displaying, and I would like the first three fields from the next record (not shown) to replace the blank rows.
In the Details Section and in text box properties, I have the Can Grow and Can Shrink properties set to Yes. I have tried a variety of solutions but nothing has worked (probably because I am not correctly applying the solutions!). I found and joined this forum today (9-20-11) and would appreciate your help.