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!

  • Congratulations Chris Miller 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. cuttyfunk81

    Parsing Data from Memo

    LB - Thanks for testing it. I just did it again and I am still getting the same thing: 254 characters. I'm on Crystal 2008 and connecting through ODBC to a Microsoft SQL server.
  2. cuttyfunk81

    Parsing Data from Memo

    -LB Wanted to give you an update here. It seems the maximujm character limit allowed when using the extractstring() function is 254. No matter parameter I use for the second argument in the extractstring() function, the len(x) is always 254. I'm going to try and get creative by splitting...
  3. cuttyfunk81

    Parsing Data from Memo

    Here is another example from a different record in the report that shows the data being cuttoff: What the formula is displaying: 11/1 (Briana) I have e-mailed Oleksiy and Travis Hobbs (OK site) to collect the motion traces and CAN of the LS. The sense data 5:3b:0e indicates that the library...
  4. cuttyfunk81

    Parsing Data from Memo

    LB - Yes, I did select "can grow" and this is not in a subreport.
  5. cuttyfunk81

    Parsing Data from Memo

    Thanks LB - Its really close now but for some reason is cutting off before the start of the next note. Example below: 10/28 (Briana) Problems with IP address were captured, and will be resolved in the next firmware release. The expectation has been set with the customer that drives are...
  6. cuttyfunk81

    Parsing Data from Memo

    An update: Revised the formula provided to have a close ) at the second line of code. This removed the error described above. Now, the formula does not have an error, but when I run the report, I get the following message pop up: "String length is less than 0 or not an integer." Below is my...
  7. cuttyfunk81

    Parsing Data from Memo

    LB - Thanks again for your help so far. I tried your most recent formula this morning and got the following error: "A number, currency amount, date, time, or date-time is required here" It is highlighting the "left(x,len(x)-2))" portion of the formula. Any advice? Thanks!!!
  8. cuttyfunk81

    Parsing Data from Memo

    LB- Here is the code I used: stringvar array x:= split({Incident.Incident Resolution},"(Briana)"); if ubound(x)>=2 then left(x[2], len(x[2])-6); I had originally put ***** in place of the person's name who made the note.
  9. cuttyfunk81

    Parsing Data from Memo

    An update for you if it helps... I revised the formula you gave me to only show: stringvar array x := split({table.memo},"(*****)"); ubound(x) This displayed a number, which from my understanding is the count of the defined array in the memo. So I know the first part of the formula you...
  10. cuttyfunk81

    Parsing Data from Memo

    LB - Thank you for your response. I entered the formula you suggested and while I do not get any errors, the report is not displaying any data for that formula. Any other ideas or suggestions on what I might be doing wrong?
  11. cuttyfunk81

    Parsing Data from Memo

    Hello Guys - New to the forums and new to Crystal Reports 2008. I have been asked to generate a report from our support database that only shows the most recent note added to the field. The problem that I am running into is that the entries are not seperated into seperate fields by the day...

Part and Inventory Search

Back
Top