Variables/Input Parameters Value help not showing texts

[#1]

Hello,

I have created a crystal report based on a calculation view in Crystal Reports for Enterprise 4.1 SP5, which has a input parameter on the field "Region". For the value help, I am using a custom view based on T005U in which I have made sure that RegionName field is present in the "Label Column" property of the Region field.(Required for viewing descriptions of LOVs).

In the crystal report, while previewing data in the query builder, I am able to see the value help for the input parameter in the prompt screen, which displays only the key part, but does not display the description of it. Moreover, after accepting the prompt value, the preview runs into an error(as shown below). Please note that I get the error below only when Region is a part of the output fields of the query.

Instead of input parameter, when I create a variable on the region field in the main calculation view, with the same value help view, I am able to do data preview in the query builder as also data appears in the report on running the query. But, just as in the case of input parameter value help in the prompt screen, even over here, I am only able to see the key part and not the description.

Are variables/input parameter LOV's supposed to display descriptions or just the key part? As also, any reason why I should be getting this error while using Input parameter?

Kindly let me know if I am missing something in the development of this report.

Regards,

Alston

[Former Member]

Hi,

          I hope you are taking the BEx Query as a source to the crystal report. In the BEx query check region info object  should is maintained as  Text and Key. If text is not maintained over there you will not be getting text in Crystal reports.

Krishna.