In our BI Reporting series, we address several BUI reporting tools. This blog expands on our Business Intelligence Quick Reference Guide in the area of SSRS reporting.

Enjoy.

 

1.From SQL Server Business Intelligence Development Studio (comes with SQL) create a project

File?New?Project?Report Server Project

2.Enter Project Name and click OK

3.In Solution Explorer right-click on Reports?Add?New Item?Report

4.Enter the report name and click Add

5.In the Report Data panel right-click on Data Sources?Add Data Source…

6.Enter unique descriptive name

7. Edit Connection String and identify the Server and Database names

8. Test Connection to validate

9. If applicable enter Credentials

10.In the Report Data panel right click on Datasets Datasets?Add Dataset…

11.Enter Dataset name and select the Data source you created

12.Click on Query Designer…

13.Add desired views (start with MSP_Epm***_UserView’s)

14.Define relationships and Query

15.From Toolbox pane drag report items to design surface

16.Format report and Save All

17.Copy the report’s *.rdl file from the Business Intelligence Projects directory

18.Load the *.rdl file to the …Reports directory or the SharePoint Reports library

19. Associate a valid Report Data Source with the new report

Download Complimentary BI Quick Reference Guide – Save hours and understand the power of Project Server 2010 Reporting