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