I would create a table variable, insert the data into it, then read the
table, counting record. Insert this data into a new table, adding a value
that you can increment for each page. Read the second table into the report,
and use the incremented value as a group, select new page on new group.
Goos Luck
--
Bill Reynolds
[quoted text, click to view] "JeffreyWowk" wrote:
> OK I’m making a form where I need to limit the amount of info on the first
> page and push the rest onto the next page. I have a table in the middle of
> the first page that I can’t allow to grow past a certain number of lines
> (16), or the table will expand and push other things off the first page,
> which need to stay where they are. So I would like to put what I can on the
> first page and the rest on the next page. The hard part is that the data can
> be multi-lined.
>
> So the columns are:
>
> Col1 col2 col3 col4
> Quantity Unit Description Unit Price
> Int varchar(short) ntext float
>
> Only the Description column will be able to expand to a multi-line
>
> So I looking for some ideas for putting as many items into a table that I’d
> like to keep limited to say 16 line(or rows) then pushing what left of the
> dataset onto the next page
>
> Let me know if I’m no being clear enough
>
> Jeff