59.5.18.9 Product Code

Report Description

Commercial events are associated with particular products; these product categories are user-defined in Configurations/Product Codes. The Product Code report allows you to produce a report of all Nielsen-based or user-defined product codes or, using various search criteria, a limited selection of said codes.

Report Filters

All the parameters that permit a detailed report generation have been spread across seven different tabs to allow a more manageable configuration. By default, all filters are disabled (i.e., either blank or unselected); to enable them, it is enough to configure at least one parameter inside. Available filters include:

•Code

The code area permits, as its name suggests, narrowing the retrieved results by specifying any of the following filters concerning the code field:

- Starts with Enter the string with which product codes must begin to be retrieved in the report (e.g., code like 'test*'),

- Between Insert two values, and only those products whose code is comprehended between them will be retrieved (e.g., code between '500' and '600'),

- Contains: To be retrieved, product code must contain the string inserted here (e.g., code like 'test'),

- It doesn't contain: To be retrieved, product code must NOT contain the string inserted here (e.g., code not like 'test'),

- Empty: Only the empty events will be retrieved (e.g., code = '').

•Description

As with the code, the description field permits the retrieval of only those products whose description field matches (entirely or partially) with the selected filter:

- Starts with Enter the string with which the product's description must begin to be retrieved in the report (e.g., a description like 'test*'),

- Between Insert two values, and only those products whose description is comprehended between them will be retrieved (e.g., the description between '50' and '60'),

- Contains: To be retrieved, the product's description field must contain the string inserted here (e.g., a description like 'test'),

- It doesn't contain: To be retrieved, the products' description must NOT contain the string inserted here (e.g., description not like 'test'),

- Empty: Only those products whose description field is empty will be retrieved (e.g., description = '').

•Sort by

Specify here the field on which the printed content will be ordered. Possible sorting criteria include code and description,

•Properties

This tab permits the customization of the layout of the report by selecting the complementary information that will be displayed on it. You can also decide to include some standard info, such as:

- Print date: Enable it to display the date (and time) in each page footer,

- Pages Number: If active, a progressive number will be displayed in the footer on all pages across the report,

- Operator: It is the login name of the person who performs the report,

- Station name: The name of the station from which the report is being performed,

- Multiple lines text: Enable this option to continue printing a detail in another line instead of truncating it (as by default).

- Interline: Enable this option to increase the space between lines to 1.5 cm (one-and-one-half); by default -when disabled- this space is set to 1 cm (single).

- Columns: It permits to specify the database fields that will be included in the report. The column headers in the top part of the columns window will be displayed as shown in the report. It is possible to arrange them just by using drag and drop.

Display Active Filters

In the middle of the form, a summarizing list will be displayed containing all the filters enabled for the current report:
3724_Display_Active_Filters

Report Preview

The [Settings] permits configuring the page layout of the outgoing document; once filters and settings have been set, it will be possible to select between displaying a preview using the related [Preview] button or printing the document directly using the [Report] button. Please note that some reports permit to export the generated document in the most common formats (pdf, CSV, doc, xls, XML, etc) just by using the [Export] button.
Product_Code