Do you just want it to not displays the last days time? Use your for loop. Use the help file to learn how to use the date functions.

You want something like..

For i = Day({?DateFrom}) to (Day({?DateTo}) - 1) step 1

But, you have to convert {?DateTo} to a number, minus one day from it, and then convert it back to a date, and then use the day function. You can do it. You just have to use the date functions.

OK. I don't really under stand using the sum functions in formulas.

But first, the paramaters {?DateFrom} and {?DateTo} can be used in the "select expert" so you only get data in that range. Then everything you sum, will be in that range, because only data in that range will be allowed on the report.

Here's how I do sums.

In a group heading, put a formula like this to set and reset the sum:

shared numbervar mySumEmployeeOne := 0;
shared numbervar mySumEmployeeTwo := 0;
...;
shared numbervar mySumEmployeeTen := 0;

In the group footer, put a formula like this for each employee:

shared numbervar mySumEmployeeOne;

And, in the detail section, put a formula like this:

shared numbervar mySumEmployeeOne;
shared numbervar mySumEmployeeTwo;
...;
shared numbervar mySumEmployeeTen;

//could also use select case for this
if {tblLaborDetail.intEmployeeNumber} = 1 then {
     mySumEmployeeOne := mySumEmployeeOne + {tblLaborDetail.intPayHours};
};

if {tblLaborDetail.intEmployeeNumber} = 2 then {
     mySumEmployeeTwo := mySumEmployeeTwo + {tblLaborDetail.intPayHours};
};

...;
//Keep doing this for each employee.

Let me know if this helps any.

Right on. I have the same trouble getting around Crystal. It's seems like most things are much easier to just write a program.

That being said, Crystal runs like a loop, when you group by something. So, use your query, group by the employee id or name. The you have a group header, footer, and detail in the middle.

So, you would have a report that looks something like this:

GH1... Employee 1 start loop
Detail Line... Hour one (or whatever)
Detail Line... Hour two
...
Detail Line... Hour ten
GF1... End Employee 2 Loop
GH1... Employee 1 start loop
Detail Line... Hour one (or whatever)
Detail Line... Hour two
...
Detail Line... Hour ten
GF1... End Employee 2 Loop
Report Footer... Displays all the results from formulas

So, then use the formulas I suggest above, and you can calculate totals, and display at the bottom. That's if you want to have employee names in a row at the top, and have sort of display on the same line. Really, you don't even have to group to do that. You can use the page header to initalize the values, and the footer to display them, and suppress the detail.

That would work with a table with the following format:

Table
-----
Employee ID <---group by this
Work Date <---- Used to filter
Hours Worked <---- Field you want to sum

Anyway, it's hard to really know what you are going for just from post on a message board. It'd be better to see a sample report drawn out, and to have access to your database. Hope I sparked some ideas. Good luck.

There are two functions... totext() and tonumber().

You concatenate strings with the plus sign.

stringvar whatever := totext({empnum}) + totext({anothernum});

tonumber(whatever)

Does that make sense?

Edited by Duward - 05 Oct 2008 at 2:42pm