PostgreSQL ODBC connection from Crystal reports in windows, currency domain

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: PostgreSQL ODBC connection from Crystal reports in windows, currency domain
Date: 2009-03-09 15:07:40
Message-ID: db471ace0903090807y182480a9rbb2de5b8376f314@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I'm attempting to get Crystal reports working with PostgreSQL with an
ODBC connection, via psqlODBC. I can successfully establish the
connection easily. However, I have a domain called "currency", that
handles currency values:

CREATE DOMAIN currency
AS numeric(10,2);
ALTER DOMAIN currency OWNER TO manager;

fields of currency appear as "strings" in Crystal reports, and they
lack fixed precision ( the value 1.00 appears as 1, for example). Why
might this be? How can I get it to appear as a numeric type, which I
can find the sum of, etc?

Thanks,
Peter Geoghegan

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jan-Peter.Seifert 2009-03-09 16:06:27 Re: Driver crashing on many temporary tables?
Previous Message Jan-Peter.Seifert 2009-03-06 09:27:39 Re: Driver crashing on many temporary tables?