Has anyone used Snowflake Stored Procedure(In Java script) with multiple parameters as data-source in Microsoft SQL SSRS report? (This is different from regular multi parameter , which we pass to SQL Server)

Question

Background : We have SSRS reports, which we used to run using T-SQL stored procedure from SSRS against SQL server, As per the new requirement, we now will be using Snowflake Stored Procedure (In Java script) replacing T-SQL stored procedure.

Question : Has anyone used Snowflake Stored Procedure(In Java script) with multiple parameters as data-source in Microsoft SQL SSRS report? (This is different from regular multi parameter , which we pass to SQL Server)

Concern : Using Snowflake Stored Procedure(In Java script) as a data source in SSRS is not supported .

Answer 1

Hi @Anuj Singh ,
I am not familiar with the snowflake stored procedure you mentioned. But you could refer to the data sources supported by Reporting Services listed in the official document:
Data Sources Supported by Reporting Services (SSRS).
Hope this helps.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.