Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Monday, 18 April 2016

how to add summary column in oracle reports

Summary Column:
Summary columns are used for calculating summary information like sum, average etc,. on specific columns of a data group.  This column uses a set of predefined oracle aggregate functions. Summary columns are generally preceded by CS_ to distinguish them from other columns.

Ø Specific properties:
          - Function
          - Source
          - Reset At
          - Compute At
Ø Datatype depends on Source datatype.

Let us make sum of total salary

In the Data Model view that displays, click the summary column tool in the tool palette then click in an open area of the Data Model view to display the summary column as shown below

Double click on summary column you can find the properties and give below details as below
                    Name     : CS_SUM_SAL
                    Function : sum
                    Source    : sal  

Go to Layout Model add Text and field in main frame level as shown below

Select F_7 field and right click go to Property Inspector set below properties as shown below

            Name  :SUM_OF_SAL
            Source :CS_SUM_SAL

Now development part completed you can run the report

Goto >Programs > Run paper Layout (you can find as below report output)

Share this article :


  1. I have read your blog and I gathered some needful information from your blog. Keep update your blog. Awaiting for your next update.
    Php course in chennai

  2. Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging,

  3. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  4. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading ExcelR Digital Marketing Class In Pune topics of our time. share more
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

  5. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... cfa summary notes

  6. I cant getting to work on centering long sufficient to explore; parcels less compose this blushing of article. Youve outshone your self as fast as this material truely. it's miles quite possibly of the best happy. Facebook Hack Software

  7. Sunday is a time when you sit back and reflect on all the blessings that you have received. Smile at all the good things that you are enjoying. Inspirational Sunday Morning Blessings