Urgent Help On Date Calculation

I have a table that hold a couple of fields.
STARTDATE - The day the service starts
FREQTYPE - This field tells me how often a schedule occurs. Here are the vaules -1=oncall, 0=days, 1=weeks, 2=months
FREQPERIOD - This is the number of days, weeks, or months between services. a value of -1 would indicate being oncall.
DayOfWeek, Day of week for week or month-based frequencies 0=sunday 6=saturday -1=if on call
WEEKOFMONTH - week of month for month based frequencies 1-4, value of 5 if it the last week of the month,

So what I need is for this report to look at the start date then figure out what the frequency is (days, weeks, months) then look at the frequency period (how many days are between services) what day of the week it falls on and list each service date on a report. There is an example at the bottom
I have tried numerous things and I can't get it and I need this asap today. I can provide what ever anybody needs, Many thanks.

Here is an example of the output that I need.

Service Frequency Every 12 weeks or 84 Days

Pickup Starting Point 1/4/2007

Pickup Schedule
3/29/2007
6/21/2007
9/13/2007
12/6/2007
2/28/2008
5/22/2008
8/14/2008
11/6/2008
1/29/2009
4/23/2009
7/16/2009
10/8/2009
12/31/2009


Here is sample data with the relationships
http://www.balzoutonline.com/reporting/database.jpg

Here is the service table schema
http://www.balzoutonline.com/reporting/service.jpg

Here is the serviceinfo table schema
http://www.balzoutonline.com/reporting/serviceinfo.jpg

Here is the serviceschedule table schema
http://www.balzoutonline.com/report...iceschedule.jpg

And here is the site table schema
http://www.balzoutonline.com/reporting/site.pdf

Here is something that was created in excel wich is pretty easy but a manual process. This is what I would like to replicate in crystal
http://www.balzoutonline.com/reporting/Schedule.xls