Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Modifying format mask after 1st line (Oracle Reports 6)

Status
Not open for further replies.

c15bm

Programmer
May 29, 2003
10
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top