Could not find stored procedure in version 2014.2

[jackvaughn03]

Hi,

After upgrading from previous version 2012 to 2014.2.2004. The upgrading of the reports were totally smooth.

All the reports generating are stored procedure in the Data Source.

The error message is: Could not find stored procedure.

If I compare from the previous version. There is no error message like this.

So how can I fix this the new version?

Thanks,

Jack

[Alex K.]

Hello,

Can you please describe your issue in more details. Also, if possible, please send us a sample report with test data for analysis.

Thank you.

[jackvaughn03]

Actually, in our last version (2013.1) we have no problem encountered like this, especially in data source executing of stored procedure. In the design and run time a report.

However, I just installed the latest version 2014.2 and 2014.3. Please see attached file.

If you click the Exclamation ( Run button ) it will show the error message.

But if you retrieve the columns, if perfectly works.

I you want to test to the error, just make a report that will call any stored procedure and you will see the same problem I encountered.

Thank you for your quick response.

[jackvaughn03]

This version was from 2013.1.

Executed the Query Text and the message return: Executed SQL statement successfully.

Thank you.

Jack

[Alex K.]

Hello,

It is difficult to say something without sample.
Can you please send us your report and this procedure (create query) for analysis.

Thank you.

[anuj130989]

Hi Jack,

Facing the same issue with new 2015, just need to know that how did you resolve your issue?

Thanks,'
Anuj

Hi,

After upgrading from previous version 2012 to 2014.2.2004. The upgrading of the reports were totally smooth.

All the reports generating are stored procedure in the Data Source.

The error message is: Could not find stored procedure.

If I compare from the previous version. There is no error message like this.

So how can I fix this the new version?

Thanks,

Jack

[HighAley]

Hello,

To help you we need to know the cause of the issue.
Could you specify what issue do you have? With totally smooth or with store procedure.
Please, send us all information about the issue that will help to reproduce it.

Thank you.

[vsolar]

i have same problem in this version of Stimulsoft
i solve it by selecting type "Table" instead of "Procedure"
and write query like this:

Execute Procedure_name
@Parameter_name1,
@Parameter_name2,
...

[Alex K.]

Hello,

If you uses query statement - "exec procedurename parameter1, parameter2 ... ", you need set the type as "Table/Query", if uses only procedure name in the query then need set the Type as "Procedure".

Thank you.