Considerations for setting report parameters in SSRS

In the process of Custom reports, you often need to set some parameters, such as the time parameter settings (such

Createtime >=@ begindate) Is better, and to set a parameter so that it can filter the keyword segment freely, you need to pay attention to the following items (set below@ GradeFor example ):

1.As shown in, useGrade in (@ grade)InsteadGrade = @ grade;

 

2.For example, in the available values of parameter properties, select the specified value. If there are not many options, you can list them one by one. If there are many options, you should choose to get the value from the query;

 

3.For example, in the default value, you should add all the options to the default value.

 

4.For example, select allow multiple values.