Are board can connect Store Procedure SQL?
yes, from an SQL DataReader you can execute Stored procedures. For this you have to switch to manual query and type the stored Procedure using EXEC
If in SP i have script to create temp table and some parameter, are board still work?
because my report basically shown if user input parameter like ('day','location').
sure, you can use parameter, but this must be "static" ones. So you can't overhand some values from BOARD.
But you can write data to a rolap cube (text cube) and use this data wihtin your SP (but I dont understand, why you want to create new tables inside a SP)
Okey So Board can connect SP with parameter which done by manual query use EXEC, but it must "Static" ones.
Thanks Björn Reuber.
Hi Björn Reuber,
Is there a special syntax i have to use in order to get this to work? I tried
to no avail. The error reported is
I can run the procedure successfully in SSMS#
you need to add also the db name (exec DBNAME.SCHEMA.SP)
thanks Guido but that does not make any sense - I select the connection which specifies the database already.
I tried it anyway and it failed with the following error
did you used the same SQL user in SSMS and in BOARD? Cause board is getting this error message directly from MSSQL
We had a permission issue in the DB and once that was fixed it still did not run.
After talks to one of my colleagues it was pointed out that browse did not work - it did run in the data reader screen (this baffles the mind - should be the same right?)
sql procedure stored procedure
Retrieving data ...