Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. deemat

    Extract characters by position in a string

    Thank you. That worked.
  2. deemat

    Extract characters by position in a string

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

    Non sequential overlapping dates

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

    Non sequential overlapping dates

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

    String Time to Time

    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)))...
  6. deemat

    Check for character in a string

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

    Multiple parameter values in report header

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

    Multiple parameter values in report header

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

    Multiple Parameters Question

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

    Indent second line of a wrapping field.

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

    Number of weeks and days between two dates.

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

    Number of weeks and days between two dates.

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

    Grouping/Running Totals Problem

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

    Grouping/Running Totals Problem

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

    5 Most Recent Records by Date

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

    5 Most Recent Records by Date

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

    5 Most Recent Records by Date

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

    Default Value in Parameter Prompt

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

    Default Value in Parameter Prompt

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

    Default Value in Parameter Prompt

    Yes, I did.

Part and Inventory Search

Back
Top