Micash
Programmer
- Dec 11, 2000
- 54
Hi there.
I have an app in VB6 and numerous reports. I am having no trouble doing formulas that involve basic records selection formulas in VB for crystal (records and groups). However I need help with a formula to show per person, events that exceed a determined amount.
Example: Peter takes 1 pen per week
the reports shows each person and the detail shows every WeekNo and the Date a pen was taken.
A summary(Count) on the WeekNo yields a figure.
Now in the GroupSelection (in Crystal) I can specify the Count >= 4 (for EG). This shows only the persons with 4 or more WeekNo's to their name. The lesser results don't show.
QUESTION:
How to construct a VB GroupSelectionFormula to get a similar result
Many kind regards
Micash
I have an app in VB6 and numerous reports. I am having no trouble doing formulas that involve basic records selection formulas in VB for crystal (records and groups). However I need help with a formula to show per person, events that exceed a determined amount.
Example: Peter takes 1 pen per week
the reports shows each person and the detail shows every WeekNo and the Date a pen was taken.
A summary(Count) on the WeekNo yields a figure.
Now in the GroupSelection (in Crystal) I can specify the Count >= 4 (for EG). This shows only the persons with 4 or more WeekNo's to their name. The lesser results don't show.
QUESTION:
How to construct a VB GroupSelectionFormula to get a similar result
Many kind regards
Micash