crystal report connection

[farizalrahman]

hi ..
i have a problem when trying to display a report that i previous make using crystal report 9. i been using mysql database. when viewing the report from crystal report 9 it has no problem at all, but when i try to view in in vb.net 2008 ith has a problem.
the problem is, it keep showing the database connection dialog. i don't know to to solve it.
here is my code in vb.net

'------------------------
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CrystalReportViewer1.ReportSource = ("c:\report\12.rpt")
CrystalReportViewer1.Refresh()
End Sub
'--------------------
in crystal report i used the ODBC connection.

i know it is easier to user vb.net crystal report, but i don have time to convert all then report in have done in the past.
before this the report work fine in vb6

please someone help me.

 

[pannasn]

Put the following line of code,

CrystalReportViewer1.SetDataSource(yourDataset)

Thanks
Panna

 

[farizalrahman]

doesn't work..

 

[Hack]

i know it is easier to user vb.net crystal report, but i don have time to convert all then report in have done in the past.
before this the report work fine in vb6

If you are going to convert to VB.NET, then take the time to convert your reports or forget VB.NET and just stick with VB6.

 

[farizalrahman]

i think you are right, may be i should stick with vb6 first and try to convert all the report i've done before moving to vb.net

thanks..

 

[bschave2]

solution

integrated security is turned off. had the same problem and this worked.

myTableLogonInfo.ConnectionInfo.IntegratedSecurity = True