Skip to content
HNROS Help Center
English
Start free
ContentsChoosing the sourceColumns and calculated columnsFilter, grouping, totals and conditional formattingSaving, versions and sharingRunning, output and schedulingOn the phone

Report designer (custom reports)

You build your own report without code: pick a source, set columns, grouping, totals and colours, save the report and get it on screen, as PDF, XLSX or CSV whenever you like. It is separate from the document print designer (invoice/delivery note templates).

Choosing the source

There are three sources: an Analytics Studio cube (pick measures and up to 3 breakdowns; the query is generated only from the semantic model), a company report (one of the company reports in the Reports window and its table) and a card report (an account or stock card report; the code is asked on each run). Load the source columns builds the column list. The report always runs with the source's own permission: a user who cannot see the source cannot see the report; amount masking and HR personnel permission still apply.

Columns and calculated columns

For each column you choose the title, format (text, number, money, percent, date), decimals and what to do in totals (sum, average, count, minimum, maximum); reorder with the arrows and hide what you do not need. A calculated column is written with column names in square brackets: [brutKar] / [netSatis] * 100. Only the four operations, parentheses and abs, min, max, yuvarla, eger are allowed; no other code runs. Division by zero leaves the cell empty; in total rows a calculated column is recalculated from the totals (ratios are not averaged).

Filter, grouping, totals and conditional formatting

The row filter removes result rows (equal, greater, less, contains, empty…). With up to two grouping levels each group gets a header and a subtotal, and a grand total appears at the bottom. With a cube source the grand total is Analytics Studio's own total; count measures such as document or customer count are not found by adding rows, so they stay empty in subtotals. The period, account, warehouse or stock asked at run time are defined in this step. Conditional formatting colours a cell or the whole row green, yellow or red by a number threshold; when several conditions match, the most serious colour wins.

Saving, versions and sharing

Each save opens a new version; old versions are not deleted. If two people save the same report at the same time, the second gets a warning and retries after opening the current version. A report is saved as personal; only a system administrator can share company-wide or by permission. A non-owner cannot change a shared report but can take it with Copy and change the copy. Favourites appear at the top of the list and in the My reports section of the Reports window. Reports are not deleted but archived; an archived report does not run and its schedules stop.

Running, output and scheduling

Run report asks for the period and the defined filters and shows the result in a paged table. Download PDF produces an A4 portrait or landscape document with the page title, company logo, period and footnote; the table header repeats on every page. XLSX and CSV download with raw numbers. If the source does not respond within 30 seconds the report stops; the result is limited to 50,000 rows with a warning. Only a system administrator sets up schedules: daily, weekly or monthly, hour, report period (e.g. last month), attachment (PDF, CSV) and recipients (email addresses and HNR users). The message to a user only contains the report link; whoever opens it sees it with their own permission. Test run runs the report and builds the attachments but sends nothing. The delivery task is off by default on the server.

On the phone

On the phone reports are not designed; saved reports are run: pick a report, then enter the period and filter; the result comes as cards and Share PDF hands the file to the phone's share menu. The My reports button in the Reports window also opens this screen.

Related guides