Generating a report

Generate a report to process the information defined for the report. You can generate multiple reports at one time if you run the report generation program by folder, frequency, process group, or a group of up to 12 individual reports. You can also generate an individual report by report name. A variety of output options are available, including a printed report or a comma-separated value (CSV) file that you can transfer to view with spreadsheet software.

  1. Access Report Generation (RW100).
  2. Generate one or more reports. Use these guidelines to specify the field values:
    Options

    Select the output option that you want for the report. The default setting is Report. See Report output options.

    Period

    You can select a new period where you will create the report. This overrides the period you have selected in Report Writer (RW00.1). If you leave this field blank, then the period you selected in Report Writer (RW00.1) is set as default. If you did not select a period in RW00.1, then the current period for the company is set as default.

    Year Code

    You can select the year code (current, last, next, or report year) where you are creating the report. This overrides the year you may have selected in Report Writer (RW00.1). If you leave this field and the Year field blank, then the year you selected in Report Writer (RW00.1) is set as default.

    Year

    You can specify the fiscal year in which you want to run the report. For example, if the current year is 2000 and you want to retrieve data for 1998, then specify 1998 in this field and Report Writer retrieves the data for that year.

    Folder

    You can select the folder where the report you want to print is stored. If you only generate the report by a folder, then all active reports stored in that folder print. If you leave this field blank, then you must select something in the Frequency, Process Group, or Reports field.

    Frequency and Process Group

    You can generate reports by frequency, by frequency within a process group, or by process group.

    You can indicate a report's frequency on the Options tab on Report Writer (RW00.1). For example, you can run a report one time only, weekly, quarterly, annually, or once a period. The default setting is by period.

    If you leave these fields blank, then you must select a value in the Folder field or Reports fields.

    Reports

    You can select the individual report or reports that you want to generate. You can generate up to 12 different reports at once. If you leave these fields blank, then you must select value in the Folder, Frequency, or Process Group field.

    Statistics Report

    Select whether statistics on the performance of a previously defined report should print. This tells you what kind of data retrievals were done to produce the report.

    List Totals

    Select whether accounting unit list totals is used in processing the report. If you select Yes, then an accounting unit list total is stored for later use. Report Writer checks to see if any posting was done before generating the report. If not, then it uses the stored value instead of calculating a new total. This can be a timesaving procedure when processing.

    Xtra XML

    Select whether to output an Xtra XML file that you can use as a data source with third-party reporting products. If you select Yes, then the system generates two files: reportname.xml and reportname_properties.xml (where reportname is the name of the report that you specified in the Report field).

    Note: If you select Yes, then you must specify a report in the Report field that contains only one format.
    Cache Detail

    Select whether to process the report with cache detail. Selecting Yes enhances report processing performance. If you select Yes, then Report Writer processes the report from a work file rather than the database. This option works best with Style 1 reports.

  3. (Optional) You can define overrides for Style 1 Reports. Select the Style 1 Level Override tab to define company level addresses other than the level addresses selected on Level Ranges (RW00.2). The level address identifies the location of information in the company structure. Select the Level 1 Report Option Override tab to select the report consolidation options other than the report consolidation options defined on the Reporting Options tab of Level Ranges (RW00.2).

Follow-up tasks

  • If you get a Report Incomplete, Skipping Report message, then use Report Writer (RW00.1) to inquire on the report. Verify that you have assigned a row and format to the report. If this is a style 1 report and you are using the chart option (instead of a row), then verify that the Chart option has an asterisk next to it. If not, go into the Chart option and select a parameter. Save the report. The Report Incomplete message should go away.

  • If you get a Skipping this Row ID message, then your row line might reference a format that no longer exists for this report. Using Report Writer (RW00.1), select the Formats tab and verify the number of formats referenced. Then run Detail Report Listing (RW299) and see if any of the row lines are indicating a format number that no longer exists for this report.