Search results for query: *

There is something that is not working. If the Action_ID is Not WO_OPEN OR HD_CLOSE that means that it is currently being worked so I want to display the currentdatetime. Should I make another Variable for CurTime if Action_ID Not in WO_OPEN, HD_OPEN?

Thanks fisheromacse & lbass the combo of the two worked. I don't know what you mean about including a reset in the group footer. I don't know if I need it, but if you can explain how to do it I would appreciate it. CLK

I removed the else not the then...

I just removed the then part of the formula and that removed the error. The WO_OPEN_DISPLAY is not working correctly it is only displaying two different datetimes for all records. I am not sure where the datetimes are coming from. In these examples it is showing 3/9/2010 8:55:35 PM Sample...

I am getting an error in the cltime & wotime formulas else cltime := ""; else wotime := ""; error message = A Time is Required here Any suggestions?

Hello- I am trying to expand on a report I already have to show how much time Tier2 works on a ticket. There are two action_ids that can happen HD_Close (this means they closed the ticket) & WO_Open (this means they escalated the ticket to Tier3. I have the formula working to get the time the...

I am grouping on incident #, but I only get one or the other for the starttime and the endtime. This is from the group footer for Incident# Incident # Startime EndTime 1,375,476 2/24/2010 7:21:08 AM 1,375,489 2/24/2010 7:36:24 AM 1,375,494...

You are right LB I didn't notice that. So that means I would need the last HD_FRWD_STAFF timestamp, so for Incident 1375494 it would be 2/24/2010 8:31:11 AM. Then I would calculate the business hours between the startime 2/24/2010 8:04:41 AM and the endtime 2/24/2010 8:31:11 AM . I just...

I changed the selection criteria to only include those action Ids' I need to calculate business hours between the two dates. So I didn't think I could use datediff. I am running into another problem that I didn't expect. HD_FRWD_STAFF multiple times. Here is the details section Incident #...

I have a report that is looking at table.details and showing a starttime or endtime based on criteria in the formula. Here are the formulas. @startime WhilePrintingRecords; DateTimeVar BeginDate; if {table.Details.Action ID} = "HD_FRWD_GROUP" then BeginDate :={table.Details.Date}; @endtime...

I have a timedate field that I just want see the time portion of. Is there a way to convert it. Example. 8:14:56 AM 2/24/2010. I just want the 8:14:56 AM portion. Thanks

I need business hours, where the <notificationtimedate> could be before the business hours declared in the formula. I didn't think that datediff can calculate that.

I was thinking about this more and was wondering if there is a way to write a formula that would change the {table.Notification.Date.Time} to (current date 6:00:00 AM) if it is less than (current date 6:00:00 AM) so in the example 1 above the {table.Notification.Date.Time} of 2/11/2010 6:36:00...

You can format the formula number field to show more decimal places 0.8888.

I am working on a report that need to calculate the number of business hours between two dates. The problem that I am running into is the first date is the datestamp of the email or voicemail so that can come in at any time of the day. But the SLA doesn't begin until our business hours start...

LB, you are my new BFF. I can't tell you how much time I was wasting scrolling through the field names looking for stuff. Thanks CK

Is there anyway to sort the database field names in Field Explorer? I am using Crystal Reports Developer version 11. I know in XI R2 you can sort the fields, but I can't find the option in version 11. CK

It is working now. When I supressed the details and put the running total in the report footer it works. Thanks so much LB

I changed the group to just group by TicketID, but it is still showing all 9 records even though 4 of those have work orders opened. CK

Here is the detail section. All tickets have the action ID HD_Open, it is system generated when a ticket is created. Incident # WO_OPEN Action ID 1,359,951 0.00 HD_OPEN 1,359,959 0.00 HD_OPEN 1,360,039 0.00 HD_OPEN 1,360,133 0.00 HD_OPEN 1,360,248 0.00 HD_OPEN 1,360,373 0.00...