[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