User:Piggz/KexiHandbook

From KDE Wiki Sandbox
Revision as of 20:37, 4 April 2012 by Piggz (talk | contribs) (Added initial test)

Kexi

Overview

Plugins

Tables

Forms

Reports

Introduction

The Kexi Report plugin allows for the creation of dynamic page-based business reports from data held within the database.

Data can be ordered independently to how it is stored, and the reports can be structured with groups, headers and footers.

Concepts

Many of the concepts are similar to those in similar applications such as Microsoft Access, Oracle Reports and the LibreOffice Report Builder.

Sections

A report contains at least one section, the detail section. This section is repeated for every row in the data set that makes the report. Additional sections can be added to increase the structure of the report, such as group-header, group-footer, report-header, report-footer, and many types of page-header/footer.

Items

Fields in the data set can be represented by Items in the report. An item is added to one of the report sections. Some items do not need to be associated with a data field, such as the Label item, which shows static text.

Scripting

Although many report formats can be created using just the report gui designer, fully dynamic and advanced layouts can be created using code snippets that run on an event based system when the report is rendered.

Extensibility

Sections

Items