I am writing a report which is grouping data based on week, using the DatePart command:

DatePart("ww",{Submit Date},crSunday)

Now, I need to write a trend graph based on record types within those weeks, and I'm having trouble getting matches. I'm not very good with crystal syntax but I have a decent Perl background so I realize I need to loop this.

But when I use a Running Total, I can't get those to graph (undertanding that Running Totals print after all the records have been counted so I can't graph them on the fly.)

What could I use to match a condition where the date value of a record matches the current value in the loop?

I have tried something like this, but it's not really working:

Dim strLen
Dim x as number
Dim i
strLen = DatePart("ww",{Submit Date},crSunday)
For i = 1 to strLen
   if i = DatePart("ww",{Resolution Date},crSunday) then
    x=x+1
    else
    x = x+0
end if
next i

formula = x


Also, if this gets to working, how would I plot it on a line graph?

Thanks very much for your time,
Joe



Edited by joecarde - 15 Aug 2008 at 3:30pm