Share via


Report tab settings

In the Report tab of a report definition, you specify the row definition, column definition, and optional reporting tree definition to use to build a report.

You can also define additional aspects of the definitions, such as multicurrency translation, detail level and report date, and the company information. This topic contains the following sections about the information in this tab.

Select company name or code

Select report detail level

Specify a provisional code

Currency information

Specify report periods and dates

Specify report building blocks

Select company name or code

Management Reporter uses the accounting calendar information for a legal entity or company, such as fiscal year and fiscal periods, to generate a report. You can have multiple companies defined in Management Reporter. If you select the company code @ANY, the default company is used to generate reports.

Specify a company name

  1. In Report Designer, open the report definition to modify.

  2. Click the Report tab.

  3. In the Company name field, select the company to use for the report, or select @ANY to generate a report using the default company. Only companies to which you have access are shown.

Note

If you are not logged on to the company, the Connect to dialog box opens. Enter a user name and password, and then click OK to log on to the company.

Select report detail level

When you select a detail level in a report definition, the Report tab information does not change. However, the option that you select affects which options are available on the Print and Export windows.

You can specify the following levels of detail in a report in the report definition. To print the transaction-related details for an FD column, you must have a PERIODIC column.

Detail level

Description

Financial

A high-level summary report. You cannot drill down to accounts and dimensions, except for those added through a reporting tree.

Financial & Account

A report that contains a high-level summary and account details.

Financial, Account & Transaction

A report that contains a high-level summary with account, and transaction details.

Specify a report detail level

  1. In Report Designer, open the report definition to modify. Click the Report tab.

  2. In the Detail level field, select the level of report detail.

Examples of report detail level

The following examples show Management Reporter reports and Print windows when the Financial and Financial & Account detail levels are selected.

Note

Print options are for the Report Viewer only.

Financial detail level example

The following report shows the high-level financial detail that is generated when you select the Financial detail level option.

Report detail level screen shot for Financial

The following screenshot shows the options that are selected when you open the Print window for a Financial level report.

Report detail level screen shot for printing1

Financial & Account detail level example

This option is similar to Financial but also provides a summary view. The following report is generated when the Financial & Account detail option is selected.

Report detail level screen shot report

The following screenshot shows the options selected when you open the Print window for a report with Financial & Account details.

Report detail level screen shot printing2

Specify a provisional code

The provisional reporting codes in a report definition determine whether posted, unposted, or both posted and unposted financial data transactions are included in the report. Posted transactions include activity from every module, for example, Accounts receivable or Accounts payable, that creates an unposted journal entry in the General ledger module of the Microsoft Dynamics ERP system.

Note

Not all data providers support unposted transactions. For more information, see the data integration guide for your Microsoft Dynamics ERP system.

Specify a provisional code

  1. In Report Designer, open the report definition to modify. Click the Report tab.

  2. In the Provisional field, select the provisional code to use in the report. For a description of the provisional codes, see the following table.

Provisional codes

Code

Description

Posted activity only

Includes only the transactions and balances that are posted in your financial data.

Posted and unposted activity

Includes all of the transactions and balances that are entered and posted in your financial data.

Unposted activity only

Includes only the transactions that are entered, but not yet posted, in your financial data.

Currency information

This section indicates the currency that will be displayed in the report. If other currencies are configured in your Microsoft Dynamics ERP system, you can select the Include all reporting currencies check box for additional reports to be generated in the currencies listed. For more information about the procedures for multicurrency translation, see Translate report currency.

Specify report periods and dates

You can indicate the base period, base year, and period covered date for a report in the report definition. For definitions of the period and date fields, see Period and date options.

Date information in the report definition is related to the default base period. For definitions of the default base period options, see Default Base Period options.

By default, a new report definition displays the code S-1. The S codes are related to the system date on the computer. Therefore, using S-1 as the default base period, displays a report date as of the last day of the last period defined in the system calendar. Many users save the S-1 setting for their reports so that they report on the prior month’s activity by default.

Another option available for the default date is CUR, or the C codes. These options are related to the current active period in the source system.

The final option is to hardcode a specific period as the default period. In this option, the reporting year is synchronized with the source system.

Date information that is saved with the report definition can be overridden when the report definition is open. This lets users generate the report for a different time frame without changing the default base period. The following date information is not saved with the report definition:

  • Base period – The date is displayed with regard to the default base period. To override the default base period, select a period .

  • Base year – The date is the same as the base period, except years are displayed.

  • Period covered – By default, the Month or Months Ending text is used with date-related header codes. The period covered text can be modified in the Entity dialog box.

Specify report periods and dates

  1. In Report Designer, open the report definition to modify. Click the Report tab.

  2. In the Base period field, select the base period to use for the report. The period appears in the Period covered field.

  3. In the Base year field, select the fiscal year to use for the report. The combination of the Base period and Base year appears in the Report date field.

  4. In the Default base period field, select a default base period or type a default base period. For example, to specify the base period as five periods before the current financial data period, type C-5.

Period and date options

The following table describes the period and date options.

Option

Description

Base period

Determines the initial setting in the Base Period field.

Changes to the base period are not saved with the report definition. To save the base period, assign a default base period in the Default Base Period field.

Although you can type period numbers in the column definition, a column definition typically refers to the base period that you specify in the report definition. In the column definition, you typically set the period relative to the base period, and then define the specific period in the report definition. If you enter a specific period number in the column definition, that number overrides the base period setting.

Base year

Specifies the fiscal year to use for the report. Changes to the base year are for the current report and are not saved with the report definition. For more information, see the Default Base Period options.

Period covered

Combines the base period with the Period Description or Plural Description that is specified in the Modify Company dialog box. A plural description is used for multiple periods. For information about company information settings, see Set up company information (data provider).

By default, the description in the Period covered field appears in the report headers. Use the @PeriodCoverage and @PeriodCoverage@DateLong codes in the Headers and Footers tab to include the Period Covered description in your report.

Report date

Combines the Base period and Base year fields. By default, the report date appears in the report headers.

Default base period

Determines the initial settings for the Base Year and Base Period. This is the only setting that is saved with the report definition.

Default Base Period options

The Default Base Period setting determines the initial settings for the Base Year and Base Period. This is the only setting that is saved with the report definition.

The following table describes the default base periods.

Default Period

Description

SYS

Base period is the current system period.

S-1

Base period is one period before the current system period.

S-2

Base period is two periods before the current system period.

S+1

Base period is one period after the current system period.

CUR

Base period is the current processing period specified in the financial data.

C-1

Base period is one period before the current financial data period.

C-2

Base period is two periods before the current financial data period.

C+1

Base period is one period after the current financial data period.

01

Acceptable values for the Default base period field are based on the configuration of the Microsoft Dynamics ERP system. For example, to use a calendar year with 12 months, you can type 01 for January and 12 for December.

Specify report building blocks

Report definitions use the row definition, column definition, and reporting tree building blocks to help define the content of a report. You can also use a reporting tree to display information related to a dimension that is not used in the rows or columns of the design. For a description of the building blocks, see Building block settings.

Depending on the type of report that you are creating, you might have to modify your row definition and column definition to display the report detail accurately. For example, you might have to adjust the rounding precision on your balance sheets. For more information, see the “Specify rounding options in a report definition” section in Settings tab settings.

Select report building blocks

  1. In Report Designer, open the report definition to modify. Click the Report tab.

  2. In the Building blocks section, in the Row field, select a row definition. To verify that you selected the correct row definition, click Open Row to open it. Then close the row definition to return to the Report tab of the report definition.

  3. If you created a report design that requires row formatting from a reporting tree, select the Use row definition from reporting tree check box.

  4. In the Column field, select a column definition. To verify that you selected the correct column definition, click Open Column to open it. Then close the column definition to return to the Report tab of the report definition.

  5. To use a reporting tree, in the Tree type field, select the structure of the reporting tree. When the Tree field is displayed, select the reporting tree definition. To verify that you selected the correct reporting tree definition, click Open Reporting Tree to open it. Then close the reporting tree definition to return to the Report tab of the report definition.

  6. To specify a starting unit in the reporting tree, click Browse to open the Starting Unit dialog box. Select a starting reporting unit, and then click OK.

  7. To generate a report for the whole reporting tree, leave the Starting Unit field empty, or select None in the Starting Unit dialog box.

Building block settings

The following table describes the settings available under the Building block area of the Report tab in the report definition.

Setting

Description

Row

Specifies the row definition for the report. For more information about row definitions, see Row definition.

Use row definition from reporting tree

If the reporting tree specifies the row definition to use in the report, select this check box. If you do not select this check box, the row definition that you selected in the Row field for every unit in the reporting tree is used.

NoteNote
This is required only if you are using multiple links to FD in the row definition and with some methods of linking to external worksheets. For most reports, you do not have to select this check box.

For more information about reporting trees and how to assign a row definition in the reporting tree, see the “Reporting unit structure” section in Manage reporting units.

Column

Specifies the column definition to use in the report. For more information about column definitions, see Column definition.

Tree type

Specifies the structure of tree. Possible values are as follows:

  • Reporting tree – A hierarchy derived from available dimensions in the financial data.

  • Dimension hierarchy – A hierarchy in a dimension-based system that is not bound to a single segment.

  • None – Clears the Tree type setting.

Tree

Specifies the reporting tree definition to use in the report.

Starting unit

Specifies a subsection of the reporting tree definition to use in the report. The Starting unit limits which branches of the tree appear when you generate the report. Click Browse to open the Starting Unit dialog box and search for the starting unit. To run the report for the complete tree, in the Starting Unit dialog box, click None.

See Also

Report definition