How to create New Data Source from sql connection's function

[Jia Sheng]

When we design a report ,first we create New Connection -> sql connection(conn) Then we want to create New Data Source from sql connection's functions.But the dialog does not have the functions option.What can We do to create New Data Source from sql connection's functions?Thanks!
Now the dialog like (only have Queries/Tables/Views/Procedures, but no functions option)

image.jpg (17.95 KiB) Viewed 1628 times

[Alex K.]

Hello,

For Sql Connections and for others connection supported only Tables, Views, Stored Procedures and users query.

Thank you.

[Jia Sheng]

I set sql like "select * from FunctionName(Var1, Var2)", Fortunately it work!

[HighAley]

Hello.

Great! Thank you for the solution. It will help our customers.

Thank you.