Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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


  • From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
  • To: jd(at)commandprompt(dot)com
  • Cc: pgsql-odbc(at)postgresql(dot)org
  • Subject: Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain
  • Date: Tue, 10 Mar 2009 09:50:53 +0000
  • Message-id: <db471ace0903100250s3345bd1fqaf575838243b0df6@mail.gmail.com> <text/plain>

Joshua,

I've found a reasonable solution. I simply create custom "formula
fields" in Crystal reports. Formulas consist of things like this:

ToNumber({processed_daily_sales.value})
ToText({department_group.description})

They can then be used just as you'd use the columns themselves if they
were typed correctly. This is slightly hacky, but by far the most
acceptable solution, to my mind.

Regards,
Peter Geoghegan



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group