Overview - What is a Report Definition?
A Report Definition allows you to define the contents of each individual line on a report and to determine the sequence in which these lines appear.
Using a report definition also allows you to Explode the level of detail for each line in your report. For example, in a report where each line represents part of P&L you can explode each line to show details by cost centre or account.
Report Definitions can be used in many areas of IFP including Reporting, Advanced Reporting, Graphing, Forecasting and Cost of Sales Analysis. For example, you may use report definitions to define templates for data entry in forecast editors.
Reports without a Report Definition
Each database contains a basic hierarchy that provides reports with automatic sub-totalling at each level of that hierarchy.
The SalesCOGSDemo database has the following hierarchy:
- Therapy Group
- Product Group
- Item Code
For this database a report run at item code level of detail will, by default, include sub-totals for each Product Group, Therapy Group and BU. Rows in the report below show each product group within the Division Women's Health.
Reports with a Report Definition
However, many management reports require sub-totalling that does not follow this basic hierarchy. For example, a key products report may require a selected set of products to be listed in a specified sequence. Report Definitions may be used to define each line in reports and graphs independently of the basic hierarchy.
In order to tailor reports to produce such features, you may create report definitions that determine the contents, format and description of each line of each report for which that definition file is used. Report definitions are maintained using the Report Definition Editor and may be used in any report or graph. See Creating Reports.
In the following report, lines have been defined for each of the top 5 product groups followed by a total of these 5 products and a percentage share of total sales.