'Pass parameters from SSRS report to snowflake using snowflake as datasoruce
I'm trying to pass the ssrs parameters to snowflake through the query window, however the fields or columns in the table are not being displayed for selection within the report. Any suggestions?
Have tried both single and double quotes
Option 1:
="select ""OrderID"" from ""Database.schema"".""Test"" WHERE ""OrderID"" IN ( '"+ Parameters!OrderID.Value +"');"
Option 2:
"select OrderID from Test WHERE OrderID IN ( '"+ Parameters!OrderID.Value +" ');"
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|