Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

Hi Thanks. I will try this first. Cheers David

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

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

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

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

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

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

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

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