Hi all,
Little bit new to Crystal (using XI), so bear with me. I have a Access database that includes two different dates for every data piece. Each one has a date for the month the data is collected, and the month that the data is reported (eg. a month could be collected for November, but not reported until January).
The report generated graphs many different sets of data, sorted on which goal they pertain to.
I need a way to summarize this data for a year to date calculation without specifically designating a year. Ideally it would look at the most recent month (collection date) and give the year-to-date for that year. They can be either an average of the data set, a sum of the data set, or an average of the percentage of the data set.
I've tried setting up something to this effect:

{@Datayear}:
DatePart("yyyy",{table.data_collected_month})

Then using that as a selection part of a summary field:
{#YTDVolume}:
Field to Summarize: table.numberofcases
Type of summary: Sum
Use a Formula:
{table.data_collected_month} >=Date ({@Datayear},01,01)
On change of group: table.goal#

But this doesn't seem to work.
Any help would be appreciated!

Edited by mrpatak - 05 Mar 2013 at 4:46am