Jump to content
Changes to the Jaspersoft community edition download ×

jasperreport 6.10 crosstab remove null row group


tong123123

Recommended Posts

crosstab-img3.jpg

 

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.

  1. how to hide the null row in crosstab (but need to keep the 2018 fyear column)?
  2. how to set the total sex so it can sum up the column value in crosstab?
Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

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-jasperreports
https://community.jaspersoft.com/jasperreports-library/issues/4626

I think, the possibility is to modify the result set at SQL level. 

 

Link to comment
Share on other sites

  • 5 weeks later...

>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'.

w20210910_count.png.407047b1f8778f5e0916d5417ba44dc6.png


I hope this is useful to you.

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...