For every person different places and times are given. How do I define the search in the table via "Place_1...Place 16" AND / OR "Year_1 ... Year 16" without having to specify everything 16 times? So, who was in town y in year x?
Is that possible?

This is possible using native SQL but due to complexity you do that currently outside of KEXI, unfortunately. If what you mean it is grouping, KEXI reports support it, e.g. you'd be able to visually present show groups such as

Code: Select all

PERSON1
 TOWN A
   YEAR 1
   YEAR 2
 TOWN B
 TOWN A
   YEAR 3

PERSON2
 TOWN X
   YEAR 6
 
...


Note that reports do not support searching within the displayed preview at the moment.
If you base your report on a KEXI query you'd be able to add an interactive parameter, e.g. a user name, using [Enter name] notation and use that query in the report. If that's sufficient.