Dear friends

I make a report in crystal reports 10 . the report is based of stored procedure which takes an input parameter. the report is working fine individually but when we open it through vb 6.0 it gives the username error below is my code . please check and help me to identify the error.

Code:
Dim Appl As New CRAXDRT.Application
Dim report As New CRAXDRT.report
 
CrystalActiveXReportViewer1.Top = 0
CrystalActiveXReportViewer1.Left = 0
CrystalActiveXReportViewer1.Height = 12336
CrystalActiveXReportViewer1.Width = 15408
Set report = Appl.OpenReport(App.path & "\Invoice_Report.rpt")
report.Database.LogOnServer "pdssql.dll", "mynetwork.com", "mydatabase", "myuser", "mypass"
report.DiscardSavedData
CrystalActiveXReportViewer1.ReportSource = report

CrystalActiveXReportViewer1.ViewReport

Please help to identy and sort the error. its urgent

thanks in advance


Shivpreet2k1