I am creating a project based on Student Classes Attendance, in which I have 6 tables, all are linked with main table. Main table is "tblSheet" and related tables are like "tblPeriod", "tblBatch", "tblTerm" etc.
I created Crystal Report in which I have linked all 6 tables Crystal Report.
With the same query / tables and fields query I have created a DataSet, now the data in DataSet is correct, when I watching preview in Crystal Report (which was created at design time) is also displaying correct result, but When I pass this dataSet to Crystal Report at run-time the records are multiple and repeating again and again.
I have digged the problem that the INNER JOIN is not working when I pass the dataset in Crystal Report.
How can i make joining of tables in Crystal Report at run time or is there any other alternate solution to preserve linking of tables.
if you want then I can furnish my Ms Access Databse and complete project.
'This is query from which I am creating DataSet
SELECT tblbatch.BatchName, tblsheet.EngagedBy, tblsheet.LectureNo, tblsheet.NoOfStudents, tblsheet.Topic, tblsheet.[Date], tblsheet.[Day],
tblsubject.SubjectName, tblterm.TermName, tbltime.[Time], tblperiod.PeriodName
FROM (((((tblbatch INNER JOIN
tblsheet ON tblbatch.BatchId = tblsheet.BatchId) INNER JOIN
tblsubject ON tblsheet.SubjectId = tblsubject.SubjectId) INNER JOIN
tblterm ON tblsheet.TermId = tblterm.TermId) INNER JOIN
tbltime ON tblsheet.TimeId = tbltime.TimeId) INNER JOIN
tblperiod ON tblsheet.PeriodId = tblperiod.PeriodId)
'----- Report Code -------------
'Create Report Document to Load Report and Parameters for Report.
Dim dbRep As New ReportDocument
'Load Report from Specified path to Report document object.
'Load DataSet (created from above query) into Report.
'Bind Report Document to CrystalReportViewer to Show Report.
CrystalReportViewer1.ReportSource = dbRep