asked on

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.

Mike McCracken

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 Millet

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.

dizmaRider

ASKER

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.

Ido Millet

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.

ASKER CERTIFIED SOLUTION

Ido Millet

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

Where are you reading?

mlmcc