Re: Reports 2.5 - Summary Section Question
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sat, 20 Nov 1999 14:52:33 GMT
Message-ID: <RAyZ3.2688$lY5.49552_at_news.rdc1.nj.home.com>
Date: Sat, 20 Nov 1999 14:52:33 GMT
Message-ID: <RAyZ3.2688$lY5.49552_at_news.rdc1.nj.home.com>
You don't need another query. All you need is an additional layout based on
your existing query.
Go the to the layout and use the additional default layout tool.
General suggestion to the group. Most of the good Oracle Developer users
hang out on the ODTUG lists.
I would suggest joining ODTUG and participating in those lists. You can got
to them from the Dulcian web site.
I have seen a high percentage of incorrect answers in this group,
particularly to Oracle Reports questions.
-- Paul Dorsey Dulcian, Inc. (212) 595-7223 web address: http://www.dulcian.com email: pdorsey_at_dulcian.com Jenny Farnham <farnham_at_spot.Colorado.EDU> wrote in message news:814lf3$ftp_at_peabody.colorado.edu...Received on Sat Nov 20 1999 - 15:52:33 CET
> Scenario:
>
> on the main pages of the report they want detail like this
>
> Product Value
> ------- -------
>
> A 10
> 20
> 30
>
> Total(A) 60
>
> B 40
> 50
>
> Total(B) 90
>
>
> on a separate sheet at the end they want this:
>
> Product Total Value
> ---------- -----------
>
> A 60
> B 90
>
>
> Question: How do I do this? The summary column I set up for
> the detail will get overwritten at each break point (which is
> the product).
>
> How would I store the value 60 with product A
> and the value 90 with product B and then spit this
> out at the end of the report?
>
> Any ideas welcome!