How to loop this

I have this this setup in crystal

if isnumeric(mid({ServiceInfo.SvcFrequency},2)) then
{ServiceHistory.ServiceDate} + 7 * val(mid({ServiceInfo.SvcFrequency},2))
else
0

My problem is I want to specify a stop date. Now is there a way to look at that formula and repeat it over and over to a specified end date?
Such as
So if the last service date was 1/1/07 and the freqency is w001(every 1 weeks) then the next service dates would be
1/08/07
1/15/07
1/22/07
...
...
Specified end date

And it would display every date that the service occurs on the report?

Thanks.Anyone? Please

how to link excel sheet with Crystal Report

How can i be able to link excel file with crystal report
i tried OLE and was succeeded but with problem that it displays the cells lines that are not needed.

second thing i was trying to do it through dsn (tried all the 3 dsn types)
but when i connect crystal report with it using ODBC it shows me
"No Items found".

any suggestion ?when i link excel file with Crystal Report8.5
as an OLE i see some extra blank cells with it on the right side and when i take a print of it, these cells are also printed

i used crystal report control to connect vb with report
the code is here
cr1 is the Crystal Report Control's Name
Code:

cr1.DiscardSavedData = True
cr1.ReportFileName = "C:\myexcelreport.rpt"
cr1.Destination = crptToWindow
cr1.ReportSource = crptReport
cr1.WindowShowRefreshBtn = True
cr1.WindowShowExportBtn = True
cr1.WindowShowPrintBtn = True
cr1.Action = True



Is there any way to dislpaly only the desired area of the excel file in report ?|||Hey guys
Finally got the solution.............|||hi

do u know how to import the fields from crystal report to an excel spreadsheet

or

to import values resulting from a query to a spreadsheet?

Thanks.