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)
    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

4 Years
Discussion Span
Last Post by jared.geli

I am not so sure that query is returning anything.

You have to give a table.column on the select when two tables are being passed in on the FROM clause.

Try adding an alias and prefixing your columns.

For Example:

str1 = "SELECT DISTINCT ts.[Sched_Code] As [No], ts.[Course], ts.[Year]........ FROM tblSchedule ts, tblCurriculum tc WHERE ts.[Subject] = tc.[Subjects]"

In database make a view of two tables first then query the view. in crystal report


The alias should match the column name you are about to show in the report.

Ex. You want Sched_Code to show inthe report from your query of 2 tables.
First put Sched_Code in the Crystal Report then make your query. Your query
should be this.

Select [ts.Sched_Code] as [Sched_Code] From ts, tblSchedule

Note: If Sched_Code doesn't appear in other tables, don't use any alias.
Crystal Report is sensitive to Column Names based on my experience on
handling it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.