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.
-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...
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...
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...
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...
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!!!
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.
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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.