Sometimes we are trying to generate a document index by equipment:

This option for SDI Report templates combines the list of equipment units with card metadata in a pivot-style output by doc code.

List of equipment units

On the Index template, in order to include the equipment units, use the variable options from the <Start_AllUnits>/<End_AllUnits> arrays (under the TYPE=CoverPage tab in the XLS Template Variables document).

See below:

Grouping

The parameter GroupBy=FIELD must be included in <Start_AllUnits>.

The available grouping fields are: SupplierLineNumber, CustomerLineNumber, CustomerPoNumber, CustomerPoRevNumber, Model, Tag, ShipDate, Milestone, SubSupplier, CustomX, MajorTagX

For example if you wish to list all units from your equipment list you should use the parameter |GroupBy=SupplierLineNumber. And if you wish to group data from multiple units into a single field (list) output you use the parameter |GroupBy=Tag.

Doc code list and card meta-data

Variables for doc code list and card cross-reference metadata should be included between the arrays <CStart_DocumentCodesCount> / <CEnd_DocumentCodesCount>, which must be placed in a separate column at the start and at the end of the list of variables.

Doc codes

Project doc codes can be listed horizontally using the available DocumentCodesCount variables:

For example, if you wish to show the doc codes and the doc code names the variables should be included in the column header.

Card metadata

Card cross-reference metadata variables can be added using the following format:

<AllUnits.DocCodeCards.<DocumentCodesCount.Index>.*****> (where ***** should be replaced by a cover page variable).

Most variables are supported, but if there are no results, check the list of available variables listed on the TYPE=Index tab in the Pivot Output - Units to Codes section.

If multiple cards match the code to unit matrix, the data will output in a comma separated list for each card.
For example, if 3 cards matched the code and unit and variable is status , the output would be card1.status, card2.status, card3.status.

For example, if you wish to show the card status, the variables should be placed on the same line as the AllUnits variables.

This layout will show the status of each card cross-referenced with each equipment unit.

Job reports

SDI report by tag is available on Job SDI Reports, however the report must be configured to output a single project per worksheet in order for this array to work properly on job reports.