Search results for query: *

You may be right. Thank you again for taking time to help.

the option is greyed out

My database is not SQL. I'm pulling from a single table in a DataFlex application.

With that said, if I ignore the Max_hours issue for now, what might be causing the report to return all records if I have the Record Selection formula set to Start/End dates, and the Group Selection formula blank? And thank you for your continued help on this - I really appreciate your time!

Record Selection Formula: {empldetl.TRAN_DATE}>={?Start_Date} and {empldetl.TRAN_DATE}<={?End_Date} Group Selection Formula: {empldetl.TRAN_DATE}>={?Start_Date} and {empldetl.TRAN_DATE}<={?End_Date} and sum({@Day_Total},{empldetl.CODE})>{?Max_Hours} Report is grouped on [empldetl.code} with...

I actually had the formula in both record and group. If I remove it from group, I get all the records (takes a 66 page report to a 1400 page report). Strange, but the group formula does appear to work, but on too many records.

Thanks for the help. I love the concept of doing this in the selection code, but no mater what I try, it won't limit my records (except for the date range). Here's my code in the group selection formula {empldetl.TRAN_DATE}>={?Start_Date} and {empldetl.TRAN_DATE}<={?End_Date} and...

Working with CR 8.5 Thank you for looking at this. Yes, I am grouping by employee, and summarizing. Suppression, unless I'm doing something wrong, works to a point. The problem I have with suppressing the group is that it also supresses the details for an employee up to the point when total...

I'm working on a report that gives employee total hours worked over a date range (entered as a report parameter) I want to limit the report to only employees who's totals exceed a number set in another report parameter. My question is how to run the report to get the totals, then select the...