Hi, everybody,
Tried to insert following formulas in one report of Crystal Reports:
@pippo placed in the detail section:
whileprintingrecords;
numbervar pippo;
pippo := sum ({LOCATION.SRLO_EFFECTIVE_VALUE});
@results placed in the group footer:
whileprintingrecords;
numbervar pippo;
@Reset...
LB, sorry, it took a while!
Everything ok, but every time the date is changing, it counts the hours double.
I also would like @Results to round up to entire or half numbers: how to do that?
Finally with this report I am trying to sort data from 2 different databases. The one for badging and...
Thasnk you very much, LB ... and again compliments!
This works fine now.
My next questions now are:
Having detailed records as:
15/12/19 13:44:24 IN
15/12/19 22:09:08 OUT
1) How to create a formula telling me that this time interval corresponds to an afternoon shift (standard 14.00 - 22.00)...
Compliments LB! look really nice.
Only one problem.
Calculation is ok for all components inside group 1, meaning that all IN and OUT date are calculated regularly. @hrswkd will show the same amount in the raws of IN and OUT, as well as in @Result.
But on last IN and OUT couple of each group 1...
Hi,
Sorry for late answer, ver busy this morning!
Our pracice is that the hours will be calculated in the day I start to work, so in the IN day.
IN and OUT are in a separated field, just in case I have to use it in the formula.
the total worked hours should appear in the group 2 header, the...
Hello, everybody,
Tried many things but cannot get a good result.
I have created a group 1 with user ID and a group 2 with date.
Then in details I have all entries related as i.e.
08/12/19 05.43.59 IN
08/12/19 15.19.00 OUT
This user worked in first shift. All entries are sorted with a IN...
Thank you very much, it works perfectly!
I am so happy to finally discover to not be alone (with sometimes real headache)! why didn't I do that before!
Another question: is thsat a way to bring the result at the same level of the main report in detail_a?
One more time thank you very much.
FZ
Hello, everybody,
New in this Forum,
With CR 2008 Version 12.3.0.601 I have created a subreport and edited a formula as follows:
//@SubFormula
//Returns the value that was stored
whileprintingrecords;
Shared DateVar DataCompletamento;{FOLLOWUP_STEP.WFFS_COMPLETION_DATE}
(note: if I try to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.