Re: Oracle Reports (3.0) formula column

Hi Helen,

If you require the formula to be calculated at the parent level, you could do the following in the data model:
- Define a summary column in your parent group (associated with your parent query) for each of your child amounts to be included in the formula. - Sum each of the child amounts into these summary columns. - Create your formula column and use the summarized columns for the child amounts and your parent column in your calculation.

Hope this provides the result to satify your requirements. Sheila Thackray
BHP IT
Newcastle, Australia

helen267_at_my-deja.com wrote in message <85bfue$7uq$1_at_nnrp1.deja.com>...
>I'm having problems creating a formula column in
>a report (Developer 2000, V3.0). I have a parent
>query, and two child queries linked back to the
>parent, and I want to perform a calculation
>between two columns from separate child queries
>(it is not possible to perform the calculation
>within the queries).
>
>If I place the formula column in either of the
>child groups I get the message "Column 'F'
>references column 'A' (or 'B') which has
>incompatible frequency", and if I place it in or
>outside the parent group, I get the message for
>both child columns.
>
>Anyone have any ideas on how I can perform this
>calculation?
>
>Helen
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Jan 12 2000 - 14:27:36 CET