first use crystal reports to setup a TTX file that describes the fileds in your ado record set.
next add the crystal report designed ocx to your project, set the database to the TTX as a data definition file so that you can design your report.
then in the section of code to display the report form (Copied from Crystal Report tech support)
Dim CrAppl as Craxdrt.Application
Dim Crrep as craxdrt.report
dim Adors as adodb.recordset
adors.open "blah blah blah" for data source
set crrep = crappl.openreport "report file name.rpt"
crrep.database.tables(1).setdatasource adors,3
crviewer1.reportsource = crrep
crviewer1.viewreport
uhh...did i say that?
Woody