Error: A string can be at most 254 char long

[vshapiro]

I am creating a fomula:

whileprintingrecords;
shared stringvar data;
if data = "" then data:= totext({@EntDate}) else data:= data + totext({@ExitDate})
and getting an error
A string can be at most 254 char long..???
What am I doing wrong????

 

[synapsevampire]

Are you trying to get a formula with all dates in it?

CR 8.5 and below only support 254 characters to be returned by a single formula.

Do you really need a shared variable?

If you explain what you want, someone may be able to help.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[vshapiro]

I need to combine multiple records into a single row in the report.
For example:
I want it to show like:
Project# Provider# Date1, Date2, Date3
1111 2222 1/1/01 2/2/02 1/2/02

This is actually three different records (same project#,
same Provider but each date - different record.
When I use variable - I am getting this error and actually
it shouldn't be more then 254 char long...???

 

[synapsevampire]

Group by the Project and Provider.

In the Provider group header place:

whileprintingrecords;
Global stringvar data := "";


In the Details Section place:

whileprintingrecords;
Global stringvar data;
data:= data + totext({@ExitDate})

In the Provider group footer place:
whileprintingrecords;
Global stringvar data;
data

The formatting will be a problem, if you need to, you can use an array and reference each element of the array.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[prgao]

Hi, all
I use crystal report 8.5, i created pie chart,
my problem is that the data label(percentage) for pie chart has two decimal, but for legend, it has one decimal, how can i make two decimal(percentage) for lenegd.

thanks in advance
prgao

 

[rosemaryl]

Dear pragao,

You should start a new thread when you change the subject so that you get the widest audience for your question.

It also keeps the threads clean <smile>...

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[prgao]

thanks for remaind, I am new in this websit
BTW, Can you help me about this question?

 

[vshapiro]

I still getting this message??
Can somebody help me please????!!!!!!!!!

 

[deepsheep]

How about a Trim()? If you have char fields, empty space could easily put you over the limit.