Crystal 2013 does not display dynamic parameter description instead of value when using Join

I am trying to avoid using a subreport to display the user's selections from a dynamic parameter.  I set the parameter to Show Value or Description = Description.  Then I created formula, Join ({?Provider Type},',') and put it in the Report Header.  It displays the Values selected, not their descriptions.  Then I pulled {?Provider Type} into the Report Header.  It displays the Description associated with the first parameter selection.  Everything I have read says that the Join should work.  Any suggestions on why this doesn't work?  Has anyone else had this problem?  I was so looking forward to this change in Crystal, but it appears that it doesn't work or there is some trick that I am missing.  Thanks.
dizmaRiderAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I have seldom used the description as part of the parameter so I created a report in CR 2008 and tried it.
IN the prompt it shows both fields but when put on the report it only shows the primary.

I then used CR2013 to create the same report.  I set the parameter up just like you did and got the same results.

I assume what you want is say for cars
Make    Model
Honda   Accord
Ford        Taurus
Toyota    Prius


Prompting will show
Honda - Accord
Ford - Taurus
Toyota - Prius

Select Ford and Honda
WHen showing the parameter you get
Accord

WHen using the JOIN formula
Honda
Ford

What you want/expected is
Honda - Accord
Ford - Taurus

or
Accord
Taurus

Sounds like a bug or what you expected isn't what they meant.  I will research to see what the changes in CR2013 says.

mlmcc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
With a single value parameter, this works fine: http://screencast.com/t/yqPJL2tDq7

With a multi-value parameter, it doesn't because the Join expression is accessing the internal parameter value array.
dizmaRiderAuthor Commented:
mlmcc:  What I expected is Accord, Taurus.   I would appreciate any help I can get on this.

IdoMillet:  Everything I read is that the Join should work with Multi-Value parameter.  Supposedly that is why SAP made this change.
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
AFAIK, this 'Show Value or Description' property was added to address what happens when you simply place the parameter on the report canvas.  
I don't believe it was designed to impact what is returned by formula expressions.
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Even with a single-value parameter, placing a parameter with 'Show Value or Description' property set to 'Show Description' on the report canvas shows the description, but placing a formula with the parameter as its expression returns the parameter Value.  
So, again, this property is intended to impact only parameter objects on the report canvas; not expressions using a parameter.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Where are you reading?

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.