Passing Parameter from SSRS to Databricks user defined function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 07:38 AM
I am trying to pass parameter from SSRS to User Defined Function in Databricks which in turn will return table that will be shown as output in report.
I tried below calling function from SSRS, but it looks like parameter value is not passed. I have directly executed this function in Databricks and it works fine.
Dataset:
SELECT *
FROM <Schema>.<UDF> ('{Date1}}')
Parameters Tab in Dataset:
ParameterName : @Date1
ParameterValue: '{Date1}}'
Parmeters:
Name: Date1
- Labels:
-
Ssrs
-
User Defined Function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2022 10:48 PM
can you share full code and dataset by that we can also debug this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2022 12:56 PM
Thanks Aviral. I found the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 02:27 PM
Hi Samit, could you explain your solution? I'm having the same problem. Thank you!