Hey everyone I am having a bit of a problem getting started with passing credentials and rendering.

First let me say that I am using a web hosting company (webhost4life) to house my data and sql reports. I have to be able to pass a specific username and password to the reporting server and I have tried all the impersonate etc and it isn't working. Does anyone have any code (VB) on how to pass a specific username and password to the reporting services?

Secondly once I get past that hurdle I have a report that shows a summary by individual for their account. I basically want to render a report and send it to the account holder via email as an attachment. I can not use the scheduling portion because of some limitations with the hosting company. Any starting ideas would be great.