Categories

Select which data to use on the report. The left pane shows the data categories you can access. To see the fields in a category, select it, then click the Information  icon.

What are data categories?

Data categories are tables of data, which are organized by rows, and by columns, also known as data fields. A row of data has entries for one or more columns in the category. When you add a data field onto a report you are seeing the information in one column of data for every row in the category.

For example, an data category for employees could have columns for the first and last names of each employee, an identification number, and their home phone number. Each row represents a person, and each column represents some information about that person.

Example of a data category for employee records

You add entire categories at a time, but you can select which columns you want to see in the actual report. When you add a data field in the report layout, you are selecting one column of data, in the hopes that you can do some interesting analysis on that series of values. When you add a data field, even though you only see one column, all the rest of the table is still present behind the scenes. You will never lose the connections between items in each row, and you can always pull in more fields later on.

Adding categories

On the Categories page, add data categories to the report. Later on, you can select which fields you actually want to see in the report layout.

As you add categories, unrelated categories will become unavailable. If you are interested in learning why, read the following section. If not, you can skip to Sorts.

Relationships between categories (for advanced users)

In the data source, data categories are joined to other data categories by associating uniquely identifying data fields from one category to matching data fields in another. This means that if a row's identifying field matches one or more rows in a joined data source, then those rows connect to an entire row or series of rows, which have their own separate data fields.

Note. If you know that rows in a category join to more than one row in another category, you can select Suppress Duplicates for the first category to ensure that rows are not duplicated for every joined row.

Only joined data categories, which are described as having a relation, can be added to the same report. This is why some categories may become unavailable as you add others. But data categories, even if they are not related to each other, may both be related to another category. If you add that category, then you can add both those categories, because there is now a join path between them.

Caution. If you add too many data categories, you may end up with a bunch of empty rows on your report. When you try to add fields which are too disconnected from each other, you are joining through several categories with their own sets of rows. You are not seeing the data in those rows if you do not add the fields, but they are present regardless. Try to find the shortest join path possible, or otherwise, see if there is a substitute for the field you want.

For more information on how categories are related to each other, see Joins.