Populate Parameter Dropdown with Dynamic Description
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?
Md Saif replied
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.