User based defult value for the Report Parameters
Hi,
I am looking for someone's help in changing the default value for the report parameters dynamically based on the user who generates the reports..
Let say x owns team1 and Y owns team2. Wat i want is to set the default value for the parameter as Team1 if X generates the report and as team2 if Y generates the report. Reports will be deployed in sharepoint server.
Thanks in advance.... :)
December 14th, 2010 6:32am
It is possible by using report built-in field User!UserID.
1. Create a dataset for parameter default value.
2. Pass User!UserId as a query parameter for this dataset and retrieve the corresponding value
3. Use this dataset in parameter default values property (by selecting 'Get values from a query' option).
Please let me know if you have any questions..
Regards,
Senthil
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2010 6:48am