FastReport Cloud

FastReport Cloud supports adding multiple users to a single workspace as well as to one license. It is necessary to delineate user permissions in some way. For example, one group could be allowed to add report templates, while another group could only prepare and export reports, without the ability to make any changes. In this article, you will learn the basics of creating and configuring groups for such purposes.     Navigate to the FastReport Cloud workspace and then click on the “Groups” section.     Group settings are configured in the “Groups” menu. By default, there are three groups set up: Owner: This group contains the owner of the workspace. The owner has all permissions, and these can only be disabled from the admin panel and through the API.   Other: Any user who joins the workspace will be assigned to this group. The permissions enabled for this group apply to all users. It is essential to set minimal permissions for this group so that new users do not have more permissions than necessary.   Anon (Anonymous Users): This group technically cannot contain users and serves as a way to configure anonymous access to certain elements in the workspace. Each group has a set of permissions that determine what actions a user in that group can perform. The designation of permissions is generally clear from their names, but if you have any questions, you can refer to the documentation.    In the screenshot above (with a partial list of permissions), you can see that all possible permissions are disabled for anonymous users by default. Let’s create a new group and configure its permissions from scratch. In the top left corner under the word “Groups,” there is an input field for adding a new group. Enter a new name and press Enter.     The context menu allows you to delete or rename the group.      The new group will be created without any permissions. In the “Permissions” tab, which opens by default, you can configure what users are allowed to do. The minimum set of permissions is “Get Info” about the workspace and documents. If you allow only this permission, the user will be able to see the list and general information about the uploaded documents. Conversely, if the added group has no permissions, but the “All Users” group does, the user will still be able to see the documents. Let’s set permissions as follows:     Then go to the “Users” tab. Here you can manage users and their access.     Users in the group will be shown in the upper panel, while the others will be in the lower panel. If the same permissions are disabled for the “All Users” group, only users in the added group will have the ability to see the documents. This is what the FastReport Cloud menu will look like if a user has no permissions, even basic ones:     If they are added to a group where only viewing information and previewing reports is allowed, this is what users will see when they right-click on a template:     The actions highlighted in gray are unavailable to the user because neither the “All Users” group nor the groups to which this user belongs have the permission to perform those actions.

In the Business edition of our cloud service for working with reports, FastReport Cloud, there is an option to add users to the same workspace. This means that multiple individuals can prepare reports from a single large list of previously added templates. Additionally, several people working on report templates can quickly and conveniently add them to a space where those reports can be prepared by another group of users who do not have editing permissions for the templates. To begin, let’s add a new user to the workspace. When a new user first opens FastReport Cloud, they will see the following screen:     Each user must have an account on our authentication service, FastReport ID. After successful registration and logging into FastReport Cloud, the user will see the following message:   At this stage, we go back to the account that purchased the license for FastReport Cloud. In the “Users” tab, you will see a list of users that have already been added, as well as a button that we will need right now—“Make Invite Link.”   If you click on this button, you will see a text field with an invitation link, as well as a button that allows you to copy this link.     By default, this link is reusable and is valid for one day. Currently, this can only be changed through the API. Share this link with the new user. When they click on this link, they will see a dialog prompting them to accept the invitation to FastReport Cloud.     After clicking “Accept,” two things will happen. First, the new user will be able to perform actions permitted for the “All Users” group. For example, if you have disabled access to document information by default, this is what they will see:   Secondly, you will be able to see the new user in the same “Users” menu from which the invitation link was copied.     If you want to remove a user from the subscription, you can right-click on that user and select the appropriate option.     By the way, if you go to the workspace information menu, you will be able to see the maximum number of added users.     Thus, the Business edition of FastReport Cloud allows for effective organization of collaborative work on reports. By adding users to a single workspace, simultaneous preparation of reports from a shared list of templates can be ensured, or tasks can be distributed among different groups of users. This streamlines the reporting process and makes it more convenient and efficient.

ClickHouse is a popular database that is convenient for data analysis. In this article, you will learn how to connect to this database from the FastReport Cloud service for report generation and storage. As an example, the article will use a database of tutorials on working with ClickHouse.   In our case, “default” is the name of the database, and “my first table” is the name of the table. To add our database as a data source, select “ClickHouse” when adding a source. You will see the dialog:   We don’t need the table name now, just the database name. So, let’s fill out the form:   As you can see from the dialog, the connection test was successful. Now just click “Connect,” and the connection will be saved among the existing ones.   You can then use this connection in your reports. Now let’s try to make a simple report based on this connection:   And, of course, take a look at the report preview:   If we compare the data from the original table with our report, it will be quite obvious that the connection is functioning properly.