atsu Posted August 18, 2010 Share Posted August 18, 2010 Hi there,I need to do this in the next 48 hours and it just won't work. somebody please help me out. I am writing an application for a fishing harbourI need to create a quarterly and yearly report from a database such that I'll sort and group records by the date of arrival of thevessel and print the section for every month as attached to the letter. Please help me out because I really don't know how to go about it Link to comment Share on other sites More sharing options...
despec Posted August 18, 2010 Share Posted August 18, 2010 Well, you need to build a query with a "group by" clause. For example:selectarrival_date,sum(squid) as squid total,sum(fish) as fish_totalfrom(your db table)group by arrival_date Hope this helps,DavidPost Edited by despec at 08/18/2010 20:25 Link to comment Share on other sites More sharing options...
rajuchacha007 Posted August 19, 2010 Share Posted August 19, 2010 David has already explained you the correct thing. For your knowledge, visit the following topic. It might help you. (Courtesy slow) http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=74078&topid=74163#74163 Best regards. Link to comment Share on other sites More sharing options...
slow Posted August 19, 2010 Share Posted August 19, 2010 thanks to rajuchacha007 to remeber my explanation... :)(here a present to him : http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=77802 ) Link to comment Share on other sites More sharing options...
jcabral Posted May 3, 2011 Share Posted May 3, 2011 Hi All, How can I have the same result using Xpath query? I'm new with jasper reporting. thanks in advance br,JoelCode:selectarrival_date,sum(squid) as squid total,sum(fish) as fish_totalfrom(your db table)group by arrival_date 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