Crystal Reports XI

 

I have a report that has a parameter that asks for any amount of Sizes that are predefined ( '7 7/8', '6 1/8' and four more) and a date range parameter. With those two parameters in place, i need to make a 4 year Trend section at the top to show the average cost  for the size chosen for the entire record set i have. for the trend, i have to have 4 averages,  one for each year, ('08,'09,'10,'11). i have been racking my brain on this for a while. If The user chooses two different sizes, i have to include all the records with those two sizes, same for three sizes and so on. All this while not messing up the original criteria used for the details section. do i really need to make ALOT of SQL expression fields to get this accomplished..? i hope i make some sense.

 

thanks in advance

Dan