Features

Creating Reports in Report Workshop

Basic reports

To make a simple report, associate a data table with a document, insert some fields in text and run the report generation.
Alternatively, you can associate a data table not with the whole document, but with a report table (grid).

It's as simple as it's shown in this video:

Please enable videos

Master/detail reports, banded reports

To make a master/detail reports, associate a master data query with a larger part of your document, and a detail data query with its fragment.

The list above shows only relations between the closest document layers.
Any layer may be omitted, for example you can build a master/detail relationship between rows of a root report table and a nested report table.

Which data queries can define a master/detail relationship?

There are several possibilities:

the detail query may refer to values of the master query (for example, if SQL is used: “select * from DetailTable where DetailTable.MasterID = {MasterID}”)

if the master query has a dataset field, you can specify it as a detail query (for example, “field:FieldName”)

if data are provided from existing datasets (using a universal DB data provider), they may already have master/detail relation established, and this relation is used by the report automatically

The videos below show how to make master/detail reports using different parts of documents.

Introduction and how to use a document/table relation:

Please enable videos

How to use table row/cell, table/nested table relations:

Please enable videos

How to use rows/subset of rows relation; how to use a cross tabulation to build a master/detail report.

Please enable videos

The detail object can be a master for another, sub-detail object. So you can add sub-detail, sub-sub-detail, and so on, whithout limitations.

There are may be multiple details for the same master.

The video below shows how to build four-level master/detail report having two details at one of levels: