Re: Reports 2.5 - Summary Section Question

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...


> 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!