Reporting & Querying

This section provides information to the Administrator on reporting options that may, or may not, be granted to users of the system.

Counting Issue Records versus Counting Repeating Row Records

It can sometimes be important to understand the distinction that ExtraView makes between rows on a report and records on a report. This difference in semantics is used to distinguish between the times when ExtraView returns a precise number of records on a report and when it returns a set of rows that may or may not correspond exactly to the number of records.

The difference comes when a query may return a single record multiple times on a report, or count the same record multiple times on the same report. This happens when there are one-to-many relationships within your data. The two most common times this happens are:

  • You prepare a report that uses repeating row records, then use a repeating row field to sort the report. When you use a field on a repeating row record to sort, it will generate a row on the report for each occurrence of the repeating row. Therefore, if you have 3 repeating rows within a single issue, it will generate 3 rows on the report for each record.
  • You use reporting hierarchies. In a similar manner to the above bullet, one record at a level in the hierarchy may have multiple child records, and when you sort by a field at the child level, you will generate one row on the report for each record.