Modifying SSRS report parameters
To make sure that the report form that is to be created later can make use of the various report parameters correctly, you must make sure that the parameters are defined with the correct data types, properties, and default values, if any.
To modify the SSRS report parameters as required for the desired output:
- In the Report Data panel, double-click Parameters to expand the list of parameters.
- Double-click each of the parameters specified in this table and modify the values appropriately, using the Report Parameter Properties dialog box for each parameter:
| Name | Prompt | Data Type | Allow Null | Default Value |
|---|---|---|---|---|
| StartingUsername | Start with user | Text | Selected | (null) |
| EndingUsername | End with user | Text | Selected | (null) |
| StartTaskName | Starting task | Text | Selected | (null) |
| EndTaskName | Ending task | Text | Selected | (null) |
| StartReminder | Start reminder | Date/Time | Selected | (null) |
| EndReminder | End reminder | Date/Time | Selected | (null) |
| StartReminderOffset | Start reminder offset | Integer | Selected | (null) |
| EndReminderOffset | End reminder offset | Integer | Selected | (null) |
Note: For the Default Value, you must select
the Default Values tab and then select
Specify values. Click and then set the Value field to (null).