[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.

[tommygrayson]

Anyone?

[tommygrayson]

Ok now I am having progress. I just want to ask how can I assign two different passwords on two different users that will connect to one table. For example:

TransactionReport.Database.Tables(1).ConnectionProperties("User") = "sa"
TransactionReport.Database.Tables(1).ConnectionProperties("Password") = "cons0l"
TransactionReport.Database.Tables(2).ConnectionProperties("Password") = "cons0l"
TransactionReport.Database.Tables(3).ConnectionProperties("Password") = "cons0l"

I wanted to assign the password "cons0l" to user sa and a blank password to user john. How can I do that?

[tommygrayson]

Never mind. I have already solved it myself.