---
title: "Designing reports"
description: "Use Report Designer in Excel to build and customize your own reports."
lang: en
languages:
  en: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/index.md
  no: https://docs.vismasoftware.no/no/onestopreporting/create-templates/report-designer/creating-reports/index.md
lastmod: 2026-07-21
---

> Documentation index: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/llms.txt


# Designing reports

Last modified July 21, 2026

> Use Report Designer in Excel to build and customize your own reports.

Combine Excel's power with live data to build professional reports that automatically update with the latest figures from your system.


---

[View this page](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/)


## In this section


- [Report building options](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/report-building-options/index.md): Choose between starting from scratch, duplicating templates, or uploading your own.

- [Modules from the ERP system](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/modules-from-the-erp-system/index.md): Explore your ERP modules to find relevant data elements for reports.

- [Data items](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/data-items/index.md): Use dimensions, attributes, and measures to retrieve and organize report data.

- [Period Functions](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/period-functions-2/index.md): Use predefined period functions to compare results against last year or year-to-date.

- [Report parameters](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/report-parameters/index.md): Drag parameters into the report to show users which filters are applied.

- [Layout Editor](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/index.md): Use Layout Editor to manage filters, sorting, and rules for report elements.

- [Property hierarchy](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/property-hierarchy/index.md): Understand how filters at different levels interact to control report data.

- [Copy and paste](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/copy-and-paste/index.md): Use the special copy menu to preserve all filters and groupings.

- [Expressions and KPIs](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/expressions-and-kpis/index.md): Create custom formulas and KPIs to automate advanced calculations within your reports.

- [Drilldown](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/drilldown/index.md): View the underlying details behind report figures to better understand your data.

- [Linking sheets](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/linking-sheets/index.md): Use INDIRECT formulas to maintain sheet references with expanding data groups.

- [Formatting data with leading zeros in Excel](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/formatting-data-with-leading-zeros-in-excel/index.md): Use parentheses around the function to force Excel to display leading zeros.

- [Static mode for reports: Remove or keep formulas in run report](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/static-mode-for-reports-remove-or-keep-formulas-in-run-report/index.md): Use static mode to remove formulas and increase report execution speed.

- [Use of macros](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/use-of-macros/index.md): Reports in the portal do not support macros due to technical limitations.

- [Built-in Excel security](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/built-in-excel-security/index.md): Learn how to use Excel security features without disrupting report generation.

- [Page setup for reports](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/page-setup-for-reports/index.md): Adjust page setup to ensure professional display when exporting to PDF

- [Best practices for creating consolidated reports](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/best-practices-for-creating-consolidated-reports/index.md): Learn how to consolidate data across companies and manage eliminations manually.