Alternate background color [message #390756] |
Mon, 09 March 2009 11:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Something like this?
![/forum/fa/5871/0/](/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/](/forum/fa/5872/0/)
Basically, that should be all.
|
|
|
|