CHAPTER 6 BUILDING REPORTSFigure 6-25. Parameters required for the stored procedure Emp_Svc_Cost
In the Report Data window, you can see that the report parameters were automatically created from
the stored procedure. Although SSRS did correctly assign the datatype for each parameter, integer, and
string, it did not automatically set the field to allow NULL values (see Figure 6-26). For the purpose of
this report, which expects NULL values as possible parameters, it is important that the Allow Null Value
checkbox is selected for each parameter so that when the report is previewed, NULL will be the default
value, and the NULL checkbox will be automatically checked so that the report executes without
requiring user input. Go ahead and update all of the parameters to Allow null value by right clicking each
of them and selecting Properties. Then put a check in the option Allow null value under the General tab.