How to use a Guid as value for report parameter or data source parameter?

RELATED TO:

Article information

Article relates to

 Telerik Reporting

Created by

 Steve, Telerik

Last modified

 February 16, 2017

Last modified by

 Stef, Telerik


PROBLEM
How to use a Guid as value for report parameter or data source parameter?

SOLUTION
Set the Type of the ReportParameter to String. Use the CStr(System.Object) built-in conversion function to convert the Guid to String for the ValueMember property of the report parameter AvailableValues.
When using Guid DataSourceParameter and its value is set to a ReportParameter, create an User Function to handle the conversion:
C#
public static Guid ConvertToGuid(string guid)
{
           return new Guid(guid);
}

VB.NET
Public Shared Function ConvertToGuid(guid As String) As Guid
    Return New Guid(guid)
End Function

and set the value for the DataSourceParameter:

= ConvertToGuid(Parameters.Parameter1.Value)



OTHER APPROACH

Convert the Guid value to a String value in the data-retrieval method, or add a calculated field to the data source component by using the CStr(System.Object) built-in conversion function to convert the Guid to String.
Then you can use String report parameters directly.

Related Products
Telerik Reporting

Resources Buy Try

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community

  • Demos

    Invoices, Sales Reports, Dashboards and other reports showcasing what you can accomplish with Telerik Reporting

  • Webinars

    Sign-up for upcoming webinars and watch recorded webinars

  • User Voice

    Get answers directly from the people who build Telerik controls

  • Documentation

    Detailed help articles and API references for Telerik Reporting

  • Knowledge Base

    Tutorials and working examples on how to achieve common scenarios

  • Code Library

    Sample projects submitted by Progress staff and community members

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends

  • Release History

    Complete release history for Telerik Reporting.

  • System Requirements

    Operating system, .NET and browser support