Summary of a distict count

[ThaGooch]

I have a problem were I summerize a weeks woth of data into a total at the group footer and need to count each week. How can I do this without counting each day?

 

[IdoMillet]

To count how many week groups you have in the report you can simply use the GroupNumber function in the report footer (or create a Running Total of type COUNT that has an EVALUATE option set to once per each Week group.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ThaGooch]

That's true, but I think I explained myself wrong. I have days that have data related to them. Those days I roll up into 13 weeks and use the Sunday of each week to sum. Then at the end of the report I have a total summary of 13 weeks and them of course the total report summary. I am trying to count the weeks, but continue to only be able to get numbers of days sum. How can I count this formula:

{empdata.week} in Dateadd("ww",-12,minimum(lastfullweek)) to CurrentDate

And then count the weeks and not the day within the week.