Hi there I have a problem in crystal report. I have a database which is totally relational. About 10 table with one to many or many to many relationship. I want to create report from these tables but I don't know how. My problem is: I have 4 tables for saving information about students, Courses, coursestudentjunction and grades. I want to report the grades of each student for all courses for each major that student registered to. In my report I want to show the student information on page header and course and grades on detail section. When I try to do so the crystal can not link tables. What I have to do make this? I do my best but I can't find the solution.
Here are the details about my tables:
tblStudent:Studentid,fname,lname,…majorID(FK)
tblcourse:courseid,coursename,majorID
tblstuCoursJunc: JuncID,studentID,courseID tblGrades:
GradesID,JuncID(fk),grades,gradesDate
Thanks in advance