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
Hadoop: the future is now - and it's all about Big Data
Jun 05, 2017, by Dragos
Apache Hadoop is an open-source software written in Java, a framework that allows for the distributed processing of very large data sets across clusters of computers.... read more
Linux goes down in history: a mature operating system
Mar 14, 2017, by AdrianC
As we’ve seen in the second part of this series, the number of Linux distros has increased rapidly, as the Open Source community responded in a positive manner to the flexibility of the Linux kernel.... read more
Linux goes down in history: the early life
Dec 08, 2016, by AdrianC
The first mention about Linux was made by Linus Torvalds in 1991. The Finnish software engineer confirmed his interest in the standard POSIX definition, without revealing the name of his MINIX project.... read more


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