Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal Report with PostgreSQL Post Reply Post New Topic
Author Message
Raghavendra_Rao
Newbie
Newbie


Joined: 28 Jun 2010
Location: India
Online Status: Offline
Posts: 4
Quote Raghavendra_Rao Replybullet Topic: Crystal Report with PostgreSQL
    Posted: 28 Jun 2010 at 7:57pm
Hi All,

I want Crystal Report 8.5 or 2000 to be configured with PostgreSQL 8.4.

I have used Microsoft OLE DB for configuring PostgreSQL. Connection was successful. But when i try to use the stored procedure with parameter, then i face an error as
"Microsoft OLE DB Provider for ODBC Drivers: ERROR: function/procedure".

I also need what is exact steps for calling stored procedure.

Can anyone help on this?

Regards
Raghav
Regards
Raghav
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 28 Jun 2010 at 9:19pm
try to help.
 
when you get this error message?
is it when you refresh the report?  or  when you choose the stored procedure (SP)?
or ??
 
if you get this message when you refresh then try to Verify the database from CR.
you can do this from 'Database - Verify Database'.
if you still get this message, try to remark the params in your SP and verify your CR again.
 
 
hope it help.
 
Emir W
IP IP Logged
Raghavendra_Rao
Newbie
Newbie


Joined: 28 Jun 2010
Location: India
Online Status: Offline
Posts: 4
Quote Raghavendra_Rao Replybullet Posted: 28 Jun 2010 at 10:10pm
Hi,

Thank you for your prompt reply.

Sure will test this accordingly, in the meanwhile, i would request you to show any link or any doc for calling stored procedure.

Please.
Regards
Raghav
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 28 Jun 2010 at 11:00pm
actually, i don't know if there is such information that you looking for out there in i'net.
 
but for calling/adding stored procedure (SP) from CR for new report is same as adding tables.
as per my experience, using Cache and MS-SQL database, i can add the SP (whether with/without parameters) to CR and put all the fields on the reports.
 
currently i'm using CR XI.
and, I think, the process for adding a SP to new report in other CR version are similar.
correct me if i'm wrong.
 
when you create new report from CR (and plan to use SP for it):
1. you need to connect to ODBC
there will be a window with 2 columns (available data source in the left side, and selected tables in the right side)
 
2. in left side column (available data source)
a. right click on empty area
b. click 'Options'
    you'll find 'Data Explorer' with options
c. check 'Stored Procedure'
    so you can see all the SP on that DB
 
3. click on 'Create new connection'
 
4. select ODBC
    and select the ODBC that you want.
    and follow the wizard (one of them is selecting the DB).
 
5. you'll see the DB name
 
6. expand DB name
    you'll see Tables, View, SP
 
7. select which SP that you want to use
and continue the wizard.
 
if there is a params in SP then it will directly ask you the params.
 
 
 
hope it help.
 
Emir W
IP IP Logged
Raghavendra_Rao
Newbie
Newbie


Joined: 28 Jun 2010
Location: India
Online Status: Offline
Posts: 4
Quote Raghavendra_Rao Replybullet Posted: 29 Jun 2010 at 5:48am
Hmmm...

Great, its working now.

I was using Crystal Report 8.5, when,I have upgraded to current version when using with PostgreSQL, it started working.

Is this the cause of my error ?

Regards
Raghav
IP IP Logged
Raghavendra_Rao
Newbie
Newbie


Joined: 28 Jun 2010
Location: India
Online Status: Offline
Posts: 4
Quote Raghavendra_Rao Replybullet Posted: 29 Jun 2010 at 3:35pm
Back Again,

I am trying to use SP with refcursore. Can you send me an an example of how to setup a crystal report with a plsql function/procedure passing a refcursor back to crystal and mapping the refcursor fields to the report.

When i used stored procedure,am getting the following error message.

Crystal Report Error Message

Failed to retrieve data from the database
Details: ADO Error Code:Ox
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: ERROR: a column definittion list is only allowed for functions returning "record";
Error while executing the query
SQL State: 42601
Native Error: [Database Vendor Code:7]

Any help on this ?
Regards
Raghav
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 29 Jun 2010 at 8:04pm
looks like it's about 'syntax error OR access rule violation'
 
unfortunately i don't know anything for PostreSQL.
 
i hope someone else can help you on this.
 
 
regards,
 
Emir W
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.