In our application, there is a requirement that the data need to be grouped by some fields.
There is a POJO InvoiceItem (category, name, amount), and a database query produces a list of InvoiceItem (by hibernate query). And we want to use Aspose.Word to generate PDF based on these data.
The problem is we want to group DataTables by fields (category in this case), and add subtotal on each subtable.
Is it possible to do so by Aspose? And how can I do that?
I think there should be a way of producing DataTable or doing mailmerge in a loop, am I right?