[RESOLVED] vb6 crystal reports

[mebhas]

OK, i was trying to do a report in crystal reports. mind u all, i've never done reporting thru any data reports except for thru excel.

now it turns out that i have absolutely no idea on creating reports without using a data environment.

i am using ado connection. i have the recordset ready. i do have the report ready too. just that i dont know how to bind the recordset to the fields in the report.

CrystalReport1.Database.SetDataSource dbRS

says error 9, subscript out of range.

does anybody have a step by step tutorial on this? this is urgent and i am ready to sleep. sorry, not even have time for a search right now.

thank you.

[RhinoBull]

What CR version do you use?

[RobDog888]

Here is an example of using the CR Viewer control but it shos how to bind your recordset as you were missing some parameters.

Also, you need to set up a ADO connection in the CR IDE for your report. This is how you would bind the textboxes to your fileds, do aggregrate funtions, etc.

Option Explicit
'Add reference to Crystal Reports x.x ActiveX Designer RunTime Library
'Add reference to Crystal Reports Viewer Control
'Add reference to Microsoft ActiveX Data Objects 2.x Library
'oCnn = current open ADO connection object
Private Sub Command1_Click()
 
    Dim oApp As CRAXDRT.Application
    Dim oReport As CRAXDRT.Report
    Dim oRs As ADODB.Recordset
    Dim sSQL As String
 
    sSQL = "SELECT * FROM Table1"
    Set oRs = New ADODB.Recordset
    Set oRs = oCnn.Execute(sSQL)
    Set oApp = New CRAXDRT.Application
    Set oReport = oApp.OpenReport(App.Path & "\MyReport.rpt", 1)
    oReport.Database.SetDataSource oRs, 3, 1
    crvMyCRViewer.ReportSource = oReport
    crvMyCRViewer.ViewReport
 
End Sub

[RhinoBull]

I don't think that will work for mebhas - he's most likely using CR8 (8.5 or maybe even 7) - CrystalReport1 tells me it's a control that was last included as of v 8.5. Your sample is suitable for post CR8.5 products.

[RobDog888]

Yes, my example is based off of my version - 8.5 developer. But I mostly wanted to show how to set the .SetDataSource correctly. Wasnt even sure if he is using a preview or not. Just a bonus.

[MartinLiss]

Moved.

[_Conan_]

This tut for Crystal Reports 9 . Maybe it will help

http://www.vbmysql.com/articles/crys...alvbmysql.html

[mebhas]

thanx to everybody who posted. i finally did make it work. it was a bit tricky but i did get it to work.

i am using cr9. i used robdog's code. not from here but i found it in one of his sigs.

i did use the cr9 help files to create the initial report first. then used robdog's code. but i did use a

crViewer.DiscardSavedData

so that the report didnot show any previously saved data.

and again thanx to all.