Error with Guid parameter in report

[Stanislav Dudnyk]

I have two input parameters type of Guid.
I set default values for parameters like d6a0d1a8-0d5d-4850-9930-5670dfa26403 or 'd6a0d1a8-0d5d-4850-9930-5670dfa26403'

When report preview I have error : Failed to convert parameter value from a string to Guid.

What is wrong?

[Peter]

Hello Stanislav Dudnyk,

Unfortunately our Report Parameters don't support GUID value types. Our suggestion would be to use a string parameter and with a Convert() function to change the parameter type to uniqueidentifier.

I have attached a sample report that shows how to accomplish your task. To run the sample project you will need the AdventureWorks database that comes with Telerik Reporting installation.

The SqlDataSource2 is using a Select statement as the one shown in the following code snippet:
 

Select Name From Production.Product WHERE rowguid=(SELECT Convert(uniqueidentifier,@RowGuid))

 
For more information check out Adding Parameters to Report help article.

Best wishes,
Peter
the Telerik team

[Stanislav Dudnyk]

Thanks!

[Stanislav Dudnyk]

What about stored procedure with uniqueidentifier parameter and I can't use text command or other stored?

[Peter]

Hi Stanislav Dudnyk,

You can use the same approach in Stored Procedures. Check out the following sample stored procedure:

CREATE PROCEDURE [dbo].[UsingGUID]
@RowGuid char(36)
AS
BEGIN
        Select Name From Production.Product WHERE rowguid=(SELECT Convert(uniqueidentifier,@RowGuid))
END

Sincerely yours,
Peter
the Telerik team

[Jonathan]

Is there no way to use Guids in the parameters? We are transitioning from SQL reporting to telerik and just want to reuse the stored procedures. In SQL reporting it accepts Guids, I would prefer not to make a copy of our stored procs with the parameters as strings because we have about 300 reports to build.

[Massimiliano Bassili]

searching before asking is gold: http://www.telerik.com/support/kb/reporting/designing-reports/guid-as-report-datasource-parameter-type.aspx

Cheers!