need to change Crystal report String value

[former_member487237]

Hi all,

Im having project codes with 8 to 15 digits.In AP or AR invoice, the project code is taking first 8 digits only. How can I change the string value to 20? What all the possible ways to change? And how to find that particular stored procedure which is belongs to that crystal report?

Waiting for the reply.

Thanks & Regards,

Saikrishna.

[former_member487237]

Hi,

i want to extend Project code string value to 20. Where i can change the value?

Can anyone help me out in this?

Thanks,

Saikrishna.

[Former Member]

You cannot change it as the field has a defined value of 8 when it was created in the database. The only way to change it the way you want is to modify the appearance of the code on the report.

[former_member487237]

Hi,

The string value is 8 characters only. But I want to extend it. Even i'm unable to find my SP which is belongs to that CR. How to find? How can i extend the string value?

Thanks & Reards,

Saikrishna.

[julie_jamieson2]

Have you opened the report in the CR designer to see what the data source is?

[Former Member]

Hi Saikrishna,

Check the field length of the table you mentioned. I believe it is only 8 characters. In this case, nothing can be done to change them.

Thanks,

Gordon

[Former Member]

You can use the totext function to add leading zeroes.

totext({YourTable.YourField}, "00000000000000000000")

[former_member487237]

Hi Thomas,

Thanks for the reply. Can you please explain little bit elaborately?

Regards,

Saikrishna.

[Former Member]

Create a formula and add the totext function as in my reply, but be sure to replace {YourTable.YourField} with the appropriate table and field.