sql server reporting services: I am trying to add additional blank lines to a report based on how much room
is left on a page. If there are 6 lines of datarows, I need there to be 15
lines of blank lines. if there are 15 lines of datarows I need 6 blank lines
added.

I am currenly using a table object with a static number of header rows with
the bottom lined. Any suggestions would be appreciated.

Eric,

I had this problem as well. What I did or would do in your case is add
20 rows of footers after your detail row. On the first footer set the
visibility of the row = IIF(rownumber<20, false, true). This will
always show this row if less than 20 rows in the dataset are returned.
On the next footer set the visibiitly = IIF(rownumber<19, false, true).
do this to the remaining 18 footers incrementing rownumber by -1 in
each case. THat should work. Let me know if it doesn't

Melissa

[quoted text, click to view]