021 | BI - Jaspersoft Reports | Groups & find sub-totals by grouping data in Jasper Design Studio

In this video, you will learn the basics of Groups and how to calculate sub-totals for each group in a Product Detail Report using Jaspersoft Design Studio Professional.

[alvarocastroz]

Your movements in the development of the session, it was enough to me to be able to develop a group. The English language is not my thing, but his leisurely explanations and the basic words were enough to finish my request. Thank you very much from Costa Rica..

[jake]

Will you please do a demo of how to do grouping in crosstab report?

[shivarajintelinfotech]

can we use crosstab in group sections? coz I want page header and footer on every group in crosstab to show some text and also should be print every group data in a separate page

[mikkiliavinash]

bro how can we make group in a group like group inside group !!

[ainigma]

Hello and thank you for your video!

Assume that we have the following Excel report:

EMP_ID | payment_date | amount |
12 | 12/01/2023 | 12000 |
12 | 28/02/2023 | 4000 |
13 | 19/01/2022 | 32000 |
13 | 07/06/2022 | 8000 |
13 | 22/09/2022 | 600 |

Is there a way to group the id and merge them so that we do not see the same id in multiple rows? How can we do that?

Merged table
EMP_ID | payment_date | amount |
12 | 12/01/2023 | 12000 |
| 28/02/2023 | 4000 |
13 | 19/01/2022 | 32000 |
| 07/06/2022 | 8000 |
| 22/09/2022 | 600 |

[Andre_XX]

Good, but I could barely understand what you were saying.