Shading every other row in Oracle Reports (cont)
Date: 1995/10/08
Message-ID: <45bq66$gfm_at_flood.weeg.uiowa.edu>#1/1
I am still trying to figure out how to shade every other row in Oracle Reports. I have receieved many suggestions, and am very close (I think) to a solution. I have a format trigger on the repeating group I wish to affect. I have the SRW.ATTR.MASK portion all correct I believe, now I just need some method of counting what row I'm on, determining if that row is odd or even, and then format it accordingly. The problem is in accessing the number of records that have printed. It has been suggested that I try SELECT ROWNUM... which seems feasible, but now, gives me a runtime error that more that one row has been returned. I will post my format trigger below, perhaps someone can shed some light on this
function R_2FormatTrigger return boolean is
value NUMBER;
begin
SELECT ROWNUM into value from DETAIL;
if ((MOD(value, 2))=0) then
SRW.ATTR.MASK:= SRW.FILLPATT_ATTR +
SRW.FFCOLOR_ATTR + SRW.BFCOLOR_ATTR; SRW.ATTR.FBCOLOR:= 'WHITE'; SRW.ATTR.FFCOLOR:= 'GRAY20';
SRW.ATTR.FILLPATT:='GRAY16.6';
SRW.SET_ATTR(0, SRW.ATTR);
end if;
return (TRUE);
end;
This seems like it should be a relatively simple thing to do, and it would be quite useful for readability purposes. If anyone has had any success getting this to work, please fill me in. thanks Received on Sun Oct 08 1995 - 00:00:00 CET