Make a generic SSRS report in modern times.

1. Download Microsoft SQL Server 2008 R2 Report Builder 3.0 here. You will use this as the IDE instead of BIDS.
2. When the app opens and it tries to bring up a wizard, just close the wizard.
3. Click on the link at the lower left which says "Connect" and feed the dialog box which appears the URL to your SSRS server.
4. In the "Report Data" pane where there are "folders" for Built-In Fields, Parameters, Images, Data Sources, and Datasets, right-click on Data Sources and pick "Add Data Source..." to set up a data source, i.e. a connection to a database.
5. Right-click on Datasets next and pick "Add Dataset..." and then walk through the little wizard that appears. (Change the first radio button from "Use a shared dataset" to "Use a dataset embedded in my report." and then pick a data source and finally paste SQL for a query into the Query window before clicking: "OK")
6. Click on "Table" at the "Insert" tab at the top ribbon and pick "Table Wizard..." to start stepping through another wizard yet. Select your data set and at the "Arrange fields" portion of the wizard move all of the columns for your query at the "Available fields" subsection to the subsection titled "Values" with a Sigma symbol by it.
7. Click the "Run" button at the upper left of the "Home" tab at the ribbon to see what you've made.
8. When you close Report Builder it will prompt you to save a file with an .rdl file extension for the thing you have crafted.