I am trying to create a report that uses an Active Data File so that I can
pass an ADO Recordset to my report from Visual Basic 6.

It works find except (and this is the most important thing) no data is
dsiaplayed.  I think it is because the field names don't exactly match from
SQL and with the report because Crystal Reports puts the Active Data File
name on the beginning of the field name (i.e.MyFile.Field1).  My ADO
Recordset returns just "Field1".   I have tried to give the SQL field an
alias but it doesn;t allow a fullstop in an alias name.  Any code examples
or help would be appreciated.

Dean Hobbs