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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by keeno

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

Part and Inventory Search

Back
Top