How to Code By Shift

[rhurd]

I have a database called Picture. Picture.rtime is the amount of runtime and has to be /60. and is a charactor field. Picture.shift is numeric and has fields 1 through 6.
Picture.datestamp is datetime field. I am trying to do a fomula for each shift 1,2,3 for each day. Can someone show me how the fomula shoud read.

Thank You Dick

 

[Turkbear]

Hi,
What do you want the formula to resolve to:
Shift?
Time span for shift?
What shift if given a time and/or date?

More details please...

 

[rhurd]

WE are looking to show each days by date range shift1 and 2 and 3. we would have to add up runtime for each shift in date range

Dick

 

[lbass]

It really depends on how you want your report to display. The simplest approach would be to create a date range parameter (if you want to select different date ranges at different times) and use this in your selection formula. Then group on date, group on shift, and enter runtime as a detail field that you can insert summaries on at each group level.

Another approach would be to use a crosstab with date as the column, shift as the row, and runtime as the summary field.

Since runtime is not a numberfield, you would need to convert it to a number before using it as a summary field. You could try:

val({Picture.rtime})

-LB

 

[rhurd]

All I need to know is how I get each shift

val({Picture.rtime})/60

How do I code Picture.shift = 1 for shift 1.
2.
3.

 

[lbass]

Isn't {Picture.shift} already defining the shift? I thought that the values 1 to 6 represent six different shifts. If this is not the case, you need to provide more information about what the issue is.

If the numbers do represent shifts, then just group on {Picture.shift}, and add your formula, let's call it {@runtime}, to the details section:

val({Picture.rtime})/60

If you right click on {@runtime}, you should be able to insert summaries on it, which will give you results per shift, and per day, when you choose "insert summaries on all groups."

-LB

 

[synapsevampire]

Please define what each field is, show sample data, and expected output.

As you can see, text descriptions leave too much to the imagination.

-k

 

[rhurd]

How can I send a sample of the file with data saved.

Crystal reports 9

What I am trying to do is put all three shifts on a chart in diffrent colors. I can drill down on shifts and see diffrent breakdowns but that not what i want.

I also would like to do feet per Min on another chart by shift and need to know how to hard code for each machines goal.

regards

Dick