Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CLKCLK

    Group Footer Date Formula

    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?
  2. CLKCLK

    Group Footer Date Formula

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

    Group Footer Date Formula

    I removed the else not the then...
  4. CLKCLK

    Group Footer Date Formula

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

    Group Footer Date Formula

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

    Group Footer Date Formula

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

    Suppress fields to Export to Excel

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

    Suppress fields to Export to Excel

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

    Suppress fields to Export to Excel

    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 #...
  10. CLKCLK

    Suppress fields to Export to Excel

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

    timedate conversion to time

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

    Timestamp prior to Business Hours, but need to know business hours

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

    Timestamp prior to Business Hours, but need to know business hours

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

    Formula help

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

    Timestamp prior to Business Hours, but need to know business hours

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

    Sort of Database Fields in Field Explorer

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

    Sort of Database Fields in Field Explorer

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

    Duplicate records in Count

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

    Duplicate records in Count

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

    Duplicate records in Count

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

Part and Inventory Search

Back
Top