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