Sadly, no. I wish it could be something that simple. First, if I make the
body height something like 10" and leave most of that space un-occupied by
report objects (no lines, textboxes, etc.) when the report is rendered it
"throws away" the empty space.
Since what I want is a empty grid of horizontal and vertical lines. If I
make the body 10" tall and put a sufficient lines to present a full page of
empty rows, when the data populates the page it pushes these objects onto the
next page and I end up with a grid on the last page that only occupies the
upper part of the page.
[quoted text, click to view] "Douglas J. Badin" wrote:
> Does setting the Body Height to 10" help?
>
> Doug
>
> "Ken" <Ken@discussions.microsoft.com> wrote in message
> news:462EFE5D-7CE5-4960-ADED-8BDF03C1EDF1@microsoft.com...
> > I'm producing a report that will generate 1 or more pages. Each page
> should
> > have the appearance of a full page of empty grid rows (approximately 20
> per
> > page), even if only 5 rows contain data. My layout will accomodate 20
> rows
> > of data per page and each page looks good as long as my row count is
> evenly
> > divisable by 20. If I run the report for 25 rows of data, I get a full
> page
> > and the second page only prints as much of the grid as needed to present
> the
> > remaining 5 rows.
> >
> > My obvious solution seems to be to determine the number of rows that will
> > qualify for printing first, then union the result set with an dummy SELECT
> > that produces sufficient blank / empty data to fill in the rest of the
> page.
> >
> > Is there a more elegant solution within the report writer that I can
> utilize
> > for this?
>
>
