I have an invoice report that I've done some major cosmetic changes to. Another request that has come up is to have the "$" appear on the first line of Charge_Types but not on subsequent lines. They'd like this to be repeated for the charge_type details as well.
I'm having a problem checking for the "first" line printed so I can change the format mask of the field.
I've tried this in the format_trigger of the dollar field
in question.
first_time number(5);
begin
DECLARE
BEGIN
if first_time is null then
srw.attr.mask := SRW.FORMATMASK_ATTR;
srw.attr.formatmask := '($NNN,NNN,NN0.00)';
srw.set_attr (0, srw.attr);
else
srw.attr.mask := SRW.FORMATMASK_ATTR;
srw.attr.formatmask := '(NNN,NNN,NN0.00)';
srw.set_attr (0, srw.attr);
end if;
first_time := first_time + 1;
RETURN (0);
end;
end;
Doesn't work.
I'm having a problem checking for the "first" line printed so I can change the format mask of the field.
I've tried this in the format_trigger of the dollar field
in question.
first_time number(5);
begin
DECLARE
BEGIN
if first_time is null then
srw.attr.mask := SRW.FORMATMASK_ATTR;
srw.attr.formatmask := '($NNN,NNN,NN0.00)';
srw.set_attr (0, srw.attr);
else
srw.attr.mask := SRW.FORMATMASK_ATTR;
srw.attr.formatmask := '(NNN,NNN,NN0.00)';
srw.set_attr (0, srw.attr);
end if;
first_time := first_time + 1;
RETURN (0);
end;
end;
Doesn't work.