Home » Developer & Programmer » Reports & Discoverer » Report Generation using Matrix type
Report Generation using Matrix type [message #299283] Mon, 11 February 2008 03:43 Go to next message
lokimisc
Messages: 88
Registered: February 2008
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 186 times)
Re: Report Generation using Matrix type [message #299739 is a reply to message #299283] Wed, 13 February 2008 01:18 Go to previous messageGo to next message
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 158 times)
icon14.gif  Re: Report Generation using Matrix type [message #300004 is a reply to message #299283] Thu, 14 February 2008 00:24 Go to previous message
lokimisc
Messages: 88
Registered: February 2008
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
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:
  


Current Time: Sat Dec 03 22:11:05 CST 2016

Total time taken to generate the page: 0.08702 seconds