how to schedule Parameterised Reports in SSRS 2008 R2?

See more:

SSRS

Hi, I developed one report by using stored procedure which contains around 40 parameters.

Now my requirement is I have to schedule a report with dynamic acess i.e assume my report contains userid parameter and I need to pass the parameter to the userid in report dynamically.

My actual requirement is my client having around 250 users and each user having more than 5 lac records. For this we developed offline report but the issue is we have to schedule a report to export to EXCEL and it should store in share folder and from this shared folder corresponding user can download the report.


thanks in advance.