Re: QM Query to Break on Range of Days

Consider the following setup and the described approach, as a means to break on the categorized values versus thee specific number of days values:

create table qtemp/d
( account char(7), curbal dec(9, 2)
, dpd dec(3), totlate dec(7, 2) )
;
insert into qtemp/d values
('xxxxxx1', 1500, 21, 500 ) ,('xxxxxx2', 1200, 35, 300 )
, ('xxxxxx3', 750, 93, 100 ) ,('xxxxxx4', 200, 120, 25 )
;
create view qtemp/dv as
select
case when dpd between 1 and 90 then '<'
when dpd > 90 then '>' /* else NULL */
end DPDI
, d.*
from qtemp/d
;

Both Order and Break can be specified on the derived column DPDI which should help to achieve the desired report. The *HEX sort sequence has the less-than character collating before the greater-than character; probably others do as well. The break text can be set to, for example, "Total Loans &DPDI 90 days past due:". I do not recall if\how the QMFORM can be modified to effect suppression of the DPDI derived column; i.e. like the Query/400 reporting can using a column width of zero specified on the "Specify report column formatting".