problem with report

[jherdy]

sir,pls help me i have problem in my program when i click the print to generate a report i have an error message that say, "Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". Im using MySQL ODBC 3.51 Driver, and I'm using crystal report 10. Hope you can help me urgent pls.

[randem]

mySQL has it's own driver. Why are you using a MS driver? They don't make an mySQL driver.

[jherdy]

this is my code when i click the Print

Private Sub mnu_RoomInv_Click()
  frmReport.Caption = ViewReport(frmReport.CRViewer1, App.Path & "/reports/room_inventory.rpt", Screen.Width, Screen.Height, mdiMain.mnu_RoomInv.Caption)
End Sub


Function ViewReport(CRViewer As CrystalActiveXReportViewer, _
               sFilename As String, _
               lngWidth As Long, lngHeight As Long, _
               Optional sFormTitle As String = "Report Viewer", _
               Optional bGroupTree As Boolean = False) As String

  Dim Appl As New CRAXDRT.Application
  Dim Report As New CRAXDRT.Report
  Dim x As Long
    Set Report = Appl.OpenReport(sFilename)
      CRViewer.Width = lngWidth
      CRViewer.Height = lngHeight - 1000
      
      With Report
        .DiscardSavedData
        .EnableParameterPrompting = True
      End With
      
      CRViewer.ReportSource = Report
      CRViewer.ViewReport
    ViewReport = StrConv(Trim(sFormTitle), vbProperCase)
  Set Report = Nothing
  Set Appl = Nothing

End Function

Hope you can help me...thanks

[randem]

The code you posted has nothing to do with the connection string that you probably included in the report connection. You need to change that.

[jherdy]

sir can you give me a sample for connecting the report

[randem]

I don't use the controls of CR to do reports. I use the ADO passing og recordsets that I have already taken from the database. But youvwill need to go in the designer and make a connection to your database then test the connection. After that your report should workvas planned.

[jherdy]

sir, Im using CrystalActiveXReport can you give me an example. thanks

[Hack]

Moved to reporting section

[jherdy]

Is there a way to connect MySQL ODBC 3.51 Driver in Crystal Report X. can you give me a sample of code to connect that. hope you can help me thanks....

[randem]

Sample code won't help if you don't go intovthe CR designer and set it up to use the code...

It does not matter which method you use you still have to go into the designer to set it up.