Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: DB2's BIGINT in Crystal 8.5

    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.
    Last edited by ppm411; 03-11-04 at 11:38.

  2. #2
    Join Date
    Oct 2003
    Location
    Chicago
    Posts
    5

    Talking DB2 BIGINT in Crystal 8.5

    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.

  3. #3
    Join Date
    Mar 2004
    Posts
    3

    Re: DB2 BIGINT in Crystal 8.5

    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.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •