Search results for query: *

I am attempting to write a report where it tracks each individual’s operational punches by day. I have having a hard time writing this report for third shift. Third shift is 10:00 pm to 6:00 am. The problem I am having is two different dates are actually one day for 3rd shift. Is there a formula...

Hello, I need help writing an if formula. Basically, I have two fields. The first field is a step number. The step number indicates what is going on in the specific job. There is step 100, 130, 150, 250, 230 and so on. Then there is an actual work center which is associated with the step...

Hello, I am working on a crystal report where I would like to display two different sets of detail. Currently what is happening is, the detail A and detail B sections come one right after another: Group Header 1 Detail A Detail B Detail A Detail B Group footer 1 I would like all the...

Hello, I am having an issue where we have three jobs that contain bad data. In our Database the field is defined for only 3 characters. However, the User Interface allows operators to input 8 characters. Now when I go to run a Crystal report it will not allow me to pull up any data and gives...

Is there a way to use a sub report value in a formula? What we have is 3 different databases. 1 for estimating 1 for planning 1 for shop floor data collection I need to get the estimated run time (from estimating) and subtract the actual time (from shop floor data collection). In order to do...

Hello, I am having a problem with my formatting. This is my formula: WhilePrintingRecords; NumberVar TotalSec := ({sfplan.mrtime}-{sfjobdet.mrtime}); NumberVar Hours := Truncate ( TotalSec / 3600); NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60); Totext ( Hours, '####') +...

Hello I am having a hard time writing a formula converting times. What I have is a field {PV_JobStep.LabourSecs} that shows how many seconds an operation should take. I need to convert that into 8 hour shifts, remainder in hours and minutes. The minutes are not showing as they should be...

I'm not sure if this is even possible, but at my corporation we have a label which is system generated from a Crystal 10 report. All the data in the Report is from our operations Database. Our sales Database is a completely different program not linked to this one and not linked to Crystal...

We are making core labels and as we run a job some rolls are bad and we will need extra core labels made from the start to count for scrap. We need to print 10 % over each time. Is there a formula for this? Also, for each of the products that have one label we need a box label. However we...

Hello, I really need some help. The way that our data was set up in our data base is causing a bit of a problem for one of our labels. What I need to do is Pull Data from Field X based off of Field A to look up the Value from Field X in Field A to return the final value, the one that will...