The Design And Implementation Of Integration Report Platform Based On SQLServer Reporting Services

Integration report platform based on SQLServer Reporting Services is intention of change the staues of IT system of Yunnan Telecom Dehong Branch. Due to historical reasons, these systems (such as accounting, business admissible, 201, IC card, channel support, business analysis, etc.) exist independently, with different database and different report system. With the continuity of telecommunications business: one data of business can obtained from various IT platform, on the other hand, one report may need variety data from any platforms. Lack of uniform standards causes a serious effect on business analysis and decision-making. With the rapidly development of the branch, A higher demand placed on the analysis. Need more manpower and resources to collecte data to analysis.This paper want to integrate original business platform. The chief work is to investigate the framework of integration report platform; a new report system has been acquired with the study of the original report system. This paper establish a feasibility strategy and actual implemented, discuss the way to convert the old format to uniform report definition, the data extraction, and the implementation of cycle data transfer. As well as the strategy of system management and role control. This thesis's platform implemented integration, which include: put the report data together; converted the old report format to the uniform format—reporting services format, all this work masked the differences of database and report format, without changing the existing platform and business rules. So, reached the thesis's aim is known as "uniform caliber, uniform interface, centralized management, and centralized backup".The platform has been come into use. And it better meets the demands of the report statistics of the branch. Greatly enhance the accuracy of the Report and data extraction efficiency.