Features details
- Nikolina Cofek
- Saša Vukobrad
Section | Feature Name | Short Description |
Integrations | API | Using API for all main freeXreports functions: get list of reports, export reports to different formats, send reports to email etc… |
| iFrame | iFrame integration provides a way to embed external content seamlessly within a webpage, allowing for enhanced functionality and integration of services from different sources. |
| spryker integration with default reports set |
|
Report layouts | multi layout | Enables report multiple layout - e.g. layout for mobile app, layout for destop app, … https://xiphias.atlassian.net/wiki/spaces/BFX/pages/1353646104 |
Report features | data sources | Use different data sources like SQL servers (eg MS SQL, mySql, Azure,…), non SQL servers (redis, ES, ..) rest API endpoints as data source for your reports. |
| multiple datasets as source on one report | You can create any number of datasets to be used in your report. |
| multisource | Each dataset in your report can be from different source (eg. one from SQL database and one from API endpoint). |
| copy report | You can can copy reports with simple click on context menu. Full copy of report is created and is fully functional. |
| copy report layout | When you create you report layout with one click you can copy whole design into new design and create different styling in no time. |
| report scripting tool | Scripting tool embedden into reports to make advance dynamic tasking available. (You can change colors, data “on the fly“) |
| report web designer | Advanced web designer with lot of features to make beautiful reports. |
| report desktop designer | Sometimes is hard to do all development and, especially design, in web app so that’s why you can use free desktop app. You can combine your work environment as you like. |
| favorite reports | You can create your list of favorite reports so you can access it without going thru reports on report list page. You can view and unfavorite report too using favorites tab. |
| drill down reports | You can use drilldown reports to enrich you reports. Two reports can be linked to show even more data without the need to open other report again. (Example In one report you can have list of customer and on Customer name you can link another report that shows Customer orders.) |
| report parameters sort definition | You can manager order that your parameters are sorted. |
| report caching mechanism | If enabled every report is cached to provide fast performanse when view-ing report that are cached. If new data is needed cache is easily cleared. |
| log history | You can have history of changes per user. |
| log execution time | You can see how long did report execution took when trying to optimize reports for best load performanse. |
| report custom fields | If you need special cases when you can use custom field to show data based on custom fields. (Customer will get only his orders when custom field customer_id is used etc..) |
| report changelogs | If needed code backups can be used to revert reports to previously needed state. There are backups for report code and report designer. |
| user related report parameters |
|
| report attributes | You can you report attributes for filtering reports in 3rd party integrations (see API documentation) or just to find reports more easily. |
| report parameters | You can add parameters to your report dynamically by setting parameter name, value type (eg int, varchar, …), display type (eg. drop down menu, check box, …) and parameter value list which can be fixed value list or value list can be taken from data source by using query. |
| linked report parameters | You can use set value for one parameter to filter out values for next parameter (eg. if parameter Country is set to UK then parameter City will show only cities from UK). |
| import/export | Easy import and export of reports with added security (random hash) if needed.
|
| most used reports(mobile) | Usefull feature on mobile app is list of most used reports. It shows reports you have been using the most in last week. If you have large report base this feature saves you time to go thru reports and you can just use this to show most important reports to you. |
| custom report translations | Option to add translations to reports. |
| report parameters history | Parameters values can be saved for user for future use. |
| report columns autogenerate | Autogenerate columns and headers based on data. |
| query and report restore | Restore queries or report layout from previous versions. |
| user and group custom fields | Define custom fields and values for group and/or users which can be used in queries and reports. |
| report script code | Change reports script code (example: change text color for specific conditions, show or hide report elements etc.). |
Connectivity | Role-Based Security | Control access to reports based on user roles. |
| Multi-Language Support | Admin and reports accessible in multiple languages. |
Performance & Optimization | database connections managment | Creating database connections for groups (same report different database based on user group). |
| connecting to different databases and api endpoints | Using integrated connectors to connect to api’s, MySQl, SQL Server, OLEDB. |
Integrated SQL query tool | visual database viewer | Visual viewer with list of all queries , procedures and views with drag and drop feature. |
| code backup | Ability to see report code changes in history and to reapply them if needed. Really usefull when you mess your code and need to revert to last working code. You can see all changes to code. |
| export to favorite sql editor | If needed code can be exported and formated to sql editor. |
Scheduled tasks |
|
|
| send scheduled emails or push notifications | Creating services for email and push notifications. Define execution time, number of executions per day, reports, conditions and users which will recieve reports. |
Administration |
|
|
| administration of users/roles | Administration of users and option to hide/show selected reports to users or roles. |
| company administration | Ability to fully customise user rules(password expiry, password history, password count, default language, default date format). |