String variable; Error: "A string can be at most 254 characters long"

[ajp18]

Hi,
I am getting error called "A string can be at most 254 characters long".

I have a string containing EmpNo(s) in the report that is built as emps' datas are added in the report.

I am using that string in subreport that resides in report footer to summarize data.
Any other alternatives beside using string data type.

 

[IdoMillet]

Option 1: upgrade to CR 9 were the limit is 64K.

Option 2: use several strings (several links).

Better yet, it sounds like the main report "knows" the employee population. Use the same exact logic (pass the main report parameteres as links to the subreport) in the subreport.

hth,
- Ido

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

http://www.MilletSoftware.com

 

[synapsevampire]

In CR 8.5 and below a formula (what you call a string) can only be 254 characters.

If you could post an example of your data and what you want output, you'll likely get better results.

-k

 

[Naith]

This thread handles a similar issue: thread767-586991

 

[Madawc]

You can use Length(Your_Accumulator) and Length({your.field]) to find if there's room, and go on to a second or third accumulator if it won't fit. You can then restore the look by putting the fields into a text object, where there are no length limits.

Madawc Williams
East Anglia, Great Britain

 

[ajp18]

Thanks for your reply every one. I am sorry I was away from computer for few days.

 

[ajp18]

how can you put the fields into a text object?

Thanks,

 

[Madawc]

In Crystal 8.5, create a text object, and leave it blank. Then drop in fields from your Field Explorer.

You can also use this for a mix of text and values, which I've found useful. The main irritant is that Crystal has its own way of enlarging fields, which mostly needs to be adjusted.

Madawc Williams
East Anglia, Great Britain

 

[ajp18]

Thank you very much