使用SQL Server Reporting Services基于现有存储过程创建报告

Basic extraction of the SQL Server database data is usually achieved by querying the databases and creating stored procedure to automate the extraction process. 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. 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.

SQL Server数据库数据的基本提取通常是通过查询数据库并创建存储过程以自动执行提取过程来实现的。 不幸的是，以这种方式提取信息不会产生高端报告，并且在通过SQL Server Management Studio或类似工具提取信息时，只有基本的表格形报告可用。 为了创建高端报告，其中将包括数据的其他投影，例如图形，列表，图表……SQL Server在SQL Server Reporting服务中提供了强大的报告选项。

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.

首先要创建报告，我们将使用Microsoft Visual Studio来为报告定义数据源并配置报告体系结构。

1. Start Microsoft Visual Studio and click on the ‘New project’

   启动Microsoft Visual Studio，然后单击“新建项目”

   

2. 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. Then, in the central pane select the “Report Server Project”. Finally, in the bottom part of the dialog, specify project and solution names and click on the “OK” button to complete this task

   在新打开的“新项目”对话框中，展开“商业智能”节点，然后在左侧的项目窗格中选择“ Reporting Services”。 然后，在中央窗格中选择“ Report Server Project”。 最后，在对话框的底部，指定项目和解决方案名称，然后单击“确定”按钮以完成此任务。