Re: on-break processing

[Don Mellen <donm@ONTKO.COM>]

On Mon, 8 Jan 2001, Fiona Darroch wrote:

> I have the select statement (below) with 2 break levels. What I am trying to
> achieve is a report wherein the string:    'Transfer Credits logged out to:
> ' is printed prior to the value of break level 1 and the string: 'Program:
> ' is printed prior to the value of break level 2.
<snip>
> I have also tried concatenating the string and variable values for each
> level and doing the break on those concatenated values, but that doesn't
> give the desired output either.

Fiona,

Have you tried something like the following...?

begin-procedure Main
begin-select DISTINCT
'Transfer Credits logged out to:  ' || B.SQS_DESTINATION (,1) on-break
  level=1 print=change/top-page before=Break1-Before
'Program:           ' || A.ACAD_PROG (,1) on-break level=2 skiplines=1
A.SQS_APPLICATION_ID (+1,2)
...

begin-procedure Break1-Before
  new-page
end-procedure

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"