Re: Reports 2.5 - Summary Section Question

add on another query in the data model

select product,sum(value)
from ..
group by product
order by product
Jenny Farnham wrote in message <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!
Received on Sat Nov 20 1999 - 01:53:44 CET