I have a report designed using Crystal Reports 2008. The report has a dynamic parameter called Location which is populated from a table. It is a Value - Description pair so it is:
Value = LocID
Descripition = LocationName.
The Show on Viewer(Panel) attribute is set to Editable.
The Prompt with Description Only attribute is set to true.
In the Crystal Reports stand-alone Designer everything works fine. It prompts with the Description. After making a selection, the Parameter Panel shows the selected items(the Description, NOT the value) correctly. This is the desired behavior.
But when the report is viewed in the Crystal Reports Viewer that comes with .NET 2008 the Parameter panel shows the Value, which is LocID and not the description which is LocationName. This is NOT very useful.
I have tried other third party Crystal Reports viewers as well. They all exhbit the same discrepancy.
How can this be resolved?
Any help is greatly appreciated.
Thanks in advance.