Re: Report Interface problem with Crystal Report 6.0

Personally, I'd view the SQL behind the reports (you can do this in Crystal
8, I'd think you can do it in 6 as well), and run the SQL command directly
against the database server (i.e. through psql, or a management tool.)

That will give you a more reasonable indication as to what's going wrong.

If the SQL runs fine on the server ,you need to be looking at the ODBC
driver configuration.

Are you using ODBC or OLE DB to access PostgreSQL?

Andy

_____

From: pgsql-interfaces-owner(at)postgresql(dot)org
[mailto:pgsql-interfaces-owner(at)postgresql(dot)org] On Behalf Of Makarand
Kulkarni
Sent: 17 June 2006 6:10 am
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Report Interface problem with Crystal Report 6.0

Dear Sir,

I am using Crystal Report 6.0 on Windows XP Pro platform. The VB
application currently uses MS Access database and Crstal report 6.0 report
tool. I am now chaning the database to PostgreSql. The conversion has been
successful, but some of the reports do not work. There are @ 90 reports in
the software out of which 6 reports work perfectly. For others I get
"Automation Error"

What could be the problem and the solution for the same?

Regards,

Makarand Kulkarni

!DSPAM:14,4493f912256841211711626!