Introduction

MonoReport is a platform for creating reports in spreadsheet formats (Microsoft Excel or OpenOffice Calc). MonoReport requires Microsoft Excel or OpenOffice Calc installed.
"FogSoft.MonoReport" is an assembly name of MonoReport. It uses the following libraries:

  • FogSoft.MonoReport
  • FogSoft.Infrastructure.Utils
  • log4net
  • Microsoft.Excel

Report

Report is an Microsoft Excel or OpenOffice Calc document - the result of MonoReport work.
Report generation requires:

  • report template,
  • data set filled with the data for the report.

Report template is an Microsoft Excel or OpenOffice Calc document. It contains mark-up and structure for the report.
DataSet is a set of tables that contains data for the report and metadata that will be used for report generation.
You could use data context as alternative data provider for the report. See detailed description below in the section Data Context.

DataSet for Report

To generate report you need to pass data set (object with type System.Data.DataSet) with the data for the report to MonoReport.

Data Context

Data context can be used besides dataset to supply data for the report. Data context organized as a dictionary. Dictionary contains pair - key and value. Key is used for mark-up in the template and value will be displayed in marked up cell after report generation. To output data from data context, mark row with table[0]. Next, in the marked row put into the required cell string key that corresponds to the data in the data context.