SQL Server Performance Forum – Threads Archive

Blank row

I am creating a users report which displays 3 different address lines. most users will not have anything for Address2 or Address 3. I want to know how i can suppress these rows if there is no data to display for them. How would i do that?

---

Highlight the entire line you want suppressed. In the Properties pane, find the "Visibility–>Hidden" property and select "<Expression…>" from the drop-down. In the expression, put in the following making sure you put in the proper field name: =IIF( Fields!Address2.Value = "", True,False) Now, IF you are in a table (or probably Matrix), and IF you have selected the whole row (not just a single cell), the report will collapse down to the visible cells. If, however, you are placing your data in a textbox, the textbox will just go away.

---

]]>