locked
SSRS RRS feed

  • Question

  • User-310235732 posted

    Hi,

    I am working on SQL Server 2005 SSRS reports, i wanted to have a default parameter like

    ex: In Preview, the dropdown should have "US" as Country's dropdown's default parameter and Region should be "NorthAmerica" and date set to beginning of the year 2010.

     

    Could you please help me in doing so .

     

    Thanks in Advance.

     

     

     

    Monday, May 24, 2010 8:17 AM

Answers

  • User-624088818 posted

    1:Create a parameter with name County and dataType as Text, and in Available Menu select GetValues from a Query if you are using dataset to get list of countries, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter =cstr("US"). Now US will be default value

    2:Create a parameter with name Region and dataType as Text, and in Available Menu select GetValues from a Query if you are using dataset to get list of Regions, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter =cstr("NorthAmerica"). Now NorthAmerica will be default value

    3.Create a parameter with name year and dataType as Date/Time, and in Available Menu select GetValues from a Query if you are using dataset to get list of Dates, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter ==CDate(Format(Now(),"yyyy"))

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 24, 2010 8:36 AM

All replies

  • User-624088818 posted

    1:Create a parameter with name County and dataType as Text, and in Available Menu select GetValues from a Query if you are using dataset to get list of countries, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter =cstr("US"). Now US will be default value

    2:Create a parameter with name Region and dataType as Text, and in Available Menu select GetValues from a Query if you are using dataset to get list of Regions, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter =cstr("NorthAmerica"). Now NorthAmerica will be default value

    3.Create a parameter with name year and dataType as Date/Time, and in Available Menu select GetValues from a Query if you are using dataset to get list of Dates, give dataset name ,value field and Label Field. In Default Values select specific values and in expression enter ==CDate(Format(Now(),"yyyy"))

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 24, 2010 8:36 AM
  • User-693935751 posted

    Go to the Report parameter and use all deafault values for the parameters.

    Everytime when you will preview the report you will get the report data generated by the default values provided.

     

    Thanks,

    Shobhit

    Monday, January 3, 2011 5:07 AM