report services

hi all I'm in the Microsoft Visual Studio creating a report and I noticed I cant bring a function over, am I doing something wrong. I wanted to make a report based on a function. its a table valued function

ALTER FUNCTION [dbo].[Beginning_EndingFinals](@.StartFINALSUITDONE datetime,
@.EndFINALSUITDONE datetime)
RETURNS TABLE
AS
RETURN ( SELECT TM#, LASTNAME, FIRSTNAME, CONDITIONAL, DATEOFCONDITIONAL, FINALSUITDONE
FROM dbo.EmployeeGamingLicense
WHERE (FINALSUITDONE BETWEEN @.StartFINALSUITDONE AND @.EndFINALSUITDONE) )why not make it a sproc?

I don't know if that matters or not|||Are you attempting to execute the ALTER FUNCTION code within text of the dataset?

Or are you making the call to the function within the text (ie, SELECT * from dbo.MyFunction(MyParameter)).

You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Regards,

hmscott|||You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Brilliant!|||this is the message I'm getting inside the Sql Server business intelligence studio|||this is the message I'm getting inside the Sql Server business intelligence studio

Ummmmm..what message|||Ummmmm..what message

My Bad, hope this helps