[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Breaking 'like' text



Scott,
        Next-listing is the command you will use to accomplish this, but you
will also need to use arrays.  Because you don't know at the time of issuing
the next-listing command how many lines there will be, you will need to put
them in an array as you retrieve them, and then print them with the array
index in the need= parameter of next-listing.  You may be able to accomplish
this by breaking apart the query and doing counts before selecting the
records instead, but this would not perform as well.  Happy coding.

Mark Johnson
Context Integration


At 09:50 PM 2/12/97 -0500, you wrote:
>I am writing a SQR which reports employees by department and causes a page
>break when deptartment changes.  This works fine, but the problem is that
>each employee has multiple lines and sometimes a page-break is caused when
>only a few of the employee's lines are printed.
>
>i.e.
>
>emplid01   xxxx xxxx  xxx
>                xxxx xxxx xxx xxx
>                xxxx xxxx xxx xxx
>                xxx xxx xxx xxx
>
>emplid02   xxx xxx xxx xxx
>--- page break ---
>               xxx xxx xxx xxx
>
>emplid03  xx xxx xxx xxx
>               xxx xxx xxx xxx
>               xxx xxx xxx xxx
>
>etc.
>
>
>Is there a simple way to keep these lines together so that emplid02
>willstart on a new page?  The number of lines of information for each
>employee may differ.
>
>Thanks in advance
>
>     --_ Scott _--
>
>