Skip to content

Single Sheet Options

Using the Single Sheet Option for Report Downloads

Use Case

Learn how to download reports in either a single sheet or multiple sheets in Excel.

Objective

Understand the use of the Single Sheet Option.

Prerequisites

  1. Download the example report: Single_Sheet_Option.zip.

  2. After downloading, add the report to the Report Section of AIV. Follow this link for instructions.

Skill Level Required

No prior knowledge is required.

Export Report with Single Sheet Option

  1. Log in to AIV with your credentials.

  2. Go to Hamburger Menu > Document Section > Report Section.

Image

  1. Click on the report you want to export. For this example, we are exporting the HyperLink report.
  1. Double-click on the HyperLink report. It will open in a new browser window and run the report.

    Image

  2. At the top-left of the report, you will see five options: Parameter Icon, TOC (Table of Content) Icon, Export Report Icon, Export Data Icon, and Print Icon.

  3. Click on the Export Report Icon. The export window will appear as shown below:

    Image

  4. Select XLSX from the Select Module drop-down and All Pages in the Page Range radio button.

    Image

    • Unchecked Single Sheet Option: The report will download in multiple sheets based on the number of pages.
    • Checked Single Sheet Option: The report will download in a single sheet.
  5. Keep the Single Sheet option unchecked.

  6. Click on the submit button. A pop-up window will appear:

    Image

  7. Select the Open with option (or Save File if preferred). Click OK, and the report will open in Excel.

    Image

  8. The report pages will appear in different sheets within Excel. You can navigate through the sheets using the arrows or horizontal dots at the bottom-left of Excel.

    Image

  9. For example, the Hyperlink report has 75 pages, resulting in sheets named Sheet 0 to Sheet 74.

Export Report with Single Sheet Checked

  1. Follow steps 1 to 6 above.

  2. Select XLSX from the Select Module drop-down, choose All Pages in the Page Range radio button, and check the Single Sheet box.

    Image

  3. Click on the submit button. A pop-up window will appear:

    Image

  4. Select the Open with option (or Save File if preferred). Click OK, and the report will open in Excel.

  5. You will see only one sheet, Sheet 0, containing all the pages of the report in a single sheet of Excel.