Home » Developer & Programmer » Reports & Discoverer » Need help with a report (Oracle Reports 10 G)
Need help with a report [message #450392] Tue, 06 April 2010 20:31 Go to next message
venkat9876
Messages: 4
Registered: April 2010
Junior Member
Hi,
I need to create a matrix kind of report.

we have 3 tables

1. Course(course_id, course_name)
2. enroll(emp_id, course_id)
3. employee (emp_id, emp_name)
each employee can enroll into multiple courses.

we need a report with following output.

course1 course2 course 3 .. etc

emp1 emp2 emp1
emp2 emp3 emp2
emp3 emp3
..

the name of courses must appear as labels with the corresponding employees under each course.

I appreciate your inputs and help towards approaching this req.

Thanks,
Venkat.
Re: Need help with a report [message #450447 is a reply to message #450392] Wed, 07 April 2010 05:11 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
hi venkat,
Your requirement can be met without making a matrix report.

see the snap.
http://www.orafaq.com/forum/fa/7672/142623/

Make two repeating frames:
Dept- set print direction as ACROSS.
emp- default


Good Luck,
Shalabh
  • Attachment: report.JPG
    (Size: 65.19KB, Downloaded 316 times)

[Updated on: Wed, 07 April 2010 05:21]

Report message to a moderator

Re: Need help with a report [message #451630 is a reply to message #450447] Thu, 15 April 2010 19:17 Go to previous messageGo to next message
venkat9876
Messages: 4
Registered: April 2010
Junior Member
thank you shalabh. it works as you mentioned.

But one issue.

the department that we are displaying across ... lets say I like to display only 5 of them.

some of teh department names are really large and they get wrapped into 2 or 3 lines.

so, problem is ... the employess under the departemnts get dispalyed in an unaligned fashion. i am unable to align all the departments on one line at bottom.

can u tell me how i could achieve this.

thanks,
Nivas
Re: Need help with a report [message #451648 is a reply to message #451630] Fri, 16 April 2010 00:04 Go to previous message
shaz
Messages: 182
Registered: June 2009
Senior Member
post the snap of the report and the requirement what alignment do you want.
Previous Topic: Reports generate postscript with .pdf extension
Next Topic: Rep:1248 Report Contain uncompiled PL/SQL
Goto Forum:
  


Current Time: Sun May 31 03:17:34 CDT 2020