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!

  • Congratulations IamaSherpa 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: *

  • Users: keeno
  • Order by date
  1. keeno

    Crystal X1 - Scheduling Formula

    Its ok. i am an idiot. It works fine. many Thanks for your help
  2. keeno

    Crystal X1 - Scheduling Formula

    Time is not necessarily needed no. However.... For fear of annoying you. I get the followng error message when using this Date only formula. the error is focussing on the following part of the formula: Dateadd("d",-1,CurrentDate) The error message is "A Date-Time Range is required here" Thanks
  3. keeno

    Crystal X1 - Scheduling Formula

    Thanks. When i apply this formula: ( if dayofweek(currentdate) = 2 then {@Reported Date} IN DATETIMESERIAL(DATE(CurrentDate - 3),TIME(8,30,00)) to_ DATETIMESERIAL(DATE(currentdate - 1),TIME(8,30,0))] else {@Reported Date} IN DATETIMESERIAL(DATE(currentdate - 1),TIME(8:30,0)) TO_...
  4. keeno

    Crystal X1 - Scheduling Formula

    Hi We are using Crystal X1 on Oracle Database and also use BO enterprise Server. We currently have a report which currently requires us to specify a Submit Date in order for it to be run. The report looks for all tickets which have submit date/time of 08:30am the previous day. Except a Monday...
  5. keeno

    Display Related Records

    Hi Im using Crystal Reports XI on Oracle 10g database. We have 2 tables in the report PROBLEM_TABLE and INCIDENT-TABLE. The fields in question is the PROBLEM_DESCRIPTION and INCIDENT_DESCRIPTION field. The report is showing PROBLEM information but we require the report to show the INCIDENT...
  6. keeno

    Grouping Problem

    Hi Im using Crystal XI on an Oracle Database. I have a fairly compelx report which has 4 groupings applied. Group 1 - Ticket Details Group 2 - Work Info Details group 3 - related Tickets Whats happening is that the group 3 heading is duplicating for every group 2 heading I have. So if I have...
  7. keeno

    Number Field Conversion - Help Please

    Thanks. However this formula has now rounded down to 8 and is 8:00 when i apply the colon formatting you mention. Any ideas what i can do to keep the number as 8:42 Many Many Thanks For Your Help
  8. keeno

    Number Field Conversion - Help Please

    Thanks for this. This has rounded the field up so 8:42 has become 9. Is there anyway I can avoid this rounding up and it display the actual number 8.42 as a number Appreciate your help on this Thanks
  9. keeno

    Number Field Conversion - Help Please

    Hello I have a Number field (Minutes.Duration) which is showing time in Minutes. I need to convert this field to Hours. However when i do that using the formula: ToText({Minutes.Duration} \ 60, 0, "") & ":" & ToText(Remainder({Minutes.Duration}, 60), 0, "") It shows the time in Hours (eg...
  10. keeno

    Conerting a String Field to Hours/Minutes

    Hello I have a string field (DURATION) which currently shows number values like 48.0 etc which i need to convert to display Hours and Minutes (Something like 48:00) I am running Crystal Reports XI against an Oracle 10G Database Your help would be greatly appreciated Kind Regards David
  11. keeno

    Simple Formula (I Hope) Assistance

    Hello I am using Crystal Reports XI on an Oracle database I need to convert a Field (DURATION.TIME) from Minutes to Hours and Minutes. Can someone advise what formula i need to apply to the DURATION.TIME field to show as HH:MM Many Thanks Keeno
  12. keeno

    Crystal Report - Performance Issue

    Hi Thanks. I will try this first. Cheers David
  13. keeno

    Crystal Report - Performance Issue

    Hi Im running Crystal XI and Oracle 10g Database. I have one specific report which runs incredibly slowly. It is not an overly complicated report but it will take an hour to return any results. I am by no means a Crystal expert as self taught through a 'For Dummies' book. I am only reporting...
  14. keeno

    Query - Retrieving Data between certain times

    Hello I would like some assistacne with how I can extract specific data. I have a report in Crystal XI which retrieves the number of records on a daily basis. However I want to be able to only return records which have a SUBMIT DATE/TIME between 02:00am and 06:00am on each day. Is there a...
  15. keeno

    How To Average a Date Field

    Hello I have a date field in my report which shows the amount of time in hours taken to receive payment. When i try and do a summary fo the field there is no option to obtain the Average. Does anyone know of any way to get the Average on what is essentially a date field? Is this possible at...
  16. keeno

    Time Calculation Assistance

    Hello I a trying to write a formula to show time elapsed between two dates in Hours. The Dates are "SUBMIT DATE" and "DELIVERY DATE" and ideally i need a formula whereby: "Delivery Date" - "Submit Date" = Difference in Hours. If anyone can give me any pointers on how to write this that would...
  17. keeno

    Select the latest Date Entry for field

    I may not have been clear - my apologies. I have a number of records which all contain a SUBMIT DATE Field. I want to display only the record with the latest SUBMIT DATE How can I do this Thanks David
  18. keeno

    Select the latest Date Entry for field

    Hello I am running Crystal XI on Oracle Database. I have a field in my Database called "Work_Log". Each record has a number of "Work_log" Entries I would like to run a formula where only the latest "Work_Log" entry is displayed in my report. The date field is "Submit_Date" If anyone can help...
  19. keeno

    Formula Conversion Assistance

    Hello I am running Crystal Reports IX. I thought i had a formula whih would convert a number to text. This is the formula i was using: if {HPD_Help_Desk.STATUS} = 2,000.00 then Trimright("Duplicate Of") else However i get the message saying The Keyword then is missing. What am i doing wrong...
  20. keeno

    Value is null or does not equal

    Hello I'm running Crystal Reports IX on a SQL Database and I am having a problem with what i thought was a simple formula. I want to only display records which have an entry of "null" or is not equal to "Duplicate" The formula I have is: (isnull({HPD_Associations.Association_Type01}) or...

Part and Inventory Search

Back
Top