Search results for query: *

Hi Ido, thank you for responding, I did try that but and it works in a separate formula, but I'm unsure of where to insert it in this formula. Could you help me here. Lisa

Hi, I'm using crystal reports 10, with a oracle 9i database and have created a report defining the number of hours it takes to complete a work order. The business hours formula below is working just fine, but I need to exclude holidays from the total. Can someone help me add that part to this...

Can someone tell me how I take into consideration holidays into this formula. I got all of this to work and just need to remove holidays out of the mix. thankyou, Lisa

Thank you Madawc, that did the trick. L

Hi, using crystal reports 10, using data coming from an oracle database. I need to highlight a record when it is duplicated rather than suppressing it. Is there a way to do this? I have the following and need to highlight when the SR is duplicated. SR wo 102 1 102 2 103 1...

Hi, I'm using crystal 10, with oracle tables and I don't have the luxury of having a holiday/workweek table created for me. I need to report that calculates the how long it takes for a data entry clerk to key in the work order once they get it, but I need to exclude holidays and weekends. I...

Thank you LB this got me where I needed to be. Have a great weekend. L

Hi LB, I created the two formulas and then because I don't want to display only the groups that meet my criteria, I did you other formula. They all work like a charm. My only other question is how do I create a running total using the sum formula, it is not a option when I try to do a running...

Hi all, using crystal 10, with oracle tables. My enduser needs a report that shows all service requests that have a work order was responded to within 2 hours but that also has a work code of "RPR". One Service Request can have many work orders attached to it. I have a formula that calulates...

thank you both for your help. LB your's did the trick and got me the results I needed...L

Thank you turkbear, but unfortunately the same record can have both 'ESINV" and "RPLCS", that is why I was trying to both. Sorry that I didn't make myself clear. L

Hi all, I'm using crystal 10 and oracle tables. I' trying to do a running total that does the following. But I can't seem to not select RPLCS, while selecting ESINV since they are in the same table. I get the same results where I have the RPLCS statement or not and the totals are different...

Sorry I didn't explain myself better. Yes there are nulls in the date field. In the data base we have unique service requests numbers, but each service request can have many work orders tied to it. So the service request has a generated date and each work order has an initial assign date. I'm...

I tried what you suggested and I still don't get the records narrowed down. I looked at the sql statement and it looks correct. Tried rebuilding the record select and everything works find, until I add the work order initial assign date. Any other thoughts...L

I'm using crystal 10, with oracle and I'm trying to do the following record selection in my reports: {@wst to service area} in ["BASOM", "NORTH", "SOUTH"] and {SERVICE_REQUEST.WTR_SWR_IND} = "W" and {WORK_ORDER_WORK_CODE.WORK_CD} <> "HP" and {SERVICE_REQUEST.SRVC_RQST_GENERATION_DT} in {?Start...

I'm using version 10.0, I will look at what you suggest. I'm new to crystal reporting and not familiar with all that it can do. thank you, Lisa

Crystal 10, oracle I have a report where I need to calculate the total work orders completed by fiscal year and also for each week. I originally thought to create a subreport with the fiscal year date range and then in the main report use a parameter to select the week I want to report on...

Hi tek-tips: I'm using crystal v10.0 that accesses oracle tables. I need to distribute my reports to many users, I use to use v8.5 and the report compiler, but now with v10.0 I don't know how to do this, any ideas. Thanks, Lisa

I'm using crystal 9.0 that accesses oracle tables for the data. I have a report that I need to distinct count the total number of service requests numbers that were opened for a start and end date, I have start and end date parameters setup in my report. But then I need to count how many work...

Thanks so much, that was just what I needed. L