Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

On Mon, 2009-03-09 at 15:07 +0000, Peter Geoghegan wrote:
> 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?

Just use numeric and don't create a domain?

Joshua D. Drake


> 
> Thanks,
> Peter Geoghegan
> 
-- 
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997