Minimum time not showing for certain fields

[mravimtnl]

Hi all
I am preparing a report which depicts First In and Last our Punch of employees in crystal 8.5. I have database of all the punches in one field. I had created two formulas one for enty punches and other for exit punches and then summarized entry punches for Minimum and Exit Punches for Maximum for obtaining first in and last out.

Problem: Crystal is shwoing First IN Punch for certain days only and remaining days a blank filed is appearing.

 

[lbass]

Please show the content of the two formulas you are using. Also explain how you created the minimum and maximum summaries. It would help if you showed some sample data too that illustrates the issue.

-LB

 

[mravimtnl]

The formula that are used are:

1.if {xaction.x_term_name} like "*entry*" then time ({xaction.x_timestamp}); for extracting entry time

2.if {xaction.x_term_name} like "*exit*" then time ({xaction.x_timestamp}); for extracting exit time

Then I summarized formula values usng Minimum and grouped them by time stamp.

These two files are uploaded 1st one -the rpt file and the second one the report obtained from rpt in pdf format. The links are given below.

http://www.mediafire.com/?tva0yc52k4qn0tb

http://www.mediafire.com/?y8ou9ase96la5wn

 

[lbass]

The problem is that the default time for records that don't meet your "entry" criteria, which would be all exit entries, is time(0,0,0), which would often be the minimum and which would appear as a blank. You need to change your entry formula to the following:

if {xaction.x_term_name} like "*entry*" then
time ({xaction.x_timestamp}) else
time({@null})

...where {@null} is a new formula that you open and save without entering anything. Then the default will be ignored when you apply the minimum.

-LB

 

[mravimtnl]

wonderfull thank you very much for your help.

 

[mravimtnl]

Hi
another problem.

I want to get wages as per skill category of employees. User will input the wage data and the system should assign the wage as pe skill category.

The data in the table is stored like this for each badge number:

Gen Id Ud (Boolean)
17 1
18 0
19 0
20 0
21 0

that is 17 for unkilled, 18 for semi skilled, 19 skilled, 20 highly skilled.

I have written formula like this

numbervar P;

if (genid=17 and ub=1) then P:={?unskilledwages}
else if (genid=18 and ub=1) then P:={?semiskilledwages}
else if (genid=19 and ub=1) then P:={?skilledwages}
else if (genid=20 and ub=1) then P:={?highlyskilledwages}
else P:=0;
;

But crystal is givng 0 values for every batch.
regards
ravi

 

[lbass]

Please start a new thread since this is a new topic, and also when you do, show your actual formula, not a mockup of it.

-LB