report server - windows credentials userspecific?

is there any way to store the windows credentials user specific (for each user his one credentials) ?

- for an SSAS Report where the cube uses dimension security and the user get only some elementes of a specific dimension.
- we want to have a subscription in pdf format for a weekly e-mail to the user....

currently i have one report with an report specific connection.
And all the users have created a linked report to this report in their homefolder.
Is there any way to store the report specific connection on the linked report in the users homefolder ? - at the moment there is no datasource should - it seams this is only available in the mail report (link reference)

does anyone know an othere comfortable solution?

HANNES

Regarding reports from SSAS data sources:

In RS 2005, you can use expression-based connection strings. Through the expression you can access for instance the current user id exposed through the ReportObjectModel (which btw will be the surrogate user in case of an unattended subscription execution):
Connection string: ="data source=..." & "EffectiveUserName=" & User!UserId

More information about expression-based connection strings: http://msdn2.microsoft.com/en-us/library/ms156450.aspx (go to the "Data Source Expressions" section).

-- Robert