Comma Delimited String Parameter Output

[jhansard]

I have upgraded from CR 7.0 to CR 8.5 and have noted that on input parameters that contain commas in the response string in CR 7.0 and CR 8.5 create different results on output. In CR 7.0 I would place the input parameters on the footer of the report so the user could see the values they input to create the report. In CR 7.0 the parameter listed would show the several comma seperated values they input. Although the logic processes the same now in CR 8.5 the parameter listed on the footer only shows the string before the first comma. Is there a way to force CR 8.5 to show the whole parameter input string like it did in CR 7.0?

 

[rogar]

CR 8.5 uses an array rather than a comma-delimited string to store multiple parameter values. The Join function can be used to convert the array into a string.

 

[chelseatech]

You might want to check you've set "Can Grow" on the parameter field formatting in the report. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

faq149-243 shows you how to write formulas that display the entries in Multiple and Range parameters, by version. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[jhansard]

Therefore I understand everyone to agree that when I enter a person's name like Smith, John to perform a lookup on for reporting purposes then the input parameter will treat this as an array of two elements with the contents of Smith and John and then match based on this instead of "Smith, John" as it did in CR 7.0? Even though the parameter setup has multiple entries disabled for this input? This in part the concern I have from my original posting.

 

[kenhamady]

I don't agree. Sorry I must have missed your point.
If you use a single discrete value parameter, and you enter

Smith, Joe

It should treat this as a single string with a comma in it.

I just entered this into one of my parameters and then wrote a formula that was:

{?test} + {?test}
and it gave me:

Smith, JoeSmith, Joe Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com