Populate Parameter Dropdown with Dynamic Description

[Former Member]

Hello all,

I am programming a report in Crystal Reports 2008 to run on Business Objects XI R3. I have a report that has a dynamic Parameter Field that is populated from the database when the report is opened. The value of this is a numeric key I have placed in the database tables and the description is the text displayed to the user. I use the u201CPrompt with Description Onlyu201D so the user sees only the text. When the report is run the numeric key is used for a more efficient query. However this is CR 2008 so the parameters show up un the report when it is published to InfoView. This is done so the user can use the parameter screen to either make a more finite report or go to a different type for this field (ie Water Sports, Mountain Sports, Land Sports).

The problem I am having is I need to keep the u201CValueu201D field the KeyID so the dynamic parameter remains numeric. The drop down in the parameters field is populated from the u201CValueu201D field not the u201CDescriptionu201D field. This means that after the user runs the report the parameter is populated with KeyIDs instead of the user friendly descriptions I created. Is there a way to tell the Parameter Dropdowns to be populated from the u201CDescriptionu201D field instead of the u201CValueu201D field?

Thanks

[Former Member · Accepted solution]

Hi Scott,

When you select the 'Value' field, you can associate a field for the 'Description' as well.

Even though the user selects 'Description' field, you can use the 'Value' field in the record selection formula.

Since the Value and Description fields are linked, the report will fetch data based on the Value field.

Hope this fulfills your requirement.

[Former Member · Accepted solution]

Hello Mohamed,

Thanks for your reply, but I think I may not have made my point.

I have the u2018Valueu2019 field filled with a number to fetch the data. I need the u2018Descriptionu2019 field to populate the drop down windows in the prompt when this is published for InfoView.

My question is there a way to make Crystal Reports populate the drop downs with the description instead of the default?

Please let me know if this clarifies my needs.

Thanks

Scott