Maybe its not actually ado, but the crystal reports active data driver. Whenever you pass a recordset to crystal reports it uses this driver. Try connecting using the active data driver in the little tree control they have and see if this gives you the same result. If so, that's the problem.
Try passing an ado recordset at runtime. It's a lot cleaner way of doing everything. The minimum you have to use the designer is to set unbound fields on it and assign them at runtime. I've posted the code throughout this site several times, but if you want it and can't find it let me know and...
Ken,
Last night I found the code that passes a recordset, and it does not use the active data driver. In fact, the only time you have to touch the designer is to drop your unbound fields to it. Its beautiful.. Here it is..
Dim Report As New CrystalReport1
Dim ADOrs As ADODB.Recordset
Dim...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.