Contents
Choosing the sourceColumns and calculated columnsFilter, grouping, totals and conditional formattingSaving, versions and sharingRunning, output and schedulingOn the phoneReport 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
- Report GuidesStock card → Reports (Stok kartı → Raporlar). For a group, use Stock → main group/subgroup → group reports. · 34 report/view sections.
- Cockpit — A Guide from Scratch for ManagersThis guide is for the person who has to look at numbers and decide. Its purpose is not to teach you how to read a report but to show where every number on the.
- The Profit Panel — "How Much Did We Really Earn?"Revenue is easy: you add up the invoices. Profit is hard, because first you must subtract cost, expenses and the part of the tax that was never yours.
- Reports — Where the Numbers Start to Mean SomethingLists answer "which record"; reports answer "how much, to whom, when". This window holds seven ready-made reports plus the company-wide Company reports.
- Owner Dashboard — A Guide from ScratchEvery morning a business owner first asks four questions: will my cash last, where are sales heading, who owes me money, where are we stuck?
- Customer and Supplier Report GuideAmounts, quantities, percentages and days are different measures. Use the currency and unit printed beside the value; do not assume that every number is TRY.