Skip to Content
author's profile photo Former Member
Former Member

Using store procedure in crystal report

Dear all,

Currently, our report are retrieving data from a database view, then make calculation in crystal report. However, it is difficult to maintain as we have some logic in view and also in report.

We want to modify the report. Use store procedure to do calculation and return the result set. Crystal report only get the result set from store procedure and do the formatting and grouping.

If the store procedure only contain SQL statement and return result set. It is easy to add into crystal report.

However, when the store procedure include a insert statment. When add to crystal report, it will have error. Something like the cursor is readonly.

So i'm not sure is it the limitation for using store procedure in crystal report.

Any experts can clarify this issue?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2010 at 05:30 PM

    Does the stored procedure run within the database (using something like MS Server Mgt Studio or TOAD) using the same user credentials and parameter values that the Crystal Report is using? I've never had an issue using INSERT in a stored procedure or SQL Command used by Crystal...

    HTH,

    Carl

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2010 at 11:08 PM

    Cliff,

    I gotta go Carl & Don... It's been my experience that CR doesn't know or care what an SP is doing on the server as long as it returns a usable result set. I'm thinking along the same lines as Carl... It sounds like a permissions issue on the db server.

    Jason

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.