Search results for query: *

Sorry, it's a little more complicated than that. What I have is version 9.0. I don't actually have a date/time field. What I have is seconds from January 1, 1990 (midnight). Below is the formula I have to use to create a date-time field. I call this formula, "Start Time" (DateAdd ("s"...

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...

Thank you everyone! It worked perfectly.

Hello Madawc, Yes, I already used a sub report, which works, however it takes hours to run. I was just hoping there was a different way. Thank you, Angie

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...

I was afraid that was the only way. I already did that, but the problem I have with putting the information from detail B in the report as a sub report is that I need this report as a sub report for another report. I do not believe I can use a sub-report that has a sub-report in it. The...

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 LB, This is what my selection expert formula looks like: {@Week} = {?Week} and {@Step} in ["150", "130"] and {@AddDate} > DateTime (2008, 01, 01, 0, 0, 0) and {@Year} = {?year} and {@WC Type} in ["Color", "Blank"] and not ({sfeventcds.kjobcode} in ["315755", "316566", "316858"]) I have...

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...

Thank you so much. It worked wonderfully, but I had to underlay GBb and when exporting to excel I had use set column widths of 200 otherwise it would merge cells and not allow for sorting.

I need to be able to export this into excel, but if there is GFb, then they won't be lined up and the Export will not work. Can I place everything into the GFb or does it have to be in the section below? Can I create another sub and add this into the report separately?

Sorry, they are in group footer two. Only the report header, page header and group footer two are showing. Everything else is hidden or surpressed. I do not have any GFa or GFb's. How would I reset these?

Okay, I have entered in the shared variables In the main report I set the actual seconds it took as Numbervar a: whileprintingrecords; shared numbervar a := (Sum ({sfeventcds.elapse-time}, {@StatCode})); In the sub report I have entered the estimated seconds it should take as variable y...

Would it work if I had the variable 'whilereadingrecords' instead of while printing records? I get a little mixed up on when the formulas are read (1st pass and 2nd pass).

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...

But if the value is negative I still want it to show red. Can that be done in formating?

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, '####') +...

Yes, but if I change it to Hours i get an error saying I need another ")" Angie

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...

Thank you both very much! This worked perfectly. Angie