View Single Post
  #18 (permalink)  
Old May 28th, 2006, 08:54 PM
XsiX XsiX is offline
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey big tnx...
u guys help me a lot!!!
ive already upgraded to vb2005, vb6->vb2005 much simpler than
vb6->vb.net and faster...tnx anyway

anyway heres the soln i made for those who still having probz

Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Set Report = Appl.OpenReport(App.Path & "\Reports\report1.rpt")
With Report.Database.Tables(1)
.ConnectionProperties("User ID").Value = "sa"
.ConnectionProperties("Password").Value = "pass"
.ConnectionProperties("Initial Catalog").Value = "MyDatabase"
.ConnectionProperties("Data Source").Value = "MyServer"
End With
Report.DiscardSavedData
CRViewer1.ReportSource = Report
CRViewer1.ViewReport


Reply With Quote