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
Дата: