Appending data to a string

[Leya]

Good day.
am using crystal reports 9! i need to display some data from an oracle database separated by commas.now i am appending these records to a string and displaying.But when the characters exceeds 64500 the report is crashing.How do i append more data?

 

[synapsevampire]

You're lucky you have CR9, CR 8.5 and below errored at 255 characters.

I'm not sure what the limit is in CR 9, but it sounds like you've hit it.

You can create a second formula, and if the length of the first formula > 60000, then use it, but in either case, this is an unappetizing approach.

If the field length is fixed (let's use 4 as an example), then create a smaller set of values in the formula, and display it when the number of rows appended to the string = 10 by using a counter in your formula.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Madawc]

Crystal hides its internal workings, but a limit of 255 suggests eight-bit control. We're on Crystal 8.5, but I'd assume Crystal 9 is using 16-bit control and that it simply can't handle more characters than can be expressed as a 16-bit number. Madawc Williams
East Anglia
Great Britain