Appearance
Run a report
ReportsAll reportsRun a reportPermission:
reports.viewAlso known as
- Lifecycle cost (TCO) report
- report
- tco
- lifecycle
- Work order cost variance report
- variance
- cost
- run report
- report parameters
- export to Excel
Every standard report opens on this page: you set its parameters, run it, read the result as a table with totals or as a chart, and export it to CSV, Excel or PDF. Reports always run on live data, so two runs a minute apart can differ if someone posted in between.
Run a report
- Open the report from All reports, from a module's reports page or from the command palette (Ctrl K, for example Lifecycle cost (TCO) report).
- Fill in the parameters in the shaded panel. Required ones are marked; the others narrow the result when you fill them in and include everything when you leave them empty.
- Select Run report.
The result appears below the parameters, with Generated and the date and time under the title, the number of rows below the table and a Total row for amount and quantity columns. Change a parameter and select Run report again to refresh it.
| Parameter kind | How you fill it in |
|---|---|
| Date (From, To, As of) | Type the date or pick it from the calendar. |
| List (for example Event, Status) | Choose a value, or leave Any. |
| Legal entity | Choose an entity, or leave All entities. |
| Number (for example Days without movement) | Type the number. |
| Yes/no (for example Active items only) | Turn the switch on or off. |
| Text (for example Lot or serial number) | Type the text. |
| Message | What to do |
|---|---|
| Required. (under a parameter) | Fill in that parameter and run again. |
| No rows for these parameters. | Nothing matches: widen the dates or clear a parameter. |
| The report could not be run. | The message below it says why, for example a missing permission. |
Read the result
- Sort by a column by selecting its header; hide columns with the table's column control.
- Money columns show the currency; percentages show one decimal.
- When the report has a label column and numbers, select Chart above the table to see the first numeric columns as a bar chart. Select Table to return.
Export the result
- Run the report.
- Select Export and choose CSV, Excel workbook or PDF.
The file is built on the server with the same parameters and downloads to your computer. If it fails you see The export failed.
TIP
To receive a report by email on a schedule, or to share a report's result with colleagues, use Schedules in Analytics.
Differences by role
Running a report needs Permission: reports.view and the report's own module permission (for example
assets.report.view for the TCO report). A report you may not run shows **This report isn’tavailable.**
Related
- All reports
- Report builder: build your own query
- Reports across modules
- Imports and exports
- Close and report
