Report output differences

Taking a 1-level report on DoDAF2 Need Lines and their source and target performers through subreports which then identify related items:

HTML reports

A structure is produced as shown in this figure.

Grid reports without interleaving

This produces a similar structure while duplicating data where appropriate, like this:

Items produced:

Level 1 Level 2
x a
b

We want:

Level 1 Level 2
x a
x b

Items produced:

Level 1 Subreport started from Level 1
x a
b

We want:

Level 1 Subreport
x a
x b

Items produced:

Level 1 Level 2 Subreport started from Level 1
x a 1
b

We want:

Level 1 Level 2 Subreport
x a 1
x b

Items produced:

Level 1 Level 2 Subreport started from Level 1
x a 1
b 2
3

We want:

Level 1 Level 2 Subreport started from Level 1
x a 1
x b 2
x 3

(Because the subreport data is not related to the level-2 data, it is incorrect to duplicate that.)

The reason for doing this is to give a complete table of data if required and so that the ‘merge cells’ button can be used to identify groupings.

Grid reports with interleaving

There is an Interleave subreport output checkbox in the editor dialog for grid reports. This produces SETTING { INTERLEAVING } in the report script.

The setting for the main report executed dictates the behavior.

This produces a join of subreport output with the parent levels. Sequence of subreports and levels dictates data interleave pattern.

This works for subreports started from the same and from different levels of the main report and from subreports.

Example output:

Main Subreport
x 1
y 2

Produces:

Main Subreport
x 1
x 2
y 1
y 2

Each additional subreport must be processed in the same manner:

Main Subreport 1 Subreport 2
x 1 a
y 2 b

Produces:

Main Subreport 1 Subreport 2
x 1 a
x 1 b
x 2 a
x 2 b
y 1 a
y 1 b
y 2 a
y 2 b

The example report produces the following output:

This is the same output after merging cells: