Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Reports

Format

You can use the
Format
 functionality to control how reports appear. This helps you create and review reports that are easy to review.
Options
Notes
Freeze
To activate the freeze panes functionality, select
Freeze
 and lock the headers for the area in the report that you want to review.
  • You can select a cell and the screen locks. Then, you can scroll to the right and down and the page shows only the data that you want to view.
  • To designate a fixed number of rows to appear across the top and lock column headers to the left, select
    Freeze
    . The data appears as you scroll to the right and down the page.
Unfreeze
Select Unfreeze to unfreeze panes.
Column Size
To modify the column size or hide columns, drag them to the left. When running a report, only the data you view on the page prints in the report.
Contract All (Expand All) lines
Select Contract All or
Expand All
 to see more or less lines of detail in a report. Depending on the report, line items are grouped together in the report. This lets you make a report smaller for printing. The report will print the line items as they appear on the page. For example, if you have expanded permanent differences, then all permanent differences will print while the contracted line items will print only that line.
Grid Lines
Shows a grid view and has an Excel-like grid look and feel. To expand the column width click on the line and use the cross-hairs to drag the column just as you would do in Excel. The grid lines will print when you run the report.
Highlighting the Row/Column
Select
Highlighting
 to identify a row and column. Highlighting provides a visual marker helping you see where you are as you scroll across the report. You can click on the row or column and drag your mouse to highlight the cells to review specific data.
Alternate colors for every other row
Select
Alternate Colors
 and the rows in the report will have alternating colors making it easier to review your the data. Every other row will have a gray background.

This article applies to:

  • PRODUCT: ONESOURCE Tax Provision