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

 

Database records grouping

Grouping database by some column or several columns is a common way to run reports in database, it is really easy to group data in QuintaDB online

QuintaDB development team has created a new functionality for working with databases, namely the database grouping.


The grouping is used to combine records on the same basis (the field). For example, we have contracts database in which we can find the names of clients, contact persons, balance and payment type. 

Each contract is unique, but it is necessary to group them by type of payment.

See step-by-step instructions below:

For using the grouping option open your project and go to the Records menu.

Click on the Grouping link. In a next form you should select fields for grouping and specify how to display records (ascending or descending). Groups priority is defined by fields sequences in the window (top to bottom). 


In QuintaDB databases you can use Grouping by multiple fields. It's very easy. Slect several fields in order to do it.

See your database after grouping.

The result can be saved as report. You can also export it to PDF.

You can delete or edit records, and the grouping result will be saved. Click on the "cancel" link to cancel the grouping.
 
You can sort grouped data in ascending or descending order:
After grouping, you can search the records.
And save the result to the report.