SHIVPREET2K1
Jun 18th, 2009, 11:27 PM
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.
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
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.
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