Share via


Generate a report

After you create a report in Management Reporter, you can generate it to various locations in the report library or a SharePoint site, or share it with others using Microsoft Excel or XPS.

To generate a report, open the report definition and then click the Generate button in the toolbar. The Report Queue Status window will open and indicate the location of your report in the queue. By default, the generated report will open in the Web Viewer.

Note

You can generate reports only to folders and locations to which you have permission to access in Management Reporter.

The following table explains the options that are available for generating reports.

Option

For more information

Use a link location in the report definition to share a generated report to a SharePoint site or network location

Use a link location and Advantages of using a link location

In Desktop Viewer, generate reports as a Microsoft Excel spreadsheet or XPS file

Output options

Set up a schedule to generate a report or group of reports automatically

Schedule reports

Check for missing accounts or data in a report, and validate the accuracy of a report

Missing account analysis feature

When you generate a report, Management Reporter uses the options that you have specified on the Report definition tabs. The Output and Distribution tab lets you specify a report library location and a link location for your report, which provides an easy way to share the report.

Although you can manage the structure and security of your reports in the report library, managing your reports in SharePoint or a network link location offers some advantages.

  • Discoverability – When information is in the same location and logically organized, less time is wasted on searching. For example, you can organize your reports according to your company’s fiscal year by creating a folder in SharePoint with the current year in the name of the title. Within that folder, you can have a separate folder for each month or quarter.

  • Ease of access – When a user opens the report from a link location, it is automatically displayed in the Web Viewer. The user can also add comments and create charts for easy communication with coworkers or for creating presentations. You can share reports by sending a link via email. For more information about ways to share reports, see the “Share a report” section in Desktop Viewer.

  • Security – Security can be managed through Report Designer by generating a report that has personalized levels of access or by restricting access to the folders in the link location. The Web Viewer also offers security options. You can filter data for individual units of a reporting tree, so only users who have permissions can view specific data. For more information about report security, see Set up security.

By default, when you generate a report, it will open in the Web Viewer.

Output options

On the Output and Distribution tab, you can specify whether you want your report to open as a Microsoft Excel spreadsheet or in XPS file format. For more information, see Output and Distribution tab settings.

Schedule report generation

Many companies have a core set of reports that are run at scheduled intervals to align with their business processes. You can schedule a report to be generated regularly, such as daily, weekly, monthly, or annually. This can be a single report or a group of reports that includes multiple companies. You must enter your credentials for each of the companies that are specified, such as those in a reporting tree definition. If the credentials are not valid, the report will display only the information that you have permission to access, such as the company that you are logged on to at the time. Output information is read first from the report group, and then from the individual reports.

As report schedules are created and saved, they are displayed in the navigation pane under Report Schedules. You can create folders to organize the reports.

If a single report in a schedule does not run, all other reports will continue to run.

Important

To create, modify, and delete report schedules, you must have the role of designer or administrator. When a report is run, the credentials of the user who created the schedule are used to generate the report.

Create a report schedule

  1. In Report Designer, on the File menu, click New, and then select Report schedule. The New Report Schedule dialog box opens.

  2. Under Settings, select an individual report or a report group to schedule. Only reports or report groups for the company or building block selection that you are currently logged on to are available.

  3. Select the Active check box to turn on the report schedule. Only the creator of the report or an administrator can activate or inactivate a report schedule.

  4. Click the Permissions button to enter company credentials. By default, your logon information is used for the company that you are logged on to. If other companies are included, such as in reporting tree definitions, select Use separate credentials, and then enter the credentials for any other company that is included in the report schedule. You can select Windows Authentication or type a user name and password for each company. Select the Save credentials check box to save the credentials for these companies, and then click OK to close the dialog box. For more information about how to enter and save credentials, see Credentials and report schedules.

  5. Under Frequency, in the Start recurrence field, select the date when the schedule is to start. By default, the current system date of the client computer is selected.

  6. In the Run report at field, select the time when the report should run. If you enter a time that is before the current system time, the report runs on the next scheduled date.

  7. In the Recurrence pattern area, specify how often the report is run. By default, Daily is selected with an Interval (days) value of 1. Other options include Weekly, Monthly, and Yearly.

  8. In the Range of recurrence area, select when the report should stop being generated.

    • No end date – The report schedule runs indefinitely.

    • Set number of occurrences – The report schedule runs for the specified number of times, and then is inactivated.

    • End by – The report schedule ends on the specified date.

  9. Click Save in the toolbar. In the Save As dialog box, enter a unique name and description for the report schedule.

To copy a report schedule, you must have the role of designer or administrator. Even if an administrator modifies the report schedule, the report maintains the credentials of the user who created the report.

Copy a report schedule

  1. In Report Designer, click Report Schedules in the navigation pane, and open a report schedule to copy.

  2. On the File menu, click Save As, and then enter a new name and description for the schedule in the Save As dialog box. Click OK, and the new schedule is displayed in the navigation pane.

  3. In the new schedule, modify the fields and information as needed, and then click Save on the toolbar, or click Save on the File menu.

To delete a report schedule, you must be the owner of the report schedule or have a role of administrator.

Delete a report schedule

  1. In Report Designer, click Report Schedules in the navigation pane.

  2. Select the report schedule to delete, and then click Delete or press the Delete key.

  3. In the deletion verification dialog box, click Yes to permanently delete the report schedule. If you do not have permission to delete the schedule, a message is displayed and the report is not deleted.

Credentials and report schedules

If you do not enter credentials that are required for all companies included in the reports, you receive the following message when you save the report schedule: “You must enter your credentials for the companies that are contained in this report schedule. Select the Permissions button to enter in your credentials.”

For example, Phyllis logs on to Company A using her logon and password. She creates a schedule for a report that uses a reporting tree definition to collect data from multiple companies. When this report schedule is saved, Phyllis is prompted to enter the credentials for the other companies that are specified in the reporting tree definition.

When your credentials expire, the affected reports in the report schedule are not generated until the credentials have been updated. A message is displayed in the report queue to indicate that permissions must be updated.

The report schedule fails if any of the following scenarios occur (because they require credentials):

  • A new company has been added to a report tree for an individual report.

  • A report in a report group has been modified.

  • A new report for an additional company has been added to a report group.

To continue, click the Permissions button in the Report Scheduling dialog box, and then enter the appropriate credentials.

Missing account analysis feature

You can search for financial accounts and dimensions that might be missing across all row definitions, reporting tree definitions, and report definitions in a building block group. This is useful when you create or update several account or building blocks during a short time period, and you want to verify that all new information is included in your reports.

Management Reporter determines missing accounts by using the lowest and highest values from the row definition or reporting tree definition, and then displays a list of accounts that are not in the row definition or reporting tree definition, but that are in the financial data. If a missing account is greater than or less than the values in the row definition, that account is not included in the list of missing accounts.

Tip

For validation purposes, this process should be run before you generate monthly reports and when you create new building blocks.

Reports that have ranges of values are less likely to have missing accounts. When possible, use ranges in the building block to include new accounts when they are created.

To select the option to generate a report that indicates duplicate accounts, see the “Report options” section in Output and Distribution tab settings.

If any report definition is set to @ANY company, then you can log on to a specific company and run a missing account analysis for that company.

Note

If a new company has been added in Management Reporter, you must add the new company to the reporting trees in any existing reports or the company will not be included in the missing account analysis.

Run missing account analysis

  1. In Report Designer, click Tools, and then click Missing Account Analysis.

  2. In the Company filter field, select a company to filter results on, or select All (no filter) to display results from all available companies.

  3. In the Dimension filter field, select a dimension to filter results on, or select All (no filter) to view all dimension information for all available dimensions.

  4. In the Group by field, select an option for sorting the results. You can sort results according to the building block that is affected, or you can sort results by dimension and value sets.

  5. Review the displayed results. When you select an item in the upper pane, the lower pane displays additional information about the exception. This includes related dimensions, values, and reports.

  6. To open the affected item, click the associated icon that is displayed in the list pane, or right-click the item and select Open. To select multiple items, hold down the Ctrl key while you select the items in the lower pane.

  7. If any values, building blocks, or reports are returned that should not be included in the analysis, right-click the item and select Exclude, or select the Exclude check box next to the item to remove the item from the list. Excluded items are not included when the list is refreshed. To select multiple items, hold down the Ctrl key while you select the items in the lower pane.

    To view all items, including any results that you previously selected to exclude from the analysis, select the Show excluded building blocks and values check box, and then click Refresh.

  8. Click Refresh to refresh exceptions that you have addressed. Click Yes to perform a full refresh of all of the results, or click No to perform a partial refresh of addressed items.

    Note

    The form is automatically refreshed when it opens, unless the form has been opened in the last 15 minutes.

  9. When the issues are resolved, click OK to close the dialog box.

Keyboard shortcuts for missing account analysis

When you run a missing account analysis in Management Reporter, the following keyboard shortcuts are available.

To do this

Use this keyboard shortcut

Filter by company

Alt+C

Filter by dimension

Alt+D

Select the Group by field

Alt+G

Show excluded blocks and values

Alt+S

Refresh results

Alt+R

Exclude the selected building block

Alt+X

Exclude the selected row definition

Ctrl+B

Exclude the selected dimension value

Ctrl+D

Open the selected report definition

Ctrl+R

Open the selected row definition

Ctrl+O

For more information about keyboard shortcuts in Management Reporter, see Accessibility features in Management Reporter.

See Also

Schedule reports

Output and Distribution tab settings