...
- Open Visual Studio.
- Create a New Project or open an existing Reporting Services project.
- From Reports folder, open an existing .rdl report file or 'Add a new report' to the reports.
- In the report, make the changes you wish to include.
- Under Data Source, right-click and open the Data Source Properties.
- Change the Data Source Properties as shown below.
- Under Data Sets, right-click the Dataset and update the query.
- Click Query Designer.
- Click Ok.
- In the Parameters tab, right-click and open the Parameter Properties.
- Change the Parameter properties as shown below.
- Save the report.
- Update the SSRS report in the ORO and upload the report file to the Reporting Server.