all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Splitting text



Splitting text JeffreyWowk
10/13/2005 10:02:03 AM
sql server reporting services: 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
RE: Splitting text Bill Reynolds
12/1/2005 2:13:02 PM
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]
AddThis Social Bookmark Button