Skip to content
AIV

Single Sheet Options

AIV allows users to download Excel reports in different formats based on their needs. The Single Sheet Option provides flexibility by letting you choose whether the entire report should appear in a single sheet or be divided into multiple sheets. This feature is particularly useful when handling large datasets or when you want a consolidated view for analysis.

Objective

Understand how to use the Single Sheet Option during report downloads.

Prerequisites

  1. For this example, the report used is Orders Payment.rptdesign.

  2. Download the required sample files from the link singlesheetoption.zip

  3. Upload Orders Payment.rptdesign to the Report Section under the Root folder.

  4. Refer to this link for detailed steps on uploading files in the application.

Export Report with Single Sheet Checked

  1. Go to Hamburger Create icon icon > Documents > Report.

  2. Double-click the Orders Payment.rptdesign report. It will open in a new browser tab and automatically run the report.

  1. 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.

    Image

  2. Click on the Create icon icon. The export window will appear, as shown below:

    Image

  3. In Export Report dialog box:

    • Select XLSX from the dropdown

    • Under Page Range, choose All Pages.

    • Enable the Single Sheet option (Checked).

      Image

  4. As soon as you click Create icon button, the file will begin downloading in XLSX format.

    Image

  5. You will see only one sheet, Sheet0, containing all the pages of the report combined into a single Excel sheet.

Export Report with Single Sheet Unchecked

  1. Follow steps 1 to 4 above, as they are the same as for the checked option.

  2. In Export Report dialog box:

    • Select XLSX from the dropdown

    • Under Page Range, choose All Pages.

    • Keep the Single Sheet option unchecked.

      Image

  3. As soon as you click Create icon button, the file will begin downloading in XLSX format.

    Image

  4. The report pages will appear in separate sheets within Excel. For example, if the Orders Payment.rptdesign report has 6 pages, the file will contain sheets named Sheet0 to Sheet5. You can navigate through these sheets using the arrows or the horizontal dots at the bottom-left of the Excel window.