Page 1 of 1

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

Posted: Wed Aug 21, 2013 2:10 am
by 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
image.jpg (17.95 KiB) Viewed 1629 times

Re: How to create New Data Source from sql connection's func

Posted: Wed Aug 21, 2013 7:42 am
by Alex K.
Hello,

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

Thank you.

Re: How to create New Data Source from sql connection's func

Posted: Wed Sep 11, 2013 2:19 am
by Jia Sheng
I set sql like "select * from FunctionName(Var1, Var2)", Fortunately it work!

Re: How to create New Data Source from sql connection's func

Posted: Wed Sep 11, 2013 5:50 am
by HighAley
Hello.

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

Thank you.