Using field names with ADO

[jc717]

I was wondering if someone could help me.

I have a VB application that creates a recordset in memory and then uses crystal to generate a report off of the recordset. The reports are created in Crystal using a dummy database that has a table that looks like the recordset.
Everything works fine until I change the structure of the recordset.
If I insert fields into the recordset the report fields shift. It looks like crystal is finding the fields using their index number and not the field name.

Is there a way to force crystal to use the field name?

Thanks.

JC

 

[kenhamady]

I have found that the order of the fields is critical to matching up the recordset to the report. Since you control the recordset you can make sure that the fields are in the correct order. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/