str1 = "select distinct [Sched_Code] as [No.], [Course], [Year], [Section], [Batch]," & _ " [Subject],[subject_desc],[units], [Time], [Day], [Room], [Instructor], [Schoolyr] as [S.Y.], [Semester] as [Sem] from tblSchedule, tblcurriculum where tblschedule.subject=tblcurriculum.subjects" Dim dt As New DataTable dt = ConnectDatabase(str1) rpt.SetDataSource(dt) CrystalReportViewer1.ReportSource = rpt help, i cant see content of my data generated from the tblschedule and tblcurriculum. i dont encounter any error.
Edited by decoder.mira: i dont have a reason on my code