Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Can not using procedure in Crystal Post Reply Post New Topic
Author Message
nseaeast
Newbie
Newbie


Joined: 07 Apr 2011
Location: Vietnam
Online Status: Offline
Posts: 3
Quote nseaeast Replybullet Topic: Can not using procedure in Crystal
    Posted: 08 Apr 2011 at 5:02pm
I'm using Crystal report 9 and oracle 10g, i can using table in ODBC to connect to database, but when i drag a procedure to report, it show the error: "Not suported: Cannot obtain error message from server", pls help me to solve this problem.

Edited by nseaeast - 08 Apr 2011 at 5:02pm
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 14 Apr 2011 at 3:33am

Perhaps I misunderstand.  What sort of procedure, stored procedure?

I don't think of dragging stored procedures to the report, but selecting them like you would a table from your connection.
 
If this is what you are doing, I would take a look at the stored proc and see if how it works.
 
while I haven't used Oracle, I have used stored proc through both OLE and ODBC drivers for years on CR.
 
HTH
IP IP Logged
mukta
Newbie
Newbie
Avatar

Joined: 04 Apr 2011
Location: India
Online Status: Offline
Posts: 19
Quote mukta Replybullet Posted: 15 Apr 2011 at 2:45am
I have used stored proc through OLEDB provider for sql server.
and after getting proper connection i select procedure name from database.
then select particulars fields to display like this..

i create reports like this.

follow this process u will get success
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.