Page 1 of 1

Report Workshop 1.1 - NexusDB demo

Posted: Wed Sep 14, 2016 3:15 pm
by Sergey Tkachenko
Report Workshop 1.1
Report Workshop is a new set of reporting components for Delphi, based on TRichView.
Information about the first release:

Main changes in this update:

impr: format string for floating numbers may specify decimal and thousands separator characters. For example, it is necessary to use dot as a decimal separator if the field is inserted in SQL

Changes in demos:

We added a NexusDB version of the report editor. We also included this demo in compiled demos.
The compiled version of the NexusDB demo: ...

Changes in the installer:

Autodetecting NexusDB package names. NexusDB includes version number in package file names, so package file names are changed on each release.

Previous version

Posted: Wed Sep 14, 2016 3:33 pm
by Sergey Tkachenko
NexusDB demo includes several reports for Northwind database (this database is included in the demo).
This demo uses an embedded version of NexusDB, so additional applications or libraries are not needed.

1. Invoices
This report generates invoices for orders (for all 830 of them), each invoice on a separate page.

2. Cross tabulation, Employees x Employees
The employees table includes "ReportsTo" field specifying a manager for this employee (from the same table).
This report uses these data to build a pivot table based on this information

3. Cross tabulation, Employees x Categories
This is a more typical cross-tab:
- rows: employees (salespersons)
- columns: categories of products
- intersection: sales of products of this category made by this salesperson (for simplicity, we did not take discounts into account in this report)

4. Badges for employees

5. Information about employees
This is an example of 3-level master/detail report: employee / region / territory.
The report shows how to use paragraph numbering in reports.