Solved

Oracle Report formatting

Posted on 2009-04-13
6
437 Views
Last Modified: 2013-12-07
hi

how can i make oracle report with alternate color background , so the first record  background will be white , the secod gray , the third white and so on ,,
something like web tables....

thank u
0
Comment
Question by:mohammedf
  • 3
6 Comments
 
LVL 2

Expert Comment

by:mi1400
ID: 24236254
put gray and white shapes both same sized inside frame but in background of labels and return true in conditional formatting. when rownum is even make white return true when rownum is odd make  grey shape return true. u can do this without shapes there is method to change back color of frame conditionally. thing is u have to play with rownum and backcolor.
0
 
LVL 2

Accepted Solution

by:
mi1400 earned 500 total points
ID: 24240657
once two overlapping white/grey shapes/labels are paced inside frame u need like following code. Infact u need only one shape/label i.e. grey one getting visible on odd or even row. since report page color is white u dont need to create white shape/label.

        FUNCTION B_ZeroFormatTrigger RETURN BOOLEAN IS
        BEGIN
                IF :CS_1 = 0 OR :CS_1 IS NULL
                THEN RETURN (TRUE);
                ELSE
                         RETURN (FALSE);
                END IF;
        END;
0
 
LVL 2

Expert Comment

by:mi1400
ID: 24466839
my given solution is proven solution on Internet widely. user is not honoring the help. Please help in points. Thank you.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question