Обсуждение: Report Interface problem with Crystal Report 6.0
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Dear Sir,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I am using Crystal Report 6.0 on Windows XP Pro platform. The VB application currently uses MS Accessdatabase 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”</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">What could be the problem and the solution for the same?</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Makarand Kulkarni</span></font></div>
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@postgresql.org [mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Makarand Kulkarni
Sent: 17 June 2006 6:10 am
To: pgsql-interfaces@postgresql.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!
Personally, I’d view the SQL behind the reports (you can do this in Crystal 8, I’d think you could 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@postgresql.org [mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Makarand Kulkarni
Sent: 17 June 2006 6:10 am
To: pgsql-interfaces@postgresql.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!