Creating Innovative Solutions
ReportBox - Capabilities
-
ReportBox has the following core functional capabilities: Data Preparation, Template Preparation and Report Creation.
-
ReportBox is a collection of components (Portal, Web API, DLLs, Processor and Database) which together provide reporting functionality to any application.
-
ReportBox allows users to create document based reports based on templates designed in Microsoft Word.
-
Users can define merge fields or placeholders in document templates, which are then replaced with data. For ex: a Medical Prescription report template may contain mergefields that look like <<Patient_Name>>.
-
These mergefields can be replaced with simple text data, text in tables or images.
-
ReportBox allows users to simply push data (in XML form) as part of the report request which is then merged with the template to generate the report.
-
Alternatively ReportBox provides advanced features to pull and assemble data from data sources, which is then merged with the template to generate the report.
-
Assembling data requires users to register data source connections and create business entities. These business entities are then used as merge fields in Report Templates.
-
Other ReportBox features include printing reports.
ReportBox - Components
Built on the .Net framework, ReportBox is a reporting engine which has the following components:
Portal
A web site that allows users to create report data source connections, business entities, report templates, view reports, configure printers, view error logs etc. It uses the ReportBox DLLs to deliver the functionality.
Web API
The Web API is used by external applications to create reports. The Web API uses the DLLs to achieve the same.
DLLs
The DLLs are used by the portal to store data source connections, business entities, create templates and generate reports.
Processor
Inherently designed to be highly scalable, the report processors load balance and process asynchronous report requests. After receiving the report requests, report processors assemble data from data sources and then merge the data with the template to create the report.
Database
The ReportBox database is a SQL Server database which is used for storing database source connections, data entities, templates and reports.
ReportBox - Technologies
The ReportBox Portal, Web API and DLLs are hosted on a Web Server. The web server requires .Net framework version 4.0 and above.
The ReportBox Processor is deployed on a Web Server or Application Server. The application server requires .Net framework version 4.0 and above.
The ReportBox database is deployed on a Database server having SQL Server 2008 or above.
GreenThoughts
