Search results for query: *

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

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.

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

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

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

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

Hello Everyone, I am attempting to have a default value shown when a user is prompted to enter a parameter and also when the report is refreshed. For example, when a user has to enter a lastname, instead of the parameter field being blank it shows lastname. Also when the report is refreshed or...

Hi everyone, I am using CRXI to create reports. I have customers in my database that belong to more than one group (ex.John Doe belongs to group A, B,C & D). I only want the customers that belong to groups A and B. I have record selections showing this but it also shows those belonging to A...