SQL Server Reporting Services (Shortly called as SSRS) is a server-based reporting platform used to create and manage tabular, matrix, graphical, charts and free-form reports. The reports that we create can be accessed and managed over a World Wide connection.
In this article, we will show you the step by step approach to create new project in SSRS with an example.
TIP: SSRS can extract data from both the relational and multidimensional data sources to generate a report.
How to Create a New Project in SSRS
In this example, we will show you, the steps involved in creating a New Project in SSRS (SQL Server Reporting Services). To do so, First Double click on Business Intelligence Development Studio (shortly called as BIDS) and then select the File option from Menu item
Please select New and then select the New Project… option for creating new SSRS Project
Once you click on the New Project… option, It will open New Project window to select the required project from available project templates
Click Ok to finish creating New SQL Server Reporting Service project. Now if you look at the Solution Explorer, you can understand the solution name and project name.
From the above screenshot, you can observe that we have three folders under the SSRS project
- Shared Data Source: If you want to share the same data source for multiple reports, report models and subscriptions then we have to create a shared data source. Please refer to SSRS Shared Data Source article to understand the Data Source configurations
- Shared Dataset: If you want to share the same dataset to multiple reports then we have to create shared Dataset. Please refer to Shared Dataset in SSRS article to understand the Dataset configurations.
- Report: This folder is used to create SSRS Reports. If you want to create Reports using Wizard then, Please refer SSRS Table Report Using Wizard article otherwise Please refer SSRS Table Report article
Thank You for Visiting Our Blog