WEB REPORTING SERVICE DENGAN DATABASE TERDISTRIBUSI UNTUK MONITORING TRANSAKSI BERBASIS POINT OF SALES

Application of Point of Sales (PoS) is a software to manage transaction data, merchandise data, and report. To manage report of more than one PoS, it needs data integration that can be accessed effectively, efficiently and not depend on the time. The resulting report will give information of each PoS and able to give report comparison among PoS either transaction or merchandise data. Because of that the writer developed web reporting service, that is service that able to fulfill the information needs of Point of Sales report that can be accessed through web. While for data integration from some PoS, the writer using snapshot replication method for database distribution. It is done beside to facilitate database access that separated at some PoS location, and also to serve as reserve database, in the event if local database error. The application design development by using modeling language of Unified Modeling Language (UML. At implementation stage of desktop application (Point of Sales), the writer by using Visual Basic.Net and at Web application by using ASP.net 3.5 programming language. Results of web programming service development is a web based software that able to produce transaction report, merchandise report, transaction comparison report, and merchandise comparison report in the form of table and graphic. The report service also provide navigation feature; zoom, search, transaction and merchandise graphic that can be break down, view by parameter, export to various format such as PDF, Excel, CSV, Html, XML, and report printing.