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!!
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!!