Starting SSRS Report Builder
Or, download it, starting with the download feature in SSRS:
When Report Builder first starts, it brings up a popup. If Report Builder was started from the SSRS menu item labeled 'Dataset' the popup's title is 'New Report or Dataset'. Normally, you'll download and install Report Builder. Starting Report Builder as an installed application, the popup is labeled 'Getting Started'. Either way, once you get to this screen, select a data source. If this is the first time you have used a data source, find the 'Browser other data sources...' selection at the bottom to locate your new data source.
If you need to create a data source, see Data Source setup in SSRS 2016.
And then select your new data source:
Using the Dataset builder in Report Builder, add your tables, views and columns.
You can also switch to T-SQL mode, using the Edit as Text command at the top:
(HINT: click on the Edit as Text button a second time to switch back to the standard mode.)
Saving the DatasetOnce you have the query setup and tested, save the Dataset as a file. Using the File tab, ...
Once saved, adjust the view settings for your SSRS browser, and your new Dataset is displayed.