Calc ooReport for .Net 2009.1

Calc ooReport for .Net 2009.1 is a MS Visual Studio 2005/2008 library designed for report generation in OpenOffice.org Calc using Automation. With Calc ooReport for .Net, OpenOffice.org Calc can be an integral part of your application. As a report building and data analysis tool, OpenOffice.org Calc is an excellent alternative to common report generators, and using OpenOffice.org Calc's built-in features can make your reports much more responsive.

With Calc ooReport for .Net, you can move a lot of report programming and tuning into Calc ooReport for .Net. Calc ooReport for .Net templates are simple andalgorithms are fast so you waste less time on routine report programming and get surprisingly fast results. If you want to master such a versatile tool as OpenOffice.org Calc – Calc ooReport for .Net is an excellent choice.

Furthermore, Calc ooReport for .Net doesn’t operate with the usual concepts of band-oriented report tools: Footer, Header, and Detail. So you get a much greater degree of freedom in report construction and design, and the easiest possible integration of MS Visual Studio 2005/2008 and OpenOffice.org Calc. And finally. Calc ooReport for .Net works with classes DataSource, DataTable and DataView.

Calc ooReport for .Net is  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.

Major Features:

1. The library was written in C# and is designed for work in .Net environment;
2. The library interacts with OpenOffice.org Calc spreadsheet;
3. Report templates are created in OpenOffice.org Calc and saved in ODS-format;
4. After generation, the report is displayed in OpenOffice.org Calc;
5. Immediately after creation the report can be printed or saved into file;
6. Report can be saved in PDF-format;
7. Report can be created based on parameters;
8. Visual design of the report can be adjusted;
9. Report data can be grouped as well as sorted in ascending or descending order;
10. With Range-dataset, you can use OpenOffice.org Calc formulas for referencing range cells as well as cells outside of the range;
11. 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;
12. 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.