/onestopreporting/help/report-designer/introduction/report-designer-interface-2/osr-excel-ribbon section 2024-08-07T11:22:23+03:00 # One Stop Reporting Excel ribbon The **OneStop Reporting** Excel ribbon is found at the top of the Excel window and provides easy navigation and access to the key functions in the **Report Designer.** | Excel ribbon button | Function | |----|----| |  | Allows you to upload a report to the OneStop Reporting portal. NOTE: Reports are automatically uploaded to the portal when you save. | |  | Opens the Report Configuration dialog box, which allows you to configure the company. | |  | Allows you to input optional additional information, such as the report title and description. Also allows you to enter the password for protected worksheets. | |  | Provides access to report behavior settings, details on the version of Report Designer, and miscellaneous options. | |  | Opens and closes the Designer menu on the left side of the screen, where you find the integrated fields from the ERP system as well as pre-defined period functions. | |  | Opens and closes the Layout Editor window, where you can apply filters, sorting, and grouping for the report. | |  | Enables and disables layout comments that display the filters, groupings, and functions used in the sheet, row, column, or cell level of the report. | |  | Opens and closes the Report Parameters dialog box, where you can manage the properties for the parameters that have been applied to the report definition. | |  | Enables and disables automatic creation of parameters. When disabled, report parameters will not be created unless you explicitly create one using the Report Parameters dialog box. | /onestopreporting/help/report-designer/introduction/report-designer-interface-2/osr-excel-ribbon/options section 2024-07-04T17:39:28+02:00 # Options #### **Options** Clicking the **Options** button opens the **Report Designer Options** dialog box. This dialog contains two tabs: /onestopreporting/help/report-designer/introduction/report-designer-interface-2/osr-excel-ribbon/options/1-the-designer-tab page 2024-08-07T11:22:23+03:00 # 1. Designer tab ## Designer tab  | Option | Function | |----|----| | Always open Report Designer in Run mode | If the checkbox is selected and a saved report is opened, Report Designer will always open with the Run tab active. | | Insert field title above cell on drop | If the checkbox is selected, when a data field is dragged into an Excel sheet, Report Designer will automatically create a title one cell above the data field. The title can be modified or deleted in the cell. | | Show tooltips in modules | If the checkbox is selected, you will get tooltips with extra technical information from the ERP system when hovering over a data item in the Report Designer menu. | | Create Group Dialog | The vertical slider has three settings (Always, Conditionally, and On CTRL). Depending on its position, Report Designer will always, conditionally, or never prompt the user to create a new group when a data field is dragged into the report definition. If the slider is set to On CTRL, OSR Report Designer will never prompt the user and the user must manually create a group by holding the CTRL key while dragging the field.  | | Application | Allows you to select a language for the OSR application using a drop-down list. | | Integration Dictionary | Allows you to select a language for the integration package using a drop-down list. | /onestopreporting/help/report-designer/introduction/report-designer-interface-2/osr-excel-ribbon/options/2-the-application-tab page 2024-08-07T11:22:23+03:00 # 2. Application tab ## Application tab  | Option | Function | |----|----| | Auto-connect | If selected, Report Designer will always connect when Excel is run. However, if the checkbox is cleared, you are required to manually connect Report Designer before designing or running a report. | | Auto-start report | Opening Excel by double-clicking a OneStop Reporting report via Windows Explorer overrides the setting under Auto-connect, and the OSR Report Designer Excel COM add-in starts automatically when Excel is opened. To prevent the OSR Report Designer Excel COM add-in from starting even when Excel is opened by double-clicking a OneStop Reporting report, you must select the Auto-start report checkbox. To prevent the OSR Report Designer Excel COM add-in from starting automatically no matter how Excel is started, both the Auto-connect and the Auto-start report checkboxes must be cleared. | | Sign in automatically | If the checkbox is selected, OSR Report Designer will automatically sign in with the previously logged-on user. | | Portal URL | Shows your OneStop Reporting portal URL. | | Licensed to | Displays the license information. | | About... | Click this button to get information about the Report Designer version, build number and the license information. | /onestopreporting/help/report-designer/introduction/report-designer-interface-2/osr-excel-ribbon/report-properties page 2025-06-13T15:38:13+02:00 # Report Properties The **Report Properties** are available from the OneStop Reporting ribbon in Excel. They can be accessed by clicking the **Report Properties** button. ### General tab You can view and change information, such as, title, description, author, and get information on when the report was created and last modified. ### Protection tab This security property enables you to specify the password used in Excel's built-in protection, so that it allows **Report Designer** to unprotect the workbook as needed. Excel has two different built-in security features: - The first is security on the Excel file level. Users may protect the entire file by requiring password to open and modify the workbook. This type of security does not interact with **Report Designer** and purely restricts who can access the report definition. For more information on security on the file level, refer to the appropriate Microsoft Excel documentation. - The second type of built-in security for Excel is the protect worksheet or protect workbook feature. By using either of these features, users can lock the worksheet cells so that users may not modify the contents of locked cells unless the worksheet or workbook is unprotected. If this feature is used, there is a direct interaction with **Report Designer** reading the protected report definition. Therefore, report designers must provide the password used to lock the worksheet/workbook in the Report Properties -\> Protection tab. Otherwise, the report will not be generated and an error message will be shown. ### Reporting tab The Report properties for **Reporting** are: - **Keep formulas in run report:** - When selected, all formulas are kept when running the report in OneStop Reporting. This allows you to make calculations after the report has been executed in **Reporting**. **NOTE**: This option does not apply to budget templates - When deselected, all formulas in the generated report are removed during processing, and the values are replaced with actual cell values. This option may improve the performance of the report and reduce run time. **NOTE**: The drilldown function works as normal even though the formulas are removed from the report template. - **Replace indirect references**: - When selected, all indirect references, i.e. INDIRECT() are replaced with direct references in order to improve performance in formulas. This does not work for complex reference arguments to INDIRECT. **NOTE**: This option will also affect budget templates. ### Budgeting tab The Report properties for **Budgeting** are: - **Force refresh when opening report in Portal:** - When selected, this property will force a report (or a budget template) instance in the portal to be executed each time the report is opened. - Some conditions that warrant its use would be: - 1\) to ensure the user is working with the latest data within the budget form. If left unchecked, the data in a history item report will display the data the last time the report was executed by that user. - 2\) if budgeting data has been updated since the last time the report/form was executed, the report should be refreshed to show the latest status. **Note**: Checking this property means that the execution will also happen when clicking on a history item (previously run report) in the left menu of the report page in the Portal. You should keep this in mind if reports are heavy and take a long time to run. - **Protect non-input cells:** - When selected, it automatically protects all cells in the budget template that do not have any defined budgeting storage rule. This protection applies when running the budget template in **Budgeting** or **Assignments**, but does not take effect in **Report Designer**. This means that end-users will be prevented from editing other cells than data input cells. - For advanced budgeting templates with a combination of storage rules with cells requiring user input and/or cells with calculated values where input is not required, you will need to use Excel functionality to protect the sheet and unlock input cells. To do this, deselect the automatic OSR protection property. - **Allow Line Item Detail:** The **Budgeting** module allows for specifying line item details of budget transactions. For example, as an administrator, you would like the End-user to specify additional details about travel expenses. To enable this, you need to make sure this option is checked. Read more about [Line Item Detail here](./../../../../../budgeting/report/edit-budget-data/add-line-item-details)