PostgreSQL ODBC connection from Crystal reports in windows, currency domain

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
PostgreSQL ODBC connection from Crystal reports in windows, currency domain
Дата
Msg-id
db471ace0903090807y182480a9rbb2de5b8376f314@mail.gmail.com
Список
Дерево обсуждения
PostgreSQL ODBC connection from Crystal reports in windows, currency domain Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain "Joshua D. Drake" <jd@commandprompt.com>
Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain Peter Geoghegan <peter.geoghegan86@gmail.com>
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
В списке pgsql-odbc по дате отправления
От: Jan-Peter.Seifert@gmx.de
Дата:
От: Jan-Peter.Seifert@gmx.de
Дата:
FAQ