Liveware Publishing Support Forum

I am having a bit of a time with creating a report. I need to create a report that does totals by a range of dates. Here^s what I^m trying to do. I want to create a report that takes an employees piece work and total it by day. This report will be over a five day__period but I don^t want to hard code dates. The data will be coming from Clippership (a shipping program). Example:____Employee Date packages shipped__user1 04/01/04 200__user2 04/01/04 180__user1 04/02/04 197__user2 04/02/04 201____I think the best way to handle this is to create the date by subtracting from the system date but the user manual was of little help. Any suggestions?

Can you just set up a query for the date range?__If you want to see records for today and the previous 4 days you can create two calculated fields.__The expression for END would be DATE() and for START it would be DATE()-4____Then in the query you include all records where DATESHIPPED is greater than or equal to START and DATESHIPPED is less than or equal to date.____You then sort your records by dateshipped then employee and create a sum of packages shipped that resets by employee and place it on an employee group footer.____Kathleen__R&R Support____