I have a number of records in my database. Each of them have a date time stamp in the mm/dd/yyyy HH:MM:ss format.
if I am grouping the calls by date, it comes properly. but if I group based on date and some other field, for a particular day the second grouping field should come only once. But In my case the second grouping field is repeating again and again. I feel this is happening because I have date and time. How can I solve this problem?

I am getting the result set and sending it to the jasper report for populating the report.

Eg : If the grouping is Agent by Days then for a day 14/07/2010 each Agent name should come only once and all the entries for the particular agent for that day should be displayed. But the Agent grouping is repeating again and again