| Alternate background color [message #390756] |
Mon, 09 March 2009 11:15  |
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  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Something like this?
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:
Basically, that should be all.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
