Search results for query: *

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

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

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

Hello I wish to report on a specific field {FIELDA} which is no problem. However i wish to only display data for {FIELDA} when it's corresponding category field {FIELDB} is 'one of' October or November. I know I can just use the Select expert but I need to return all data but where the FIELDB...

Hello I'm running Crystal 9 and have a freetext field extracted from a SQL Database. The freeform field contains alot of paragraph spaces. Is there any way to remove these blank lines from the report either by function or formula. Thanks David

hello, i need to write a formula whereby i can say the number of issues i have open on a given date/time. Can someone advise if this easy to write. Instead of saying tell me everything opened on a specific date I need to know everything that is still opened on a specific date/time. Any help...

Hello Using Crystal Reports 9 and I have a field which I need to select 'One Of' from. One of the 'One Of' I need to select is if the field is Blank. I have tried this via the Select Expert but it doesn't seem to acknowledge null, blank spaces anything. Therefore I am asking whether I need to...

Hi, I am after a formula that will identify any records with a start/end date across a 96hr period (4 days). Any help on this matter would be greatly appreciated. Thanks Keeno

Hello I have a report which returns a number of 'Updates' in the details section of the report. I would like to restrict the number of details that is displayed so only the latest 'UPDATE' is displayed. Any help you can give would be greatly appreciated Thanks David

Hello I am trying to create a formula which will return me any records with a (Reported Date) up to 08:00am on the previous day. Can someone help me write this formula Many Thanks David