[RESOLVED] Cannot see data on report

[tommygrayson]

Hi guys!!!!

I am here once again because I can't solve the problem for 3 days now.

I can't see the data on the report. I am currently using Crystal Reports 10

and I am using VB6 with SQL Server 2000. There's something wrong with my

code because it works in Crystal reports. Here is the code:

Private Sub Form_Load()
Dim BookingSheet As New CRAXDRT.Application
Dim TransactionReport As New CRAXDRT.Report
 
Set TransactionReport = BookingSheet.OpenReport("\\mnlbs001\Cargo Suite\Applications\BookingSheet.rpt", 1)
 
CrystalActiveXReportViewer1.ReportSource = TransactionReport
 
 
CrystalActiveXReportViewer1.ViewReport
TransactionReport.RecordSelectionFormula = ""
MsgBox "{Transaction_Table.Transaction_No} = '" & Trim(frmTransactionEntries.txtTransactionNo.Text) & "'"
TransactionReport.RecordSelectionFormula = "{Transaction_Table.Transaction_No} = '" & Trim(frmTransactionEntries.txtTransactionNo.Text) & "'"
Screen.MousePointer = vbHourglass
Screen.MousePointer = vbDefault
 
End Sub
 
Private Sub Form_Resize()
CrystalActiveXReportViewer1.Top = 0
CrystalActiveXReportViewer1.Left = 0
CrystalActiveXReportViewer1.Height = ScaleHeight
CrystalActiveXReportViewer1.Width = ScaleWidth
End Sub

Can you guys please help me out.