Unable to use the SQL function in my SSRS SELECT Statement as text in Dataset Properties

SSAS and SSRS
1

Hello,

How do I use the function that was created in the SQL server and use it in my SSRS SQL select statement when I am using text in SSRS Dataset properties as text from Query Type? I am getting errors and am not able to complete the process.

for example:

SELECT FunctionGetID(a.column,b.Column) AS ID
FROM TableA a
JOIN TableB b ON a.Column = b.Column

Thank you all

2

Try:
SELECT dbo. FunctionGetID(a.column,b.Column) AS ID

3

Hi Scott, yes I did and got the same error, "Could not update a list of fields for the query."

4

Restart VS did solve some errors I got but I would first try my query in my DBMS as the error-handling is better. I would use another alias as ID. And try it in a brand new report.

1 Like
5

Thank you RogierPronk