Post reply

UniqueIdentifier as parameter

  • November 11, 2004 at 1:14 am

    #152312

    I'm creating a report off a stored procedure that has a uniqueidentifier as a parameter. When Reporting services creates the data set it sets the parameter type as string, but when I try to run the report I get an error: Invalid cast from System.String to System.GUID

    Changing the stored proc is not possible

    Anyone run into this before? Any suggestions?

    Thanks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • April 13, 2005 at 11:44 am

    #552505

    Yep..i have the same problem.  If you goto the report menu and click on Report Parameters at the top of Visual Studio you will see that you can specifiy the Report Parameter data type.

    UniqueIdentifer/GUID is not availabe. So, it appears that what I am going to have to do is pass the UniqueIdentifer into the stored procedure as a string and convert it to a GUID inside of the stored procedure.

    I can see no other way to get this to work.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply