OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » linking issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

linking issue [message #278655]

Mon, 05 November 2007 05:15

brintha
Messages: 28
Registered: August 2007

Junior Member

hi all,
I have two queries which has no link with each other. But they have two count values each of some field say 'xyz'. I need to perform division operation between the two counts. Is that possible. If so please help me out with the solution.

Regards,
Brintha.R

Report message to a moderator

Re: linking issue [message #278665 is a reply to message #278655]

Mon, 05 November 2007 06:06

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Well, I suppose we could work something out using analytical functions. But why do you want this?

Report message to a moderator

Re: linking issue [message #278672 is a reply to message #278665]

Mon, 05 November 2007 06:25

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here's an example; see if you can use it.

Create two queries: first will select count of employees who work in department 10:

select count(*) c1 
from emp 
where deptno = 10

The second query will return number of employees in department 20, along with the ratio value you need to display:

select count(*) c2, 
       count(*) / :c1 c_divide_c2_by_c1  --> this is what you are looking for
from emp 
where deptno = 20

Use Report Wizard to create a paper layout. The final result is as follows:

/forum/fa/3341/0/

Attachment: ratio.PNG
(Size: 1.48KB, Downloaded 1028 times)

Report message to a moderator

Re: linking issue [message #278711 is a reply to message #278655]

Mon, 05 November 2007 07:58

brintha
Messages: 28
Registered: August 2007

Junior Member

Little foot & Skooman,
Thank you so much for your replies. Little foot thank you for helping me out to solve the query.

Regards,
Brintha.R

Report message to a moderator

Previous Topic:	populate workbooks on portal
Next Topic:	setting pagesize

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:03:48 CDT 2024