Datareport need help please

sleith · November 18th, 2007, 04:35 AM

Hi, i'm trying to use DataReport with VB 6. But got Run-time error '13': Type mismatch. Here is my code:

Code:

Private Sub cmdGenerateReport_Click()
    Dim conString As String
    conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\" & "Database.mdb;"

    Set con = New ADODB.Connection
    con.Open conString

    Set rec = New ADODB.Recordset

    query = "select name from ms_people"

    rec.Open query, con, adOpenStatic, adLockOptimistic

    If rec.RecordCount > 0 Then
        Set DataReport1.DataSource = rec
        DataReport1.Sections("Section1").Controls("Text1").DataField = "name"
        DataReport1.Show
    End If

    rec.Close
End Sub

The code error at 'Set DataReport1.DataSource = rec'.
DataReport1 is a simple data report (i didn't change the attributes)
Any help would be very grateful >.<. Thanks

gbianchi · November 19th, 2007, 08:26 AM

hi there.. are you sure that datasource receive a recordset?? not a conection string??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

sleith · November 19th, 2007, 08:33 PM

Hi, thanks for your reply :D
I read people's code that datasource receives recordset.
If it's connection string, could you please tell me how the code should be. thanks

gbianchi · November 20th, 2007, 08:45 AM

that's why I ask you if you were sure.. maybe it can receive recordsets, But I never work with it. I pointed it out because the kind of error you are receiving is like datasource expect a different type of object (that I don't know which type, did you check the help for it??)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========