Calc ooReport for .Net is a library, designed for report generation from any data sources in OpenOffice.org Calc. This library was written in Ñ#, and can be used in any programs for .Net. It differs from the Band-oriented report generating programs by the fact that it doesn't use such concepts as Footer, Header, and Detail. The whole process of report creation consists of two simple operations: pointing out data sources, necessary for the report creation (choosing data from different databases), and creating a book-template in the OpenOffice.org Calc (ODS-template).
ODS-template contains:
- Description of the report form
- Book options
- Sheet options
- Report separate areas options
There are some specially pointed out areas in the template, where (at creating the report) the data will be put. When the report execution process is started, library Calc ooReport for .Net will load a template, fill in marked beforehand cells by the data from the pointed out sources and will show OpenOffice.org Calc on the screen. After this you can either print the report or save it on the disk as an .ods-file for the further work or analysis.
|
Features:
- The library was written in C# and is designed for work in .Net environment;
- The library interacts with OpenOffice.org Calc spreadsheet;
- Report templates are created in OpenOffice.org Calc and saved in ODS-format;
- After generation, the report is displayed in OpenOffice.org Calc;
- Immediately after creation the report can be printed or saved into file;
- Report can be saved in PDF-format;
- Report can be created based on parameters;
- Visual design of the report can be adjusted;
- Report data can be grouped as well as sorted in ascending or descending order;
- With Range-dataset, you can use OpenOffice.org Calc formulas for referencing range cells as well as cells outside of the range;
- You can get totals for a column of a list range by specifying appropriate option in the column option cell. Calc ooReport for .Net supports the following totals types:
- SUM - the sum of values in a column;
- COUNT - the number of items in a column;
- COUNTNUMS - the number of column cells that contain numeric data;
- AVG - the average of values in a column;
- MAX - the largest value in a column;
- MIN - the smallest value in a column;
- PRODUCT - the result of multiplying all values in a column;
- STDEV - an estimate of the standard population deviation, where the column is a sample;
- STDEVP - a standard population deviation, where the column is the entire population;
- VAR - an estimate of population variance, where the column is a sample;
- VARP - the population variance, where the column is the entire population;
- All totaling options can be used together with "Group" option. Specify "Group" option in the option cells of columns, where you want to get subtotals.
|
Calc ooReport for .Net
back to the Calc ooReport for .Net Main page
