in the figure, the right hand side is the query result, I want to show it in crosstab with sex as row and fyear as column, but the 2018 has no record and sex is NULL.
- how to hide the null row in crosstab (but need to keep the 2018 fyear column)?
- how to set the total sex so it can sum up the column value in crosstab?
1 Answer:
Posted on September 9, 2021 at 4:16pm
>1.how to hide the null row in crosstab (but need to keep the 2018 fyear column)?
--> I found this difficult. I would like to know too.
>2.how to set the total sex so it can sum up the column value in crosstab?
-->Try setting the measure item Caluculation to 'count'.
I hope this is useful to you.
I have tried with the same data and ended up unresolved and further research indicated that we can't remove empty rows based on row groups dynamically at cross tab level.
https://stackoverflow.com/questions/14221656/hide-null-row-groups-jasper...
https://community.jaspersoft.com/jasperreports-library/issues/4626
I think, the possibility is to modify the result set at SQL level.