English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In

 

How to create and work with Reports in QuintaDB

Database report it's a set of records which is passes some criteria. It is a common way to fetch data from database tables and use them later.

In this blog post you can find detailed instructions of how to create Reports in QuintaDB online database. Read about reports integration here.


In order to create Report we need to find some records and save result in the separate Report.

You can export to Excel all database records or use Search, Grouping functions and export only the found records.
Create database Views for the results of Search and Grouping.


For example we have UEFA Club Ranking Table.
The first step: open our test database (UEFA Club Ranking), it has 50 records (one per club) and go to the Records menu.

Record menu
We need to find and save all the clubs from Spain in a separate table. Click on the "Search" button.

Search by country


After the search click on button "Save Report" to create a new Report with the found records.

Search records

You can view, re-order, delete, edit name and open reports in Reports menu. Click on the "All reports" tab.

All reports tab

How to remove report

You can delete a report at any time you need. It’s very easy.

Please, see the screenshot below:

 

Also, you can rename, clone and change report parameters in the context menu.

Now open the report.
Columns menu
In the "Columns" menu, you can choose which columns will be hidden in the report and the report widget. Also, you can rename and re-order columns for the report widget. You can read more about "Columns" menu by this link.
Columns menu

Please note: the report's hidden columns settings apply only to the report owner.

For users group in the Team module, you must separately configure the field level access.
To export Report you only need to click on "Export" button. 

You can also integrate your reports an add it to your Customer Portal.