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

Skiplines in SQR 3.5



In the following select statement I am wanting to insert a blank row between
the data everytime the CREWID changes (before the change).  In the report
output, the blank line is coming after the first row of data containing the
new CREWID has been printed.  This "on-break  skiplines=1" command is in
accordance with instructions from page 22 of the version 4 SQR Users Guide,
but apparently it doesn't apply to version 3.5.  Can anyone tell me how to
get the blank line before CREWID changes?

Thanks

Bob




Begin-Select
CREWID                           (1,1,3)   on-break  skiplines=1
MAXIMO.WORKORDER.EQNUM           (1,5,9)
MAXIMO.EQUIPMENT.DESCRIPTION     (1,13,30)
WONUM                            (1,36,10)
To_Char(REPORTDATE,'MM/DD/YY') &REPORTDATE (1,44)
LEADCRAFT                        (1,51,4)
MAXIMO.WORKORDER.DESCRIPTION     (1,58,30)
WORKTYPE                         (1,90,5)
 Next-Listing  Need=1
>From  MAXIMO.EQUIPMENT, MAXIMO.WORKORDER
Where MAXIMO.EQUIPMENT.EQNUM = MAXIMO.WORKORDER.EQNUM
 AND  MAXIMO.WORKORDER.WOEQ5 = 'Y'
 AND  MAXIMO.WORKORDER.STATUS = 'APPR'
 AND  MAXIMO.WORKORDER.WORKTYPE IN ('EC', 'EM', 'ES', 'CM')
Order By MAXIMO.WORKORDER.CREWID,
         MAXIMO.WORKORDER.WONUM
End-Select