Hi, I have implemented Java code that will take a ResultSet of dates and other data related to these dates and pass it into a report that I created.
The report simply groups the dates using the following syntax: GroupName({POLICY_TXN.EFFECTIVE_DT}, "monthly") and displays a count of the records besides them.
In Crystal Reports, through a preview, I am able to see what I intend to, i.e. a list of months with a count for each month beside it. For example, one line in the report would be February 2008 10
However, when I run the same report through JRC while passing in data from a ResultSet, for some reason, the grouping by month is not occurring. I instead get multiple entries for February 2008 corresponding to each specific date for the record found in the table. It seems as if for some reason the grouping by month is not occurring through JRC.
Anyone have ideas how to fix this?