spmkkmps Posted July 29, 2009 Share Posted July 29, 2009 Hi Please see the attached image. The total and closing balance is done based on groupby of a particular Field. Now i need to sum those two closing balance. Can you please tell me what has to be done. Please post your answers quickly. Its very urgent. Thanks a lot.Madhan Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 29, 2009 Share Posted July 29, 2009 Change your prospective, instead of thinking about summing two totals, calculate directly the final total in a variable that is independent by the groups, same for the other values you would have to sum/add to the final value.GiulioPS. Madhan all the people posting on this forum consider their questions very urgent. The answers come on a volunteer base, so it's not necessary you say all the times your question is urgent and please post an answer quickly, JasperSoft offers commercial services for this kind of requirement. Link to comment Share on other sites More sharing options...
spmkkmps Posted July 29, 2009 Author Share Posted July 29, 2009 can you please bit more clear. What you say is i need to sum it based on the topmost field value right? Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 29, 2009 Share Posted July 29, 2009 What I'm saying is that you should use a variable that is not dependent from a specific group, instead of summing the totals of each individual groups. Group | Value | Group Total | Grand Total-------------------------------------------A | 10 | 10 | 10A | 20 | 30 | 30A | 14 | 44 | 44-------------------------------------------B | 3 | 3 | 47B | 1 | 4 | 51B | 5 | 9 | 60-------------------------------------------Giulio Link to comment Share on other sites More sharing options...
spmkkmps Posted July 30, 2009 Author Share Posted July 30, 2009 Giulio,Thanks for your information. But the spec. got changed. So started redesigning the report.Madhan 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