You can achieve this by adding a Filter with custom parameters/prompts on the report.
- Edit the report. Create new parameters/prompts, for example: FromDateParam and ToDateParam (as datetime types) with 'Prompt the user to specify a value' option selected and User input type as 'Type in'. You can specify a default value for the parameters.
- Under Filter tab, add filter expressions - in this scenario here, for example, it will be FromDate >= [Parameter:FromDateParam] and ToDate <= [Parameter:ToDateParam].
When the report is opened to view, the system will prompt for the FromDate and ToDate to be entered/input by the user (calendar widget will be available to select the dates).
Hope this addresses your requirement!
Thanks a lot for the response. I have done that.