ADO and Datareport

[corneagigi]

Hi everyone!

A am developing a visual basic 6 application that uses many database types so... I can't create dataenvironment to create easy datareports....
For the begining I use access database file....and I try to make miscellaneous reports and I really don't know how to build them...
I have to create them at runtime....

[wes4dbt]

You can use ADO recordset as report datasource.

'display Invoice Listing report
    With rptInvlisting
         ' Bind the Recordset to the Report
         Set .DataSource = rsR
         .DataMember = rsR.DataMember
         .Show vbModal
    End With

rsR is ADO recordset

[corneagigi]

Thanks a lot.....but I also want to build them at startup....add controls that manage my data

[wes4dbt]

Build what at startup? I thought you wanted to print a Datareport.

[brucevde]

Do you mean add controls to the datareport at runtime? If yes, don't bother trying because you can't.