I am using CR 10, and want to select records based on a sum.
For example, I want to select all groups who have a total number of hours less than my parameter.
Parameter (number)= @Hours
Group 1 = @EmployeeName
@TotalHours = Sum (ClockHours, @EmployeeName)
I want to display records when @Hours > @TotalHours
Suppressing the records work, (on the detail level,) but I cannot suppress the group headers based on @TotalHours.
I get an error message stating the formula cannot be used, since it must be evaluated later.
How do I get the formula to evalutate first?
Thanks!
For example, I want to select all groups who have a total number of hours less than my parameter.
Parameter (number)= @Hours
Group 1 = @EmployeeName
@TotalHours = Sum (ClockHours, @EmployeeName)
I want to display records when @Hours > @TotalHours
Suppressing the records work, (on the detail level,) but I cannot suppress the group headers based on @TotalHours.
I get an error message stating the formula cannot be used, since it must be evaluated later.
How do I get the formula to evalutate first?
Thanks!