FR View

The FR View command is part of the Financial Statement Designer. You use it to test financial statement specifications.

FR View is on the FR Menu in the Financial Statement Designer (Excel).

When you select FR View, it displays a dialog box from which you can choose various report generation options.

For information on report generation options, select one of the keywords listed below:

 

Fiscal Option

Report Type

Report As

Include

Sort by

Select Accounts

Differences between printing with FR View and printing from the Print Financial Statements icon

The FR View print form is not identical to the Financial Statements form which appears when you choose the Print Financial Statements icon.

The FR View differences are as follows:

• You can generate an audit information page, account audit information, and include drilldown information in the first column of the report. (See Include.)

The audit information page lists information such as the print ranges and any specified processing order.

• You can generate formulas for each value that appears in the report range instead of the values themselves. (See Include.)

This lets you create a report that you can update simply by recalculating the spreadsheet. (Note that spreadsheet formulas make the spreadsheet a lot larger.)

• If you create a series of reports by choosing the Separate button, each report will be created in a separate worksheet in the Excel workbook. The worksheet names will reflect the segment IDs for each separate report.

When you print a set of statements using the Print Financial Statements icon, the program repeats the report generation process for each account segment. In the Report Designer, you can view all generated reports.

Keep financial ratios and graphs in a formula sheet

There are two main advantages of a report that is composed only of formulas:

1. The report has the same cell references each time you use it.

2. The report area remains intact when you recalculate the report. (If you generate a report from a specification, the old report is cleared before the new one is generated.)

Because the spreadsheet remains the same each time you use it, you can include graphs in your reports and be sure of the data you are referencing.

The most common type of "formula-only" report is one that keeps financial ratios.

 

See also

 

Printing to a File

Print Preview Command

Grid Lines, Tab Breaks and Other Report Formatting

Copying and pasting text and DDE links

Include (for information on creating "hot-linked" spreadsheets)

Saving Spreadsheets Under Different Names and File Formats

If nothing happens when you choose OK . . .

Troubleshooting

Printing Optional Fields in Financial Reports