ARCHIVED: How do I create a table or matrix report in SSRS?

To create a table or matrix report in your SSRS folder:

1. From the SSRS folder, click Report Library.
2. In the ribbon, click Documents. From the New Document drop-down menu, select Report Builder Report. Keep New Report highlighted, and select Table or Matrix Wizard.
3. Select the Create a dataset radio button; click Next.
4. Click New to create a new connection for use only in this report.
5. With General highlighted on the left-hand side, enter a descriptive name for the data source.
6. From the "Select connection type:" drop-down menu, choose Microsoft SQL Server Analysis Services.
7. Click Build... to construct the connection string.
8. Enter the server name for the server where the data source is located.
9. From the "Connect to a database:" drop-down list, select the database. Click OK.
10. Highlight Credentials on the left-hand side, and make sure that Use current Windows user is selected.
11. Click OK to save the data source connection.
12. Click Next.
13. Click the ellipsis (...) button in the left-hand corner and select the cube. Click OK.
14. Drag and drop the measures and dimensions you want onto the empty frame. After you have completed the dataset, click Next.
15. Drag the measure into the [Sigma] Values pane, and the dimensions into the appropriate row groups and column groups boxes. Click Next.
16. Choose the layout for the table/matrix. Select subtotals and grand totals, if desired. Click Next.
17. Select a scheme for the table/matrix. Click Finish.
18. Click in the text box above the table to add a report title. You can also position the table differently inside the report frame, if desired.
19. To test the table/matrix, in the ribbon, click Run. To return to the report layout, click Design.
20. To save the table/matrix, click the floppy disk icon in the left-hand corner of the screen and open the Report Library directory. Enter a name for the table/matrix and click Save.