Update of Cloud Services to Version 2025.1

For FastReport Cloud and FastReport Corporate Server, version 2025.1 has significantly improved work with data sources, tasks, and report templates. We also added API methods for retrieving user rights and new demo applications, and, of course, fixed numerous bugs.

Changes for FastReport Cloud and Corporate Server

Custom SQL Tables Added to Data Sources

The ability to add custom tables as SQL queries to data sources has been added. To do this, create or edit a data source on the corresponding page, click “Next,” and enter the SQL query. If the query contains parameters starting with the “@” symbol, a data source parameter will be created, allowing you to configure its data type and default value.

After adding your own table and saving the data source, it will become available for use in Online Designer.

Template Engine for File Names Added 

In the name of the template or report file, you can use the variables ${Date} and ${Time}. Then, in the final exports, the file name will contain the date or time of export (UTC) instead of these variables. For example, when exporting sales_report_${Date}.frx to PDF, the final file will be named sales_report_2024-07-08.pdf. The order of the day, month, and year depends on the localization chosen during export or the default localization.  

These variables can also be specified in the output file name when creating tasks.  

Report Parameters Are Now Available for Retrieval and Editing Via API

The following API methods have been added:

- GET /api/rp/v1/Templates/File/{id} - now this method returns a list of report parameters if they are set. 

- POST /api/rp/v1/Templates/File/{id}/parameters - with this method, you can set or edit report parameters. 

Report parameters also remain available for editing in Online Designer and when downloading report templates.  

Added API Methods For Retrieving the Current User’s Permissions on Files, Groups, Tasks, and Data Sources

Previously, there was only one method for retrieving user permissions, which makes the following request:  

/api/manage/v1/Subscriptions/{subId}/mypermissions

With this update, we have added 10 more requests:  

/api/data/v1/DataSources/{id}/mypermissions
/api/rp/v1/Exports/Folder/{folderId}/mypermissions
/api/rp/v1/Exports/File/{id}/mypermissions
/api/manage/v1/Groups/{id}/mypermissions
/api/rp/v1/Reports/Folder/{folderId}/mypermissions
/api/rp/v1/Reports/File/{id}/mypermissions
/api/tasks/v1/Tasks/{id}/mypermissions
/api/rp/v1/Templates/Folder/{folderId}/mypermissions
/api/rp/v1/Templates/File/{id}/mypermissions

With them, you can find out what permissions the user has and only perform corresponding actions if these permissions are available.

Added Current Product Version Display 

Now, at the bottom of each page in the user panel, you can see the current product version.  

Case Insensitivity in Sorting  

Previously, when sorting documents by name, those whose names started with an uppercase letter were shown first. Now, the sorting works independently of letter case in file names.

New Demo Applications Added

New console and Android applications in Kotlin and Angular have been added to GitHub. In addition, you can deploy demo applications in Java, PHP, Cpp, Haskell, JavaScript, Go, and Python in your projects.

Try the demo

Additional Changes for FastReport Corporate Server  

Added the Ability to Download Files and Folders from The Admin Panel 

To download a template, report, export, or folder in the admin panel, simply click the corresponding button on the row displaying the item.  

A Graph of Active Users and Workspaces Added to The Admin Panel

With this, you can evaluate user activity for each month. To view the graph, go to the ‘Audit’ page and click the ‘Show Statistics‘ button at the bottom of the page.  

Added Parameters for Scheduling Tasks in The Admin Panel 

On the ‘Tasks’ page of the admin panel, a ‘Details’ button has appeared, which opens a page with a detailed description of the task.

Full list of changes

---

[Backend]
+ added a log for invalid license keys;  
+ added tests for upload size limits;  
+ added custom tables to data sources;  
+ added a template engine for file names;  
+ enabled the creation of stored procedures in the data source structure;  
+ added a new parameter to the license key;  
+ added a method for retrieving the current user’s rights on files;  
+ added retrieval of mypermissions for groups, tasks, and data sources;  
* changed sorting for backend;  
* changed data source names to be unique;  
* changed the maximum number of users in the Corporate Server without a license key (5);  
* added parsing of template parameters from metadata;  
* changed case sensitivity in sorting;  
* changed task names to be unique;  
- fixed file uploads with identical names;  
- fixed the path for the destination folder;  
- fixed report parameters;  
- fixed duplication of the jti claim in the JWT token;  
- fixed task execution with files in the request body;  
- fixed rights checking for moving to the trash;  
- fixed an error returning an incorrect ID when creating nested tasks;  
- fixed a bug where the UsersPerWorkspace parameter in the configuration was not considered if there were no user limits in the license key;  
- fixed a bug where an anonymous user received errors in the controllers;  
- fixed a bug where the administrator received a 403 error when retrieving the data structure;  
- fixed delayed task execution in the scheduler;  
- fixed the incorrect creation time for data sources;  
- fixed an error when opening compressed templates in Online Designer.

[Common]
+ added an article on Webhook;  
+ added the ability to download folders and files to the admin panel;  
+ added a graph of active users and subscriptions in the admin panel;  
+ added documentation for custom queries in data sources;  
+ added current product version display;  
+ added documentation for export parameters;  
+ added a Name in the docker-compose installer;  
* improved the task scheduler;  
* changed the name in the docker-compose installer; it is now always the same by default;  
- fixed the documentation;  

[Demos]
+ added console and Android demos in Kotlin;  
+ added Angular demo.

[Frontend]
+ added task scheduling parameters to the admin panel;  
+ added notifications for failed folder exports;  
+ added an interface for creating custom SQL queries;  
+ added a check for the user’s subscription limit;  
+ added localization for export parameters in the admin panel;  
+ added error texts in notifications within the admin panel;  
+ added a ‘Refresh’ button in the context menu on document pages;  
+ added localization for audit notifications;  
* shortened links in the admin panel to delete the scrollbar;  
* changed input for users and subscriptions on the audit page;  
* changed sorting for the admin panel;  
* changed notifications for deleting API keys;  
* removed mutations from injection in Online Designer;  
* the ‘Plus’ button on the document page will no longer appear if the current user does not have permission to create files in the folder;  
* improved localization in the admin panel;  
* all online libraries became local;  
* displayed date and time have been converted to local time zones;  
* new .fpx icon;  
* connection testing on the ‘Data Sources’ page has become optional;  
- fixed export and download buttons;  
- fixed history on export and report information pages;  
- fixed an error when creating a data source from the online designer;  
- fixed the display of the user deletion button in the admin panel in corporate server mode;  
- fixed a white stripe appearing after clicking on the checkbox and the disappearing title on hover;  
- fixed localization of workspaces in the admin panel;  
- fixed validation of the owner ID in the admin panel;  
- added a default avatar for all user icons;  
- fixed localization for starting a task;  
- fixed an error regarding payment necessity on the expired subscription detail page;  
- fixed notifications for downloading files without permissions;  
- fixed the search field and the output file name field;  
- fixed the ‘Select All’ button on the API keys page;  
- fixed a bug with an incorrect default subscription when updating a user in the admin panel;  
- fixed a bug where pages did not refresh after deletion in the admin panel.