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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics