Print Page | Close Window

Creating report from multiple linked table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7961
Printed Date: 18 May 2024 at 9:58am


Topic: Creating report from multiple linked table
Posted By: Afi83
Subject: Creating report from multiple linked table
Date Posted: 08 Oct 2009 at 3:45am
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.
I use crystal report 8.5 and work with vb6 for getting reports.
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



Replies:
Posted By: hilfy
Date Posted: 12 Oct 2009 at 2:05pm

What type of database is this?

Can you create the following links?

From                     To                          On
tblStudent             tblStuCoursJunc    studentID
tblStuCoursJunc    tblCourse              courseID
tblStuCoursJunc    tblGrades              juncID
 
Group on tblStudent.studentID or, if you need to have it in alphabetical order by student name, then create a formula and group on that.  Set up the group so that the group header repeats on every page.  Put the student info in the group header.  Turn on "New Page After" in the Group Footer.
 
Then sort on either CourseName or CourseID (depending on the order you need) and put the course and grade info in the details lines.
 
-Dell
 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window