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

Cannot get subscription email when including report, but can get it when just sending link

When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF." When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.

I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.

Any suggestions?

-Matthew

Noone has had any sort of similar issue as this? I find that hard to believe.

-Matthew

|||

You may also want to make sure that the IIS_WPG user has permissions within the report server to view the report you are trying to email. The problem I am having is that I am unable to send emails with the report to anyone outside of my active directory domain. So if I try to send it to someone @.hotmail.com i receive the following error:

The e-mail address of one or more recipients is not valid.