I'm creating a report with a crosstab. I have a dataset representing a people, regions in which people live and a date of settling in the house.
I need to count a number of people by region with the date is today. The report will be exported in excel file.
So the result should be (example for today date):
How could i do that with jasper studion 6.3? Is it possible to remove a "Total" column from crosstab?
Or maybe i can apply .XLSX template to report with all formulas?