Prev: how to join dynamic SQL results with another query
Next: Help in update
From: moondaddy on 8 Jun 2010 20:21
using SSRS 2008 R2, I'm trying to pass in a parameter that's a guid data
type. all other parameters and data types seem to work OK except for Guids.
this is how its added:

ParameterValue value = new ParameterValue();
value.Name = "InLc_Id";
value.Value = "fa13edcf-c518-48b0-96aa-4d398cc0221d";
reportParameterValues.Add(value);


and when I execute the report I get the following error msg:


Message "System.Web.Services.Protocols.SoapException: The value provided for
the report parameter 'InLc_Id' is not valid for its type. --->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportParameterTypeMismatchException:
The value provided for the report parameter 'InLc_Id' is not valid for its
type.


Parameter values are supposed to be strings, so how else should I pass in a
guid?

Thans.
--
moondaddy(a)community.nospam

From: moondaddy on 9 Jun 2010 23:37
Never mind, I figured it out. Something was changed on the SP and I was
trying to pass a guid into a int data type.

--
moondaddy(a)community.nospam

"moondaddy" <moondaddy(a)newsgroup.nospam> wrote in message
news:uUxRDn2BLHA.4660(a)TK2MSFTNGP05.phx.gbl...
> using SSRS 2008 R2, I'm trying to pass in a parameter that's a guid data
> type. all other parameters and data types seem to work OK except for
> Guids. this is how its added:
>
> ParameterValue value = new ParameterValue();
> value.Name = "InLc_Id";
> value.Value = "fa13edcf-c518-48b0-96aa-4d398cc0221d";
> reportParameterValues.Add(value);
>
>
> and when I execute the report I get the following error msg:
>
>
> Message "System.Web.Services.Protocols.SoapException: The value provided
> for the report parameter 'InLc_Id' is not valid for its type. --->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportParameterTypeMismatchException:
> The value provided for the report parameter 'InLc_Id' is not valid for its
> type.
>
>
> Parameter values are supposed to be strings, so how else should I pass in
> a guid?
>
> Thans.
> --
> moondaddy(a)community.nospam

 | 
Pages: 1
Prev: how to join dynamic SQL results with another query
Next: Help in update