Visual Studio Development Bookmark and Share   
 index > Crystal Reports for Visual Studio > Creating report from multiple linked tables
 

Creating report from multiple linked tables

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
Afi83  Thursday, October 08, 2009 11:04 AM
Hi,

You might need to set the datasource of report to a dataset which contains these tables .

For more information about how to connect dataset , please take a look at the tutorial:

http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/en/CrystalReports_dotNET_SDK/crsdk_net_doc/doc/crsdk_net_doc/html/crtsktutorialsdatads.htm

Harry
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Harry Zhu  Monday, October 12, 2009 4:04 AM

You can use google to search for other answers

Custom Search

More Threads

• Problem printing labels using Crystal Reports
• Error 80043ae3 in Openning a Crystal Report
• CR data problem
• Blank Crystal Report
• MAKE change in CRYSTALREPORT at run time
• running total with parametric percentile
• report source for my crystal reports...
• How to Change Data source in Crystal report
• Passing range and discrete parameters to crystalreport in vb.net (windows form)
• Export specific page with Crystal Report