| Need help with a report [message #450392] |
Tue, 06 April 2010 20:31  |
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 #451630 is a reply to message #450447] |
Thu, 15 April 2010 19:17  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
