question

ANUJSINGH-2225 avatar image
0 Votes"
ANUJSINGH-2225 asked Joyzhao-MSFT edited

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)

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 .


sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @ANUJSINGH-2225 ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.