Developers Guide - Web Report Generator

Execution Steps

Inputs

  • A Template created in one of the Supported Document Formats conforming to Supported Template Syntax.
  • A Connection String in order to connect to a DataBase that can be accessed through DataSet / DataTable etc
  • Type of Data Source. For example, Table / Views etc
  • Data Source. Select a table / view from the connected DataBase

System Processing

  • Verifies Template Document Format.
  • Connects to MS SQL Server Database using connection string
  • Tests Connection according to the provided connection string.
  • Populates all Tables from connected database.
  • Populates all Views from connected database.
  • Allows to enter Custom Query.
  • Passes Template and Data Source to the GroupDocs.Assembly - GroupDocs.Assembly generates a report according to the inputs
  • Serves the report back to the browser

Output

  • A Report generated based on the Template Syntax and the Data Source - This report will be in the same Document Format as that of the source Template Document Format.

Here is a sample report in Microsoft Word Document Format for ‘Products’ table

Code Walkthrough

Default.aspx.cs

ReportGenerator.cs

Technical References

Creating Templates

An Example Business Case

Note: This business case covers almost all the Supported Data Formats