Create a report
Introduction
The XTRF Platform enables you to visualize your data in the Home Portal. It helps you to present the results of your employees' work, sum up your vendors' activities, or track your clients' orders. XTRF Platform provides simple tables where you can set together your project data in one place, as well as visualize them either on simple charts or more complex ones. The default charts defined in the Home Portal are embedded from Google charts; however, the chart definition can be customized to your needs. Moreover, you can generate your data set in a user-friendly printed format or export it to a
CSV
file. The visualization is an easy and efficient way to tackle all activities in the Home Portal by transforming task names, start and end dates, and durations into cascading horizontal bar charts.
I. Add a report
Sign in to the XTRF Home Portal.
Go to the Portals module.
Click the Add Report button on top of the list of reports.
You will be directed to the Add Business Report page.
Provide a name for the new report.
Check the Preferred box if you want this report to appear on top of the list.
From the Report Type drop-down list, select which variables you want to reflect in this report: a number, a value, or a relation between two types of data.
From the Data Type drop-down list, select which data you want to reflect in this report.
If you have chosen Relation in the Report Type field, a Related Data Type drop-down list appears. Select the data you want to compare to the one in the Data Type field.
Click the Save button. You are directed to this report's setting page.
II. Specify the report details
In the Report Definition tab, you can specify how the data will be presented in the report:
(Optional) If you want this report to be available in another language, in the Name section, click the Show Localized Names link. For details, see the Add localized values guide.
In the Categories section, select the appropriate label for your report from the drop-down list. To learn how to manage categories, see the https://help.xtm.cloud/xtrf/home-portal/configuration-menu/en/categories.html article.
In the Filter Settings: Task section, you can add filters to your report.
From the drop-down list, select the filtering scope related to the report. Additional fields will appear. Note that setting fields can be different for each filter. To learn more about filters and settings, see the filter settings expand below.
Select the desired settings to narrow down the data in the report.
Check the Show filter on generated report to make the selected filters appear on the report.
Only the table report view will display the selected filters.
In the Columns section, select which columns will be displayed on the report.
From the Columns drop-down list, select the variables that will be displayed in columns.
From the Label drop-down list, select the title for the columns.
With the Include Missing checkbox, decide whether you want to include columns with zero values.
With the Sum checkbox, decide whether you want to include an additional row displaying the total amount of a column.
If the data in the column is time-related, select how it will be arranged from the Frequency Type drop-down list.
From the Sort Order drop-down list, select how the data will be sorted in the table.
In the Rows section, select the settings as described in Step 5.
Click the Save button. Now you can generate some views of this report.
The Generate Chart button is inactive. To activate the chart view, go to the Chart Settings tab.
Filter settings
III. (Optional) Enable the chart view
Go to the Chart Settings tab.
Select the graph type of the report's chart.
Click the Save button.
IV. Decide who can see the report
Go to the Execution Permission tab.
Decide who will be permitted to see this report:
Click the Global Permission radio button to give viewing and editing rights to all Home Portal user groups.
Click the Individual Access Settings radio button to select which groups and what users will be able to see this report:
In the Groups section, select the desired user groups in the Available Items list and add them to the Selected Item list.
In the Users section, select the desired users in the Available Items list and add them to the Selected Item list.
Click the Save button.
If the settings in the Configuration Menu > User Management > Users Groups and Rights allow certain user groups to edit the reports, they will be able to generate reports regardless of the settings you set on the report level.
(For client-related reports) To allow clients to see this report on the Client Portal, go to the Client Permission subtab and check the This report can be viewed by clients box.
This report can be viewed by clients checkbox is active only when you have selected the Project, Client filter, and checked the Logged-in User box in the Report Definition tab.
IV. Generate the report
Scroll down to the bottom of the page.
Click one of the buttons:
Generate to display the data in a table.
Generate Chart to display the data in a chart.
Hover over the chart's elements to display additional details.Generate Printer-Friendly Version to display data in a printer-friendly format.
To learn more about reports in XTRF, see the Reports module article.