Print Page | Close Window

Can not using procedure in Crystal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12859
Printed Date: 02 May 2025 at 12:39am


Topic: Can not using procedure in Crystal
Posted By: nseaeast
Subject: Can not using procedure in Crystal
Date 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.


Replies:
Posted By: lockwelle
Date 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

Posted By: mukta
Date 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


Print Page | Close Window