Thursday, February 9, 2012

adding additional Blank lines to a report

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
Eric Cathell wrote:
> 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.

No comments:

Post a Comment