Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Unanswered: fail to display multiple table data on crystal report

    Public Class FrmRptUniversityFees

    Public Sub open(ByVal Argkey As Long, ByVal startdate As DateTime, ByVal enddate As DateTime)
    Me.SetDesktopLocation(0, 0)
    Dim cryreport As New ReportDocument
    Dim dt As New DataTable

    dt = Application.data.GetData("SELECT Registrations.RegistrationDate, Registrations.FirstName, Registrations.FatherName, Universities.UniversityName, Fees.ReceivedFee AS Expr1 " _
    & "FROM Registrations INNER JOIN Universities ON Registrations.UniversityKey = Universities.UniversityKey INNER JOIN " _
    & " Fees ON Registrations.RegistrationKey = Fees.RegistrationKey where Registrations.UniversityKey=" & Argkey & " and (Registrations.RegistrationDate between '" & Format(startdate, "dd-MMM-yyyy") & "' and '" & Format(enddate, "dd-MMM-yyyy") & "')")

    cryreport.Load(System.Windows.Forms.Application.St artupPath & "\Reports\RptUniversityFees.rpt")
    cryreport.SetDataSource(dt)
    CrystalReportViewer1.ReportSource = cryreport
    CrystalReportViewer1.Refresh()

    End Sub
    the given code works fine,but crystal report fail to display data.check attachement for the tables that i used in crystal reports.
    Attached Thumbnails Attached Thumbnails tables.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •