Limit on number of characters in a string 1

[mdtimo]

A string can be at most 254 characters long.

I get the above error message from the following formula when I try to add in more line of narrative.

Maximum ({@Desc1 }, {@grouper})
+" " + Maximum ({@Desc 2}, {@grouper})
+" " + Maximum ({@Desc 3}, {@grouper})
+" " + Maximum ({@Desc 4}, {@grouper})
+" " + Maximum ({@Desc 5}, {@grouper})

This is what {@Desc 2} looks like in the detail
if {timedesc.tdline}=2 then {timedesc.tddesc}

My database has a table that displays description of work done. the first field is the index, the second is the item number and the third is the line number and the fourth is the actual narrative.

2 2 1 Drafting and revision of London settlement
3 2 2 agreement; left phonemail message for J. Doe
4 2 3 regarding appeals; telephone conference
5 2 4 with R. Doe regarding ADR appeals;
6 2 5 telephone conference with D. Doe; review
7 2 6 opinion letter and other settlement estimates;
8 2 7 review press release regarding judgment;
9 2 8 review materials from J. Doe.

I want all the data in one field so that I can export it to excel into one field.

Any ideas?

 

[IdoMillet]

Move to CR 9 or break the formula into two formulas and drag both of them into a single Text Object on the report Layout.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Reebo99]

What version of CR are you using?

I'm using CR9 and it doesn't seem to have the same problem. I created 2 parameter fields with 250 "W" in one and 250 "X" in another then created a formula {param1}&{param2}.

It displayed no problem. Reebo
Scotland (Going mad in the mist!)

 

[mdtimo]

I am using Version 8.0. I am not having success with when I break up the forumula, it seems to export into excel into two columns. I have a blank text object on top of the two forumulas.

 

[IdoMillet]

You must drag the formulas INTO the text object. Start by typing something into the text object. Then drag the formulas in. Then remove the initial text.

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com