I am trying to create a cross-tab report that will only print data if employee data exists for 5 consecutive days. So I'm trying to use the distinctcount function with this format:
DistinctCount({table.DATE},{table.PERSONID}) => 5
I'm doing this in the selection criteria > group function.
When I save the formula, I get the error:
"The summary / running total field could not be created" with no other information.
We're using Crystal 8 on SQL Server 2000.
Any help would be appreciated.
DistinctCount({table.DATE},{table.PERSONID}) => 5
I'm doing this in the selection criteria > group function.
When I save the formula, I get the error:
"The summary / running total field could not be created" with no other information.
We're using Crystal 8 on SQL Server 2000.
Any help would be appreciated.