Resultset divide by YEAR

Applications Grid / Reports
#1

hello,
I’m creating a grid out of a table that contains invoices for, let say, 10 years.
the best woud be to get a result set divided by year (each year on a specific tab, or using navigation button…) and showing the current year as first subset.
obviously, YEAR is a field of the table, so no need to calculate out of SQL…

Which solution would you use?

Thanks,
Luca

#2

Hi Irweb,

There are more ways to go.
My preferable option would be to use the “Refined Search” option in the Grid
Other way is to use “Grouped by” also in the left gridmenu.

Rem: Better is use the word “group” instead of the word “divided” I think.

Regards Bert