Search results for query: *

I did as you suggested but it didn't work. When it looks at the parameter in the record selection formula it prompts stating "a date-time is required here". Besides that when I tested the formula as indicated with the date(1970,01,01) it threw my date and time off. The date cannot be...

I've tried it but it won't convert the value into a date, the parameter is looking for a digit. The {CallDetailRecord.dateTimeConnect} field is a Date and Time value which represents the number of seconds since Midnight (00:00:00) January 1, 1970. I am using Crystal Reports 8 Professional and...

I don't have a problem with using {CallDetailRecord.dateTimeConnect} in the detail section of my report with the formula listed above labeled @Start. But, I can't create a Parameter using a Formula. My problem is that I would like to create a "Parameter" using...

The UTC timedate field which is in seconds (example: 320,251,407) to a standard time and date (example: 5/1/2002 7:10:07AM) I am unable to seperate the date from the time.

I am trying to create a Parameter using a UTC Date Time field,{CallDetailRecord.dateTimeConnect}. This is a numberic field and I would like it to appear in the Parameter as a date and not numbers so that the Parameter will allow a Date Range. In the "Detail" area of my report I've created...

I did do that except it was: @{table.date} in lastfullmonth Then I received the following message when I went to Select Expert to check if it was in correctly (since I was getting all months): "Composite expression. Please use the formula editor to do editing." I don't know why it didn't...

I have created a @TimeRange formula and have gone by your instructions and used this formula as a group. I also had to use the specified order. It does break down the time by time groups but . . . it overrides my formula for another field to use "is in the period of last full month". So now...

I would like to group all my records for an entire month by time ranges. Such as all calls for the month of May made between the hours of 07:00:00 to 09:30:00. I am currently using the following formula to convert the UTC timedate field which is in seconds (example: 320,251,407) to a standard...

If in your report design you have inserted a Group, with the option to "Keep Group Data Together", perhaps the Group Data exceeds what can be placed on the first page because of the Report Header. In the Design view of your report, Right Click in the gray area of the Group and select "Change...

I am using the following as my formula for phone numbers: picture({CallDetailRecord.callingPartyNumber},"XXX-XXX-XXXX") My problem is that this is picking up our 5 digit extensions (ex. 15330) as 153-30-. How can I set up a formula to use the "XXX-XXX-XXXX" when there are...

I am so embarrassed to ask - but I've tried creating a formula using the two {@start} and {@DST Start}, it went like this: {@start}+{@DST Start} and it changed my Start month in my report from October to November. How do I use the result of {@DST Start}- see formula below If {@Start} in...

This question was reworded and solved. To see how check: Formatted "elapsed time" string - no days, increase hrs answered by Ken Hamady.

Ken, I have tried your suggestion and have created a formula called "DST START" and it goes like this: If {@Start} in //@Start is my Start Date Date (year({@Start}),4,7) //4,7 is for April 7 to Date (year ({@Start}),10,26) //10,26 is for Oct 26 then 20...

I am currently using the following formula to convert the timedate field which is in seconds (example: 320,251,407) to a standard time and date (example: 5/1/2002 7:10:07AM). {CallDetailRecord.dateTimeConnect} / 86400 + DateTime (1969,12,31,20,00,00) Note: In the formula after the...

I found a formula to use that is helpful from Ken Hamady's web site. However I would like to edit it by doing away with the "days" and carry over that time to allow the "hours" portion to increase. Here is the formula I'm using: WhilePrintingRecords; NumberVar TotalSec :=...

I have been using the following formula and am unable to get a sum that exceeds at total of 23:59. Sum ({CallDetailRecord.duration}) + Time (00,00,00) What I want is the Sum to display the total duration of time spent on the phone by a department during a specified month. The total hours must...