Hi, I have a dropdown parameter that has not been fed from it's own dataset, it has for Available Values various specified values from different columns in the main dataset (f.ex. A,B,C,D), and No Default Value. It works fine when interacting with other parameters when a user selects one of the values. How can i add a "All" feature for this type of the parameter (i've found some solutions but they work only for params that are made on top of it's own dataset, which this is not a case)? The report is based on a stored procedure, and to repeat, this parameter is consisted of several columns in the main dataset. Thanks :)

Hi PowerWind, The solution for this is you need to write the query for available values as follows : like example : Select id,EmpName from tbl_Emp union Select '0','[Select All]' by writing the query like this you can get the select all option in the DropDown of your paramter and in stored procedure of the main dataset you need to change providing a if condition. I think this should fix your problem. Regards, Anish "Mark this post as answer if this post helps you, it might help others also."