Defining report parameters

Top  Previous  Next

Most reports use a similar report parameter form. It may include breakdowns, filters, sort order, and other options.

 

Breakdowns

The breakdown option is common to analysis reports. Selecting a breakdown defines the columns on your report. For example:

Period breakdown: each column is a time period
Parity breakdown: each column is a parity
Genetics breakdown: each column is a genetic line

 

After choosing the breakdown, you can add a filter.

 

Filters

Filters extract a subset of data. For example:

if you select period breakdown, then add a Parity=1 filter, your columns are periods but only Parity=1 females will be included in the report.
if you select Parity breakdown, then add a Genetics=X filter, your columns will each be a parity, but only GeneticsX females will be included in the report.

 

You can select more than one filter. For example, if you select Parity breakdown, then add a Genetics filter, you must also add a Period filter.

 

The form is divided into two panels. Select the filter option(s) in the left panel and then select the desired option in the right panel.  The parameters for each filter option are combined using the AND operator. In other words, only records that match all defined options will be included in the result.

 

clip0052

 

 

Order

This defines the sort order of the filtered records. Use the combo box to select the primary order variable, and if desired, the secondary order variable. The Descending checkbox forces the order in a descending mode instead of ascending (default)

Display All Variables appears in some reports. Check on this option to add all possible variables in the Sort By boxes if you do not see the one you want.

 

clip0053