The Design And Implementation Of Integrated Data Query System Based On SSRS

SQL Server Reporting Services (SSRS) technology is a business intelligence technology based on Microsoft SQL Server 2005. By this technology, a new report query system has been developed. From data layer, report query can be based on various data source and implements; from view layer, the report data can be displayed by different patterns or formats, such as Excel, Web, Form Client, Email etc. On the one hand, with Web Service application interfaces and strong report developing capability, the scalability of the console will be promoted. On the other hand, Microsoft SQL Server and related products has been widely used in enterprise, taking the cost control and the personnel technical proficiency into account, I develop the query system based on Reporting Services of SQL Server.This paper argues that current Jilin City Information Platform has some problems because of its traditional structure. First, the independence of the system is low. When there are changes in the under layer database, the top layer requires a lot of business change, which leads the system not to run properly. Second, the extension is poor, when requirements change, the system can not update timely. Third, it supports few formats of reports, and the reports are not rich. To solve these problems, the integrated data query system based on SSRS was developed, which implements the following breakthroughs. First, the system calls the database directly, which improve the system independence. Second, the deployment module and report module was designed using SSRS SOAP interface, which provides a system call interface and improved system expansibility. Third, provides support for a variety of report formats using the SSRS RDL technology.In addition, at this stage, there are some disadvantages when other ssrs based data query systems integrated into the information platform. On the one hand, over reliance on manual configuration and deployment leads to low efficiency. On the other hand, the application of SSRS lacks of collaboration, which is a waste of platform resources. However, this paper solved these problems. First, the deployment module was used and achieved automatic deployment, which reduces manual operations and shorten the deployment time. Second, report generation, mail settings and other functions were called to fulfill the function of the original platform, which avoids the platform entirely from the original and maximize the integration of the resources.