SSRS

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.

 

 

 

Answer 1

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"))

Answer 2

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