Push Reporting

Periodically sending reports based on queries targeted at various databases

The Push Reporting system is designed to give users the ability to easily create report templates, based on pre-defined SQL query statements, and to schedule to have reports dynamically generated and emailed to them on a regular basis. The email output can be in the form of plain text, HTML, or file attachments (such as PDF and Excel)

The user is able to view his report templates (and those of other users, provided the user has the appropriate access rights), as well as view, edit, and delete them. Furthermore, at any time the user can choose to generate a report for immediate emailing

The generation of reports is handled by dynamically-created SQL DTS packages, one for each report template

  • When a report template is added by the user, a DTS package is created and scheduled to run according to the parameters specified by the user
  • When a report template is modified, the DTS package is updated accordingly
  • When a report template is disabled/re-enabled, the package is disabled/enabled
  • When a report template is deleted, the package is also deleted

 The users can manage their report templates via the web interface, and can decide, for each report template, the periodicity of the report sending process, as well as the  content of  the report

Platform details

  • Environment: Microsoft Windows Server 2008
  • Development language: Visual Basic .NET 2008, ASP.NET 3.5
  • Requirements: Internet Information Services (IIS) 7, Microsoft SQL Server 2008



Recent posts on our blog
AngularJS – how to write a simple application for listing products
Sep 01, 2016, by AdrianC
In the first article you got to know something about Angular, and now it's time to get underway and see it in action.... read more
Programmers are bound to make an impact on the Romanian administration
Aug 31, 2016, by VladC
The Romanian Government tries to develop a new platform called GovITHub, which is designed to simplify all aspects regarding the Romanian public administration.... read more
Romanian students innovate at Microsoft's Imagine Cup
Jul 14, 2016, by BogdanD
Romanian students, Flavia Oprea, Iulian Mateșică and Cristian Alexandrescu from the Polytechnic University of Bucharest won the Innovation challenge in Microsoft's Imagine Cup competition.... read more


Products  |  Press  |  Site Map  |  Technologies  |  Terms of Use  |  Privacy Policy
© 2017 SBP Romania. All rights reserved.