how to create report without database

[binbpk]

hello,
is there a way to create a report without a database?
i want everything to show on the report in runtime.

[RobDog888]

What report? Crystal Reports, Access Report, etc. ?

[binbpk]

the normal reports that comes with vb6

[RobDog888]

That is really outdated but its the VB 6 Data Report.
I havent used it since 1998 just after VB 6 came out as its too limited and cumbersome.

If you can write some kind of textfile or ini file you may be able to connect to it instead but Im unsure.

[wes4dbt]

you could use something like this,

Dim rsP As New ADODB.Recordset

    With rsP
        ' Create Recordset Fields (Columns) here
        .Fields.Append "tender", adVarChar, 10
        .Fields.Append "activity", adVarChar, 8
        .Fields.Append "reading", adVarChar, 10
        .Fields.Append "turn out", adVarChar, 12
        .Fields.Append "date", adVarChar, 10
        .Fields.Append "time", adVarChar, 10
        .Fields.Append "cfs", adVarChar, 6
        .CursorType = adOpenKeyset
        .LockType = adLockOptimistic
        .Open
    End With

    ' load the data into the recordset

            With report1
                ' Bind the Recordset to the Report
                Set .DataSource = rsP
                .DataMember = rsP.DataMember
                .Show
            End With

Assign the text boxes on report1 to use the fields from the recordset.