Log In

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:

Please, login to QuintaDB to be able to post comments

Hi,
Having save a grouping, can you later delete the grouping?


Igor Petrushenko

Hi,

yes, of course, saving grouping, filtering and search will create views. This views will be in the drop down at the left. And at the right of this views’ drop down there will be delete icon (if you selected any view). As well as re-order icon – where you can sort your views.


Can you total a numeric field by group?


Igor Petrushenko

Hi,

Not yet, but we aware of it and will fix ASAP.

Thank you!

Share the discussion in the social networks: