Stored Procedure Parameter Array working, now need results to show as parameter descriptions

[hmax]

The following arrays work for the local report parameter that allows multiple values.

1. //join({?ParameterName},",") //Show list horizontally
2. //join({?ParameterName},', '+ Chr(10)) //Show list vertically

However, these only display the parameter default values (matching the codes retrieved from the stored procedure statement).

Next goal - show the parameter "description" results, with or without the code results. How is this achieved, please?

Thanks in advance for your help.

 

[pmax9999]

Have a look at this very recent thread:

http://www.tek-tips.com/viewthread.cfm?qid=1768050

Cheers
Pete

 

[hmax]

Thanks, Pete!

So Crystal Reports 2016 has addressed the issue. Great.

Otherwise Ken Hamady's solutions for earlier versions, e.g., creating 2 arrays for codes and descriptions plus a For Loop. Good for fairly short lists; tricky when the list is long, but do-able, I guess.

Appreciate the feedback.

 

[pmax9999]

Or the solution I provided in that thread if there is a look-up table that provides a description for the code.