When the tabular reports added to JO have a aggregation or a pivot, that is not honoured when the report is added to the JO Email.
For this, we had to use a data designer to modify the data in the format needed and then create reports.
This is additional processing time which can be avoided if we can add the original report will the required configurations.