Re: Reports 3.0 - referencing a summary column

From: claire marcoux <cmarcoux_at_webnet.qc.ca>
Date: Thu, 03 Dec 1998 15:09:44 GMT
Message-ID: <01be1ecf$6241de20$f3380dd8_at_clairema>

I dont know if it can help
[Quoted] But that's the way i learn it.

In your data model
In the table that you need a summary column Exemple:

            Q_Query
                |                           
           ______________ 


          |G_region      |


      1   |______________| 


          |cs_sumsal     | 


          |______________|


                |
           ________________    _____________


          |G_departement  |    |G_employe   |


      2   |_______________|    | ___________| 


          |cs_countsal    |____| id         |


          |_______________|    | Last_name  |


                               | total_charges    |
                               |____________| 

        In the propriety sheet
        You say Source    Total_charges
   1    datatype  number
        fonction  sum
        reset at g_region (for you it is invoice)

        And it is the same for count(total_charges)
        Source     total_charges
    2   datatype   number
        fonction   count
        reset at   g_departement

I am not sure But i dont think you can have 3 summary column in a formula.   

Good luck.
Claire  

Jagdish Rajan <jagdish_at_att.net.nospam> a écrit dans l'article <36662909.28783618_at_netnews.worldnet.att.net>...

> How do I reference a summary column (e.g. sum(total_charges) or
> count(total_charges)) from a PL/SQL block within Reports?  I have 3
> summary column which I would like to add together in a formula column.
> 
> Thanks.
> Jagdish.
> 

Received on Thu Dec 03 1998 - 16:09:44 CET