Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
default values for parameters

Answered default values for parameters

  • Tuesday, February 12, 2013 5:52 AM
     
     
    Sign In to Vote
    0

    if ID_COMPANY_ODC =ALL THEN I WANT BECOME THE REMAINING PARAMETERS ALSO WILL COME 'ALL'

    IF NOT I AM GETTING available values,,

    Regards

    Arjun

    mallis

     

All Replies

  • Wednesday, February 13, 2013 7:23 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    0

    Hi Arjun,

    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:

    Add Cascading Parameters to a Report (Report Builder and SSRS)

    Regards,
    Fanny Liu

     

    Fanny Liu
    TechNet Community Support