Thread: Postgres and Crystal Reports

Postgres and Crystal Reports

From
David Rickard
Date:
Has anyone out there worked with Crystal Reports and PostgreSQL?  We have an intranet site, currently in Oracle with many Crystal Reports files, which we are converting to PostgreSQL; the issue is that Crystal apparently cannot read Postgres text fields--when you point a report at a table/view that contains text fields, the text fields are simply not listed in Crystal;
We were wondering if: 1) could this be an issue with the ODBC drivers?  (We're using the ODBC drivers installed with pgAdmin II 1.4.12); 2) if this is an ODBC issue, is there another source for the ODBC drivers?;

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA  *  York, PA  *  Boston MA  *  New Delhi, India
----------------------------------------------------------------------------------


David.Rickard@GTSCompanies.com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]

Re: Postgres and Crystal Reports

From
"Williams, Travis L, NEO"
Date:
Are you talking about a true postgres text field and not a varchar field?  I think the text fields are postgres specific..
 
Travis
-----Original Message-----
From: David Rickard [mailto:David.Rickard@GTScompanies.com]
Sent: Tuesday, October 28, 2003 6:35 PM
To: pgsql-novice@postgresql.org
Cc: Judith Strawser
Subject: [NOVICE] Postgres and Crystal Reports

Has anyone out there worked with Crystal Reports and PostgreSQL?  We have an intranet site, currently in Oracle with many Crystal Reports files, which we are converting to PostgreSQL; the issue is that Crystal apparently cannot read Postgres text fields--when you point a report at a table/view that contains text fields, the text fields are simply not listed in Crystal;
We were wondering if: 1) could this be an issue with the ODBC drivers?  (We're using the ODBC drivers installed with pgAdmin II 1.4.12); 2) if this is an ODBC issue, is there another source for the ODBC drivers?;

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA  *  York, PA  *  Boston MA  *  New Delhi, India
----------------------------------------------------------------------------------


David.Rickard@GTSCompanies.com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]

Re: Postgres and Crystal Reports

From
Godshall Michael
Date:

 
Hi,

I use Postgresql and crystal 9.0 SP1 everyday.

I use PgadminII or III with the odbc driver prior to the latest release.

What version of Crystal are you using?  The other day I believe I saw Crystal had released a service pack/monthly hot fix which fixed a bug with reporting against postgresql databases.  It was that Crystal was expecting a Memo type instead of text?  Search the crystal knowledge base and I am sure you can find it.

The only problem I have had with Crystal and Postgresql is that if you use  Schemas that you cannot report directly against a table if it is not in the  public schema.  You can create a view which references the table and that will show up in the database expert but selecting a table generates a "not implemented error."

-----Original Message-----
From: Williams, Travis L, NEO
To: David Rickard; pgsql-novice@postgresql.org
Cc: Judith Strawser
Sent: 10/28/2003 7:45 PM
Subject: Re: [NOVICE] Postgres and Crystal Reports

Are you talking about a true postgres text field and not a varchar
field?  I think the text fields are postgres specific..
 
Travis

-----Original Message-----
From: David Rickard [mailto:David.Rickard@GTScompanies.com]
Sent: Tuesday, October 28, 2003 6:35 PM
To: pgsql-novice@postgresql.org
Cc: Judith Strawser
Subject: [NOVICE] Postgres and Crystal Reports

Has anyone out there worked with Crystal Reports and PostgreSQL?  We
have an intranet site, currently in Oracle with many Crystal Reports
files, which we are converting to PostgreSQL; the issue is that Crystal
apparently cannot read Postgres text fields--when you point a report at
a table/view that contains text fields, the text fields are simply not
listed in Crystal;
We were wondering if: 1) could this be an issue with the ODBC drivers?
(We're using the ODBC drivers installed with pgAdmin II 1.4.12); 2) if
this is an ODBC issue, is there another source for the ODBC drivers?;

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

------------------------------------------------------------------------
----------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA  *  York, PA  *  Boston MA  *  New Delhi, India
------------------------------------------------------------------------
----------

David.Rickard@GTSCompanies.com
Visit us on the World Wide Web
http://www.gtscompanies.com <http://www.gtscompanies.com/>
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]