Search results for query: *

Thank you. That worked.

I'm trying to extract the 6th and 7th position characters in a string. But I'm getting those characters plus the remaining characters in the field. Example, If I have 65478HTGF. I need to just show HT. I am using Mid(table.field,6.7) but I get HTGF as a result. Any help would be greatly...

Sorry, forgot to add formula I am using to get the "Overlap Error" If OnFirstRecord then False else If {@CurrentStart} in {@PreviousStart} to {@PreviousEnd} then True Else False

I am attempting to prompt a report user, when two range of dates overlap, so corrections can be made. I am grouping on customers id then in the details, showing how long they were provided services. Sometimes the range overlaps and is not always sequential. I have tried the previous and next...

Hello, I'm trying to convert a string time to an actual time. I've searched some of the formulas provided here but still can't get what I need. I am using - time(val(left({time.final_data_entry_time},2)),val(mid({time.final_data_entry_time},3,2)), val(right({time.final_data_entry_time},5)))...

I'm trying to find a function or create a formula that will check the 4th character in a 5 character string to see if it is an A, B, J or D. I've looked but cannot find a solution any help would be greatly appreciated.

Thanks for your help. I tried both formulas but neither worked. I still get the same error. The fields used to create the parameter data types are strings in Crystal reports, I don't know why it's not working.

I am trying to show all the values that are chosen in a multiple value parameter in the report header. I tried using Join({?parameter},','). But I keep geting the error "A string array is required here". The values in the parameter are strings but it still doesn't work. Any help would be...

Trying to figure out a way to do this. Using CRXI for reporting. In the report, I have two parameters, one for the user to select an ID the other for the user to select a date range. Does anyone know if there is a way to use either of the parameters and not have to select a value for both to...

Hello, Does anyone know of a way to indent the second line of a field that is wrapped? I have the first line indented. But do not know how to indent second line. Exapmle below Test for wrapping second line of a formula field. I want it to look as follows: Test for wrapping second line of...

Thanks for your help. I believe this will work. The only problem I am encountering is that the field I am using is a date field but I get the error "date-time is required here" because it is formatted as 9/17/2011 wereas in your formula the dates are formatted as 2011,09,01. Is there any way to...

Hello, I'm trying to calculate the number of weeks between two dates with a remainder of days left. For instance 10-01-11 to 10-18-11 should be 2 weeks and 4 days. I am using the following to get the number of weeks. But I am having trouble getting the it to show remaining days. If there are...

Thanks for your help but I don't think I am following your instructions correctly. I keep getting an error. This is what I have below. ( select max('date transferred') from table A where A.'ID' = mum_daily_subm.'ID' ) The name of my table is mum_daily_subm

I am using CR XI Trying to use only the record with the maximum date in running totals and grouping when more than on date exists for that entry. For Example: GP1 (ID) ID Date Transferred PPQ 01/02/2011 PPQ 03/01/2011 PPQ 05/03/2011 I need to further group by month which changes my...

Thanks, used the insert group#3 and that worked.

Do you mean a formula in the Section Expert of the Details section to get the Top N? Creating a summary only gives me the latest date of all the calls received in the footer. I am trying to see the last 5 records in the details section of the report. For example Urgent Joe Doe 3/7/11 3/5/11...

I have a report that is grouped by type of call. Emergency, Routine, Urgent etc. Then grouped by the person who answered the call. What I need to do then is show the last five records in the detail section by the date the call was received. I am familar with the group sort but it only allows me...

Thank you both for your responses. I will try something different since its no way to change the values.

I'm using version XI and but not through an applicaton.

Yes, I did.