Tuesday, February 12, 2013 5:52 AM
if ID_COMPANY_ODC =ALL THEN I WANT BECOME THE REMAINING PARAMETERS ALSO WILL COME 'ALL'
IF NOT I AM GETTING available values,,
Wednesday, February 13, 2013 7:23 AMModerator
Based on your description, you can add cascading parameters in the report, the values of the remainging parameters are based on the value selected of the "id_company_odc" parameter.
To set available values for the remaining parametes, you can try to create a stroed procedure to provide values for the parameter. Please refer to the following query.
create procedure id_backoffice_odc (@id_company_odc nvarchar(20)) as if @id_company_odc ='All' select distinct 'All' as id_backoffice_odc from table else select distinct id_backoffice_odc from table
For more details about the casading parameter, please see:
TechNet Community Support