Has anyone ever had a problem using a BIGINT column from DB2? Crystal thinks it's a currency data type and yields $0.00 for each row in the table. I've used an older p2sodbc.dll from Crystal 7 and it still sees it as currency but I'm able to tweak the format to get the correct value to display. Any help would be greatly appreciated. It sees that the replies in the Crystal forum is pretty weak so I'll do my best to contribute and get this thing going a little.
Originally posted by db2me
Yeah, it won't display anything for me. However, if I access the same server/table/data via ODBC rather than the direct DB2 connection, I have no problems. You might try this.
Thanks! Once I tried accessing this table through "More Data Sources / DB2 Client" in Crystal, it worked fine.