SQL Server Data Tools - TeamDewberry/jmxdatamart GitHub Wiki

Open SQL Server Data Tools. Create a new project and under ‘Installed Templates -> Business Intelligence’ select ‘Report Server Project’. Create a new Report Project

In the Solution Explorer panel, right click ‘Reports’, add a new item, and add a ‘Report’. (If there is no Solution Explorer panel click view and select Solution Explorer)

Add new Item to Report

Select Report

A ‘Report Data’ panel should appear on the right (if not, left-click the “Report1.rdl [Design]” tab/window and then either select ‘Report Data’ from the view menu or press Ctrl+Alt+D); right click data sources and add a data source. With Embedded connection selected click edit to open a new window; from this new window select a server name, select a form of authentication (if you choose SQL Server Authentication the username is ‘sa’), and select or attach a database.

A ‘Report Data’ panel should appear on the right (if not, left-click the “Report1.rdl [Design]” tab/window and then either select ‘Report Data’ from the view menu or press Ctrl+Alt+D); right click data sources and add a data source.

Once a data source is set up right click ‘Datasets’ from the ‘Report Data’ panel and add a dataset. Select to Use a dataset embedded in my report. After a data source is selected you may write your own query or click ‘Query Designer’.

Dataset Properties