Using a dynamic ADO recordset as data source for a crystal report

[Becca999]

Hello,

I have an ADO recordset that gets built dynamically:

Global grstReport as New ADODB.Recordset

Public CreateRecordset()
With grstReport
.Fields.Append "tmpLeftOrder", adSmallInt, , adFldIsNullable + adFldMayBeNull
.Fields.Append "tmpLeftSN1", adInteger, , adFldIsNullable + adFldMayBeNull
.Fields.Append "tmpLeftSN2", adInteger, , adFldIsNullable + adFldMayBeNull
.Fields.Append "tmpRightOrder", adSmallInt, , adFldIsNullable + adFldMayBeNull
.Fields.Append "tmpRightSN1", adInteger, , adFldIsNullable + adFldMayBeNull
.Fields.Append "tmpRightSN2", adInteger, , adFldIsNullable + adFldMayBeNull
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
End With

End Sub

I need to used this recordset as the data for a Crystal Report. I set up the report using Database -> More Data Sources -> Active Data -> Field Definitions Only and created a Tab Separated Text file with the same field names as in the global recordset which is suppose to just be place holders.

Does anyone know the syntax for setting the recordset to the repotr from within the VB app?

Thanks!!

 

[zemp]

See the following article in the Crystal knowledge base.

http://support.businessobjects.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp

zemp

 

[Becca999]

Thank you so much zemp!! I have been searching and this is exactly what I needed!!