Re: Reports 3.0 - referencing a summary column

Thanks for the response, Claire.
However, I have several groupings at the same level, and therefore, cannot use the hierarchical use breaks groups as you have shown.

Having said that, I found that I can indeed have a formula column that references any number of summary columns so long as the summary columns are in the same or a lower group! I thought that I had already tried this and it failed - hence my question in the first place. But it seems to be working:-) Can't complain.

Jagdish.

On Thu, 03 Dec 1998 15:09:44 GMT, "claire marcoux" <cmarcoux_at_webnet.qc.ca> wrote:

>I dont know if it can help
>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 - 22:47:49 CET