Home » Developer & Programmer » Reports & Discoverer » Alternate background color (Report 6i)
Alternate background color [message #390756] Mon, 09 March 2009 11:15 Go to next message
aruns1975
Messages: 3
Registered: March 2009
Location: Chennai
Junior Member
Hi,

May be a simple question. I need to display different color to alternate lines in the details section of my report. Can anyone tells me how to do it.

With Regards
S.Arun
Re: Alternate background color [message #390768 is a reply to message #390756] Mon, 09 March 2009 12:11 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Something like this?

/forum/fa/5871/0/

If so, here you are (sample report based on Scott's schema): create a query which - along with useful columns - contains one that will distinguish alternate rows. For this purpose, we'll use ROWNUM:
SQL> select mod(rownum, 2) rn, deptno, dname, loc
  2  from dept
  3  order by deptno;

        RN     DEPTNO DNAME          LOC
---------- ---------- -------------- --------------------
         1         10 ACCOUNTING     New York
         0         20 RESEARCH       DALLAS
         1         30 SALES          CHICAGO
         0         40 OPERATIONS     BOSTON

SQL>

Let Wizard create report layout; select the repeating frame, open its property palette, go to the "General Layout" section and open "Conditional Formatting". Set the desired color and apply changes:

/forum/fa/5872/0/

Basically, that should be all.

Re: Alternate background color [message #391221 is a reply to message #390768] Wed, 11 March 2009 08:31 Go to previous message
aruns1975
Messages: 3
Registered: March 2009
Location: Chennai
Junior Member
That works fine now. Thank you
Previous Topic: Can I call oracle package in report to populate some fields
Next Topic: Color palette
Goto Forum:
  


Current Time: Thu Mar 28 04:08:54 CDT 2024