How can I display a field that has >256 characters? 2

[scc]

I am using Crystal 8.5. My data source is a stored procedure from SQL Server 7.

I have a parameter field that has more than 256 characters.

Crystal will only allow a string up to 256 characters. So I brought back the fields as 2 fields, one with the first half of the string and the other with the second half of the string.

I thought perhaps I could make a formula to concatenate the 2 fields, but I got an error saying that a string could only be 256 characters.

Any ideas how I can make this work?

TIA!

 

[lyanch]

Create a text box and drop both halves of the string into the box.

Lisa

 

[scc]

I'll give this a try when I'm back at the office today. Do you have to do anything special to get them to concatenate correctly (spacing...) or so they can grow?

TIA

 

[Madawc]

You may need to set 'Can Grow' on the text box. You don't need spacing unless you want to separate the two halves. And if they are text, Crystal will automatically keep words together.

Madawc Williams
East Anglia, Great Britain

 

[AptToWonder]

Hi.
I've got a little bit bewildered.
I came across this thread while looking for my trouble decision.
My project is built with Delphi 6. I use Crystal 8.5 RDC. Any time I try to pass a string value of more than 267 characters into IParameterFieldDefinition.SetCurrentValue I get 'access violation at 0xbla; read of address 0xbla' message.
But I've got NO troubles in Crystal reports Developer environment passing any length parameters.
What did you mean when you wrote
'Crystal will only allow a string up to 256 characters'?
Maybe your answer will become the answer to my problem.

 

[Madawc]

Crystal 8.5 has a limit on strings it will write, I think it's 254. This includes variables, i.e. if you do a date display that includes the month name, it might work in May but fail in September.

I'm surprised that there isn't a similar limit on parameters, but maybe it's because they don't have to be printed, with all of the possible complications that printing involves.

The string limit has apparantly been corrected in Crystal 9.

Madawc Williams
East Anglia, Great Britain