functions
1 Topic
How to use Table-Valued Functions in MS Report Builder
I have a Table-Valued Function in SQL that I'm trying to pull into MS Report Builder. It has 4 parameters (Start Date, Version ID 1, End Date, Version ID 2). My Function is: [dbo].[RateAttributionReportNmd] (@StartTapeDate DATE, @StartVersionId INT, @EndTapeDate DATE, @EndVersionId int) However, those 4 parameters aren't actual fields in the data but I want to use them as parameters in the report so that the function parameters can be used to update the data/SQL query. SELECT * FROM [dbo].[RateAttributionReportNmd] ('2024-10-31', 3, '2024-11-30', 2)Solved1.4KViews0likes2Comments