Re: Oracle Reports

From: chris <cys4_at_columbia.edu>
Date: 1997/08/07
Message-ID: <33EA90D9.52F9F871@columbia.edu>#1/1

This is a multi-part message in MIME format.

--------------ABA06509AFE27DB99D800D25
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Alastair Coombs wrote:

> In DEVELOPER/2000 REPORTS 2.5
>
> example:
>
> Station Name Total Calls Percentage % Total per
> Brigade
>
> Ashton 50 ?????? 200
>
> Brighton 50 ??????
>
> Cairo 20 ??????
>
> I can get a percentage for just 1 station but if I have a 1 - Many
> relationship ie. for every STATION NAME I need the total calls and the
>
> percentage the way I get a percentage only returns 1 value.
>
> How do I get it to return a percentage for each STATION NAME the same
> as Total
> Calls.
>
> Cheers
>
> Sally
>
> sally_at_ajcoombs.demon.co.uk

   I do not know how your data model looks like, but it seems like you need to LINK the two select statements.

--------------ABA06509AFE27DB99D800D25
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Christopher  Suh
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Christopher  Suh
n:              Suh;Christopher 
email;internet: cys4_at_columbia.edu
title:          Oracle Developer

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard

--------------ABA06509AFE27DB99D800D25-- Received on Thu Aug 07 1997 - 00:00:00 CDT