Results 1 to 7 of 7

Thread: report services

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: 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

    Code:
    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) )
    Last edited by desireemm; 11-29-07 at 14:07.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    why not make it a sproc?

    I don't know if that matters or not
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    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
    Have you hugged your backup today?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by hmscott
    You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

    Brilliant!
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Heres the error

    this is the message I'm getting inside the Sql Server business intelligence studio
    Last edited by desireemm; 04-15-09 at 17:23.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    this is the message I'm getting inside the Sql Server business intelligence studio

    Ummmmm..what message
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Red face Ahh Rats sorry About that

    Quote Originally Posted by Brett Kaiser
    Ummmmm..what message
    My Bad, hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •