Skip to Content

Trouble with Parameter Option - Show Value or Description

First off we are on BI 4.1 SP01 Patch 6. I have a Crystal Reports 2013 report with a lot of optional parameters some of which are based on dynamic lists of values which I created using Business View Manager.

My hope would be that whatever values I select would be shown in the Prompt Panel on the left side of the screen.

Rather than displaying the value of "Limited Liability Company" for the Organization Type I get the code of "06".

That is the correct code and it works from a functional perspective, but I want to see the description. To get to this point in my Crystal Report I created a parameter based on a Dynamic List of Values created in Business View Manager called OrganizationType with the following settings...

That in turn creates something in Business View Manager called "OrganizationType - Prompt Group". If I edit my Organization Type paramter in Crystal Reports I see that it is now based on that OrganizationType - Prompt Group and not Organization Type LOV I had just selected. When I look at the OrganizationType - Prompt Group in Business View Manager the Show on (Viewer) Panel and Show Value or Description options are not what I set them to be in Crystal Reports.

My expectation when choosing the "Show Description" setting for the Show Value or Description option would cause the Description to be shown in the prompt panel. Is that correct? If so, then why isn't this setting sticking. If not, how do I do that?

I realize that I could create my LOVs based on just the Description rather than the ID and Description and filter on the Description rather than the ID, but I shouldn't have to. This should work shouldn't it? What I am doing wrong?

Thanks,

Noel

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 19, 2014 at 08:01 PM

    Hi Noel,

    The 'Show Value or Description' option was introduced in CR 2008 SP5 (I think) and the purpose of this, as you might have thought, is Not to show the description on the 'Parameter Panel' on the left.

    When you drag and drop a prompt on a section of the report with this option turned ON, it replaces the prompts 'value' with its 'description'. Now, you do not need to use a Subreport as a workaround to show what the user selects in say, a multi-value prompt.

    The other option called 'Prompt with description only' is the one that should be controlling this. Do you see the same behaviour in the CR designer?

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2014 at 08:11 PM

    Hi Noel,

    where did you create the dynamic parameter? in crystal reports or in Business View manger?

    if you use the Parameter from Business view manager then you need to change parameter property in BVM.

    In Business view manager also we have an option for LOV to display Description.You just open the List of values(LOV) in Business View manager and change the property to display description.

    Hope the above information will help you...

    --Naga.

    Add a comment
    10|10000 characters needed characters exceeded

    • I created the parameter in Crystal Reports and based it on dynamic LOV created in Business View Manager as shown here...

      As far as displaying the description when I am prompted is working fine (see screenshots in my response to Abhilash) in the parameter prompt. This issue is that the code rather than the description is showing in the parameter prompt panel just when running the report from the BI Launchpad. It is fine within the Crystal Reports designer.

      Noel

      pastedImage_0.png (35.1 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.