Modifying a SSRS Report

Introduction

We have created a report with the Report Wizard; you can modify it with the Report Designer. Suppose you have used any visual report design tool in the past. In that case, you should have no problem making changes or ensuring you have already read my previous article, "Create a Simple Report Using the Report Wizard – SSRS."

Steps

To modify the report that you just created, use the following procedure:

1. Click the "Design" tab to make the report editable.

2. In the Report Data window, right-click "DataSet1" and select "Dataset Properties."

3. In the Dataset Properties window, click the "Query Designer" button.

4. Select a Descending sort type for the "User_Full Name" column and click "OK."

5. Click "OK."

6. Click in the TextBox at the top of the report, where the report name is displayed.

7. Click a second time in the TextBox to put it in edit mode and change the value of this control to Employee Name by Desc.

8. Click on the header for the "User_Id" column.

9. Place the cursor between the column selectors and drag the cursor to the right to widen the table columns.

10. Place the cursor between the column selectors above the User_Id Number and User_FullName columns to display a double-headed arrow. Press the mouse button and drag the cursor to the right to widen the "User_FullName" column.

11. Save the Report.

12. Click on the "Preview" tab to view the modified report

Conclusion

We don't need to worry if a business person wants to change their report. Now we have a solution to change the report and make it look great.