SSRS

Getting Started with SSRS

We'll begin with the basics and then build up from there!

Create Report with Report Wizard

When creating reports in SSDT we have the choice to use either Report Server Project Wizard or Report Server Project. Using the Report Wizard is an easy way to get started. We can add more complexity by adding more features after the initial build.

Create Report with Report Wizard

Create Report from Scratch

When creating reports in SSDT we have the choice to use either Report Server Project Wizard or Report Server Project. Using Report Server Project provides you with an empty project such that you can add data sources, data sets, and report definition files (.rdl)

Create Report from Scratch

Configure Report Deployment

We’ll see how to deploy a report to the report server. The report server is generally used for admin purposes, i.e. giving users access to reports, among other things. Report Manager then accesses report objects on the report server allowing users to view reports via a URL, without interacting with SSRS directly.

Configure Report Deployment

Create Share Data Sources

Creating Shared Data Sources enables all reports inside and outside of the project to share the same data source.

Create Shared Data Source

Create Shared Data Set

Creating Shared Data Set enables all reports inside and outside of the project to share the same data set.

Create Shared Data Set

Last updated

Was this helpful?