Thursday, March 22, 2012

Cannot pass params (data type system.guid) to subreport?

Hello experts,

I am trying to create a report including a subreport in VS.2003 Reporting services. The subreport itself runs properly, if I give it a parameter, but when I try to run the main (parent) report, I get the obvious message Subreport could not be shown.

The output windows returns a message:

The value expression used in textbox ‘AccountID’ returned a data type that is not valid.

The AccountID field is a system.guid. I tried to "cast" it as a text, but I got another error message that the system.guid cannot be explicitly converted.

Does anyone know how to get around this?

Thank you very much.

Ravie.

The .NET GUID structure has ToString() method to get the guid converted to string. On the other side, you can use the GUID(string) constructor to convert it back to guid.sql

No comments:

Post a Comment