Hello again,
So I have a new question.  Lets say I have two table fields that look like this:

Forecast Date                  Forecast QTY
01/12/2012                        2000
01/20/2012                        1500
02/01/2012                         3000
03/04/2012                        1700

and I want to display it like this:

Jan 2012         Feb 2010           Mar 2012
1500                  3000                  1700

How do I go about splitting the date field and have only each months most recent qty display under the proper month??

I hope that this made sense
Thanks
Brandon

Thanks for the update.  It that worked to a point.  It is showing all the numbers properly in the group header, now the only thing is that I need it all to show up on 1 line.  Right now the way it is set up it looks like this:
Jan 12      Feb 12     Mar 12
1500
                 3000
                                 1700

when I need it to look like this:
Jan 2012         Feb 2010           Mar 2012
1500                  3000                  1700

How can I use the same logic but only group by totext(year(Forecast Date)) and not have the totext(month(Forecast Date)) in it??  I believe that this would work but when I try and sort the date field ascending/descending for a specified year, the feb numbers show up as zero in the group header because in the field (after using the mentioned formulas) the number for Feb are surrounded by 0's.

Thanks

try this
group on year
create 3 formulas like
if (Forecast Date) in date()to date() then maximum((Forecast Date),year)
then create 3 formulas like
if   (Forecast Date)=           "Jan 12 "(formula) then Forecast QTY
then  sort by Forecast Date     descending

Feb1 formula: if ({forecast_audit.forecast-date}) in date(YEAR({?Forecast Date}), 02, 01) to date(YEAR({?Forecast Date}), 02, 28)
    then ({forecast_audit.forecast-date})
Feb2 formula:  if {forecast_audit.forecast-date} = maximum({@Feb},YEAR({?Forecast Date}) then {forecast_audit.forecast-qty}

instead of  YEAR({?Forecast Date}) use  the formula that u create for group by.