Sort and group records by field and print section

[atsu]

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 harbour

I 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 the

vessel 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

 

[despec]

Well, you need to build a query with a "group by" clause. For example:

select

arrival_date,
sum(squid) as squid total,
sum(fish) as fish_total

from

(your db table)

group by arrival_date

 

Hope this helps,

David

Post Edited by despec at 08/18/2010 20:25

[rajuchacha007]

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.

[slow]

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 )

[jcabral]

 Hi All,

 

How can I have the same result using Xpath query? I'm new with jasper reporting. thanks in advance

 

br,

Joel

Code:

selectarrival_date,sum(squid) as squid total,sum(fish) as fish_totalfrom(your db table)group by arrival_date