shrestha.mallick Posted October 1, 2019 Share Posted October 1, 2019 how to get the results for same date in one row in jasper. Link to comment Share on other sites More sharing options...
C-Box Posted October 1, 2019 Share Posted October 1, 2019 What about grouping by Date?Just create a Group with Expression $F{YourDateField} and create internal Variables for summing up /average or anything you want for aggregate your current columns (e.g. $V{SumNumberDiffVehicles} with calctype SUM and expression $F{YourNumberFieldOfDifferentVehicles} and ResetType group)The variables have to be placed in GroupFooterBand and your detailband could be removed if just the sums are enough So just a basic feature of JasperReports :-)hth + regardsC-Box Link to comment Share on other sites More sharing options...
shrestha.mallick Posted October 1, 2019 Author Share Posted October 1, 2019 Please consider, This is a table in detail band and the first output comes from my query,(Which has a group by on date and type ok or not ok). hence, the result initially was like - 30.08.19 00:00:00 NOK 133 30.08.19 00:00:00 OK 1771 Link to comment Share on other sites More sharing options...
Recommended Posts
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