Can I run stored procedures when adding a new Data Source?

[theregister]

And if so where would they be located? Would there be a way to add the stored procedures to the dictionary somehow? Or would they have to be a in a database or something?

[theregister]

I mean when you add the SQL code to the new Data Source, like Selects and such...

[Alex K.]

Hello,

Yes, it is possible. You can use the Tables, Views, Stored Procedures and your queries as datasource.

Thank you.

[theregister]

But can these Stored procedures be declared from within Stimulsoft on the dictionary and not directly on SQL Server?

I ask because if I try to declare a Stored Procedure of a Select for example, it will give me syntax errors when I try to use Stimulsoft variables on the SP, like this:

Code: Select all

CREATE PROCEDURE test
AS
BEGIN
SELECT * FROM {Variable1}
END

[Alex K.]

Hello,

This logic (task) is completely incorrect. First, reporting is provided primarily to output information. We do not recommend any changes to the database from the report. Secondly, there is no control of the fact that such a procedure already exists, as well as that there is a table {Variable1}. You need to put this problem in your application, and handle all the possible incorrect options there.

Thank you.