Skip to Content
0
Former Member
Sep 16, 2008 at 06:28 PM

Field Type Incorrect

31 Views

I have a Crystal XI R2 report that pulls from two Excel spreadsheets (also produced by Crystal) as the datasources. In one of the two spreadsheets, I have two running total formulas for amounts that a customer paid off on an account. The formulas export to Excel perfectly as numbers (and are truly formatted as numbers in both Crystal and Excel). However, when my third report goes and pulls the data from the first two reports, it thinks the two running totals are strings.

This is causing two problems - one is that I have to convert the values with tonumber() which I really shouldn't have to do. The other is that (and I'm not 100% sure this is related) I'm not getting any data whatsoever in those two fields in the third report - even though I can look at the data extract that the third report is pulling data from and see the values that should be there and should be included in the third report.

Any ideas?