OraFAQ Forum: Reports & Discoverer » Report Generation using Matrix type

Home » Developer & Programmer » Reports & Discoverer » Report Generation using Matrix type

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

Report Generation using Matrix type [message #299283]

Mon, 11 February 2008 03:43

lokimisc
Messages: 101
Registered: February 2008

Senior Member

Dear All,
I want an report to be generated using oracle-8i and D2k-6i, which is some what similar to the sample given below. please check the attachment for layout.

Eg: In emp table group all employees who are hired on particular date and having

1) salary above 1000 and below 2000

2) salary above 2000 and below 3000

3) salary above 3000

Deptno1, Deptno2 ……… are the values / data ( not an column ) like ACCOUNTING, RESEARCH ……etc

Total1, Total2, Total3 are the total of all the emp in all the dept (eg: Accounting + Research + …..) whose salary > 1000 and < 2000, salary >2000<3000 and Salary > 3000 respectively.

Tot1, tot2, tot3…….. are the total / count of all the emp in a particular dept ( irrespective of their salary range )

Can anyone Please help to solve this problem.

Thanks & regards
Lokesh

Attachment: Report.doc
(Size: 31.50KB, Downloaded 1150 times)

Report message to a moderator

Re: Report Generation using Matrix type [message #299739 is a reply to message #299283]

Wed, 13 February 2008 01:18

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

From my little knowledge i tried your requirement. please fine the attached rdf file and open with scott/tiger connection. I hope it will useful for you.

If anything please reply.

Thanks

Mano

Attachment: Matrix_Ex.RDF
(Size: 56.00KB, Downloaded 1167 times)

Report message to a moderator

Re: Report Generation using Matrix type [message #300004 is a reply to message #299283]

Thu, 14 February 2008 00:24

lokimisc
Messages: 101
Registered: February 2008

Senior Member

Thanks buddy!!!!
From your little knowledge you have solved my big problem.

http://www.orafaq.com/forum/images/message_icons/icon14.gif
http://www.orafaq.com/forum/images/message_icons/icon14.gif

Report message to a moderator

Previous Topic:	How to print OLE object used in report builder in PDF format in oracle apps
Next Topic:	Method to convert 10g reports with a parameter form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 09:07:22 CDT 2024