Search results for query: *

Ha! It works! I figured out what I was doing wrong and you don't wanna know. LOL You're the best! thanks.

Nope, followed your directions exactly, still no luck.

Hi again, that's actually where I first started out trying it myself, but I can't get a summary on the {@FMS} and {@FSS} fields.

thanks I'll try it that way.

thanks LB. I've never worked with crosstabs so I'll give it a shot and let you know how it works out. I'm on crystal 8.5. Sorry for leaving that out. thanks.

sorry it looks so sloppy!

Hi, Help...I'm having difficulty. I have a field on labor entry screen that allows the input of daily scrap numbers. The scrap field requires a reason code each time the qty is added to that field. I have two reason codes - FMS and FSS. The report needs to total each of these reasons separately...

Hi K, The fields are character fields. We're using V9 of Crystal. I'll run what you said by our tech guy and see if he can figure out this. We currently use Progress Report Builder and are in the process of converting and redesinging in Crystal. RB does allow us to sort on those fields. If I...

Hi, We enter data into reference fields and description fields to be sorted in different ways. Crysal apparently calls this a "blob" field and won't let me sort on these fields. This is crucial to the way we do just about everything here. Is there any way to make this work? Thanks.

Ro, IT WORKS! Thank you, thank you. Thanks to you and to synapsevampire (and anyone else that contributed) for your help. It's been much appreciated. Geez, now I can actually get some of my other work done today. :) Thanks again, Carla

Same thing. Numeric overflow. I did cut and paste your formula earlier and didn't get that message but now I am. I think my system is tired and probably having some memory issues at this point. No sense proceeding until I give it a reboot. Crystal tends to crash on me now and then when I work on...

K, thanks. Says a string array is required.

Ro, I forgot to mention that the Actual time field is a decimal field, the adjusted is a character field.

Thanks Lisa but now I have an error that says "numeric overflow" I need a vacation (and a raise). LOL

Ok, one more try. :) Here's a sample. Act in Adj in Act Out Adj Out Total Hrs 18.70 19:00 6.75 6:45 11.25 6.75 07:00 15.50 15:30 8.00 Here goes. If you look at the second line, the actual time clocked in shows 6.75 but in...

Thanks again Ro, but now it's just telling me that everyone clocked in at 12:00. I think I'm going to give up for today. I appreciate your help. thanks

Ro, thanks, but it doesn't seem to be working. The formula keeps coming back with an error. Following I've pasted the formula exactly as I've written it replacing my field. Help. I've been working on this for hours...grrrr. NumberVar ttime = {LaborHed.ActualClockInTime} Time (truncate...

Hi, I have to do a time calculation for a report based on operators punches in Vantage 6.1. We run a 24 hr day, with shifts that range from 8 hrs, 10 hrs, 12 hrs, etc. It varies. Vantage calculates the time on a 24 hr day (7 p.m. = 1900) If someone clocks in at 18.75, I need my report to show...