To add Datetime parameter select the Report in the top menu - > report parameters. Add a new parameter by clicking the add button. The parameter name is given in the Name section which is used in the query or stored procedures as parameter. the Datatype should be DateTime.



The prompt is the display name for the parameter in the report. Therefore it should given in the user understandable format irrespective to name.



Select Report parameter can be done by two methods.

1. By Creating the Dataset and use the From Query to populate the values.
2. By populating the values directly to the parameter thro Non-queried.

1. Create a Dataset and if the parameter value should be from Database means write a select query with the column name. If it is hard-coded text means write a select statement with that text and combine all the select statement with Union statement. Once the Dataset set is defined create a new parameter. Enter the name, Data type and Prompt. If the parameter output is multiple value means check the Multi-value checkbox.



If it is "From query" means select the Dataset for that input parameter and then fill the Value field and label field. the label field is the display field in the input parameter and the value field is used for internal process.

2. If it is Non-Query means the Value field and Label field are entered directly and those values are displayed in the input parameter.

If there is default value for the input parameter enter those thro two methods. By default Null is selected means there is no default value. If the value is hard-coded means select Non-queried and enter the default text. If the value has to be retrieved from the Database means use Queried statement and select the Dataset and the value field. the top column of the result set is the default value for that column.

Once the parameter values are defined clearly check the report.



If the parameter value is not mandatory or it should allow null values means select the appropriate checkboxes in the input parameters.