The “Add New Item” dialog will appear, and we should opt for the “Report” project and provide the desired name, and click “Add” to complete this task. To do so, go to the “Solution Explorer”, bring up the context menu with right mouse click on the “Reports” and navigate to “Add” > “New Item…” Now that we’ve created both the Solution and the Project within it, we can start creating reports. Finally, in the bottom part of the dialog, specify project and solution names and click on the “OK” button to complete this task Then, in the central pane select the “Report Server Project”. In the newly opened “New project” dialog, expand the “Business Intelligence” node and select the “Reporting Services” in the project pane on the left side.
Start Microsoft Visual Studio and click on the ‘New project’ To start with the report creation, we are going to use Microsoft Visual Studio in order to define data sources for the reports and configure reports architecture. In order to create high-end reports that will include additional projections of the data, such are graphs, lists, charts… SQL Server offers powerful reporting options within the SQL Server Reporting service. Unfortunately, extracting the information in this way will not yield high-end reports, and only basic table-shaped reports are available when extracting the information via SQL Server Management Studio or similar tools. Basic extraction of the SQL Server database data is usually achieved by querying the databases and creating stored procedure to automate the extraction process.