harshilbhatt_16 Posted June 7, 2017 Share Posted June 7, 2017 Hi all my goal is to get the below results in jaspersoft. Sum of total_line_price start_date_fiscal_year contract_numstart_dateitem_numberitem_descriptionline_statussales_order_numpurchase_orderbill_to_ucn2016201713003091/11/2016569910SCHOLASTIC MINIBOOKS 1 YEAR SUBSCRIPTION 29.99EXPIRED 29.99 26873761/11/2017569910SCHOLASTIC MINIBOOKS 1 YEAR SUBSCRIPTION 29.99ACTIVE46266966 622176741 29.99Grand Total 29.9929.99 The results that i am getting are not right with the totals. So i created a report without any totals. but they how do i get the grand total to be different for 2016 and 2017 ?Below are the steps i am following Link to comment Share on other sites More sharing options...
tango12369 Posted June 13, 2017 Share Posted June 13, 2017 The best soultion from my practice , you need to create additional field with extracted year( e.g. 2016, 2017) in your quiery and add this column with Total in the end. 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