Issue :
HTML5 stacked bar chart grouped by month and by tenant having tenants value zero are showing up on the report. Zero values from staked bar chart needs to be removed.
e.g. attached screenshot (Issue.png) has zero values in stacked bar chart which needs to be removed.
Resolution :
To remove zero values from stacked bar, below property need to be added.
Kindly follow steps :
1) Open Jaspersoft Studio and navigate to below path :
Go to Window -> Preferences -> Jaspersoft Studio -> Properties
Search for "com.jaspersoft.jasperreports.highcharts.function.properties.allowed" and set this property to true (if this property already not present then kindly add it)
2) Edit Chart Properties -> Chart formatting -> Advanced Formatting -> plotOptions -> bar -> dataLabels -> formatter -> use expression and feed it the following function (make sure add below function in double quotes) :
"function(){ if(this.y > 0) return this.y; }"
Screenshot for the same attached. ( "Resolution.PNG" )
Result :
After following resolution steps, zero values from stacked bar removed as per attached screenshot. ("Result.PNG")
Recommended Comments
There are no comments to display.
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 accountSign in
Already have an account? Sign in here.
Sign In Now