I am having a parameter 'Employee' and it is multi valued.
This parameter gets values from Dataset 'Emp_Data'. It has the follwing query:
Select Employee_Code, Employee_Name from Employee_Table.
I tried to do this but didnt get What I exactly want. What I have done is :
IN the Report Prameters tab, went to Default Values section and selected From Query option and given the dataset name as 'Emp_Data' and Value Field as Employee_Code.
Now When I view it in the Preview tab. I am getting as this in the Parameter Employee text box:
Employee - James, Ross, Steve, Mark, Kevin........
For some reason, the client did not like this and they wants to see default as ALL Employees (instead of all those names displayed in the text box).
So Is there a way to make it as ALL Employees as default (when all employees are selected).
Note : I tried in this method also :
Select 'ALL' as Employee_Code, 'All Employees' as Employee_Name
View Complete Post