UDF execution in dataset -- sql server reporting services

Mike
6/17/2005 5:32:02 AM

Hi,

Can you add the UDF to the SQL statement inside the Data tab?

[quoted text, click to view]

Kiran
6/17/2005 10:52:07 AM

Hi,

Switch off the Generic Query Designer in the data tab, right click click on
"Add Table..."

Then Goto Functions Tab and add ur functions

Kiran
[quoted text, click to view]

Kiran
6/17/2005 1:57:26 PM

I couldn't get that working for myself.

you can try putting the sql statement with UDF in a stored procedure and
call the stored procedure.

Kiran

[quoted text, click to view]

Andre
7/11/2005 2:36:03 AM

Mike,
Depends what type of UDF you have created. If it is a scalar function, then
you call it like:

Select dbo.Myfunction(parameters...) from mytable

If it is a Table-valued function then you call it like

Select * from dbo.Myfunction(parameters...)

Hope this helps

Andre

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : UDF execution in dataset