OLEDB connection problem

[eang]

I'm trying to load an SQL recordset into Crystal Report 8.0 using an OLEDB connection, but the numeric fields doesn't show in the result. Only the characters field appears. What do I have to do to correct this problem?????

 

[KathrynC]

Make sure you have no nulls in your recordset. The OLEDB can be very picky about nulls and may read the whole column as invalid. Also, make sure there are no stray characters or spaces. Then, verify the database. It's been a while since I worked with this, but I did hammer out the bugs, let me know if this doesn't work.

K

 

[kenhamady]

Also make sure that the report and the recordset use the fields in the same order. If the report fields are in a different order than the recordset you will get flaky results. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal