Post reply

Could not find Stored procedure 'name of procedure;

  • November 4, 2016 at 6:23 am

    #322684

    Ok, I have a weird one. I can run my SP in SSMS, no problems, I can run the Query in BIDS Run's fine from the Query on the Dataset

    When I do a preview of the report, I am getting the following message

    An Error occurred during local report processing.

    An error has occurred during report processing

    Query execution failed for dataset 'DataSet1'

    Could not find stored procedure '<name of my proceedure>'

    anyone know what the heck this is. I have looked all over the place to find an answer.

  • November 4, 2016 at 6:49 am

    #1910571

    What is the connection string for the data source you're using? Does it include the name of the (correct) database?

    John

  • November 4, 2016 at 6:53 am

    #1910573

    I just found the problem and was coming back to post what I found. For some reason it looked like the DS that I was using somehow got corrupted. I deleted it and recreated it and all is good now.

    How I figured it out was to create a new Datasource and try that. It worked just fine so I'm assuming that was the issue.

    Thanks

    Stephen

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply