OraFAQ Forum: Reports & Discoverer » Highlight alternative rows with green shade on report

Home » Developer & Programmer » Reports & Discoverer » Highlight alternative rows with green shade on report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Highlight alternative rows with green shade on report [message #88949]

Fri, 04 July 2003 01:59

NTT
Messages: 3
Registered: November 2002

Junior Member

I want to highlight alternative rows printed on the report with a green shade so that it makes it easier to read. For example, there are 100 rows printed, and I want to highlight row 2, 4, 6, and so on with a green shade. Each row on the report is based on a key field REVENUE SOURCE ID.

Is there anyone out there know how to do this. Any idea on how to start with?

Thanks.

Report message to a moderator

Re: Highlight alternative rows with green shade on report [message #88950 is a reply to message #88949]

Mon, 07 July 2003 01:33

sujit
Messages: 94
Registered: April 2002

Member

Hi,
You can do this by format trigger. Hope this helps.

function F_noFormatTrigger return boolean is
begin

if round(:rownum/2) = :rownum/2 then --rownum fetched from query
srw.set_text_color('green');
end if;

return (TRUE);
end;

Report message to a moderator

Re: Highlight alternative rows with green shade on report [message #88957 is a reply to message #88950]

Mon, 07 July 2003 12:21

NTT
Messages: 3
Registered: November 2002

Junior Member

Thanks. I'll give a try.

Report message to a moderator

Re: Highlight alternative rows with green shade on report [message #88973 is a reply to message #88957]

Sun, 13 July 2003 10:14

shareef
Messages: 72
Registered: November 2002

Member

as sujit said, it is write, but i think it is better way try this

begin

if mod(:rownum,2) = 0 then
srw.set_text_color('green');
end if;
end;

hope this help

shareef

Report message to a moderator

Previous Topic:	how to print a newline character on report?
Next Topic:	Urgent Pls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 21:27:56 CST 2024