Display Selected Parameter Text In Report Layout (cr4e)

[DebjitSingha]

Hi All,

How can I display selected parameter text in the report layout? Only key is displayed, if I put parameter on the layout.

Thanks,

Debjit

[Former Member · Accepted solution]

Hi Debjit,

I think you are searching for the function:

GetValueDescriptions({?Your prompt/parametername goes here})

With this you get the Text of your prompts. No matter what datasource you have.

If you want to split the text values (or is your parameter just returning one value ?) you have to first assign it to an Array and then you can access it.

I hope this answers helps you out.

Best regards

Manfred

[DebjitSingha · Accepted solution]

Thanks Manfred,

what is the formula to show keys of an element?

Thanks,

Debjit

[Former Member · Accepted solution]

Hi Debijit,

If you just use {?Your prompt/parametername goes here} you will receive just the keys.

The more complex script needs to be used if you have multiple parametervalues and want to combine key and text.

Do you want to achieve that ?

If you are interested in the script i can prompt the script next week ?

Best regards

Manfred

[jyothirmayee_s]

Hi,

if you are entering key values in prompt then that will display as it was entered.

What is the formula you have created though?.

Thanks,

Jothi

[DebjitSingha]

I am using the prompt as is. Wanted to show text instead of master data.

Thanks,

Debjit

[abhilash_kumar]

Hi Debjit,

Do you mean CR4E shows the Technical Name instead of the Description?

-Abhilash

[jyothirmayee_s]

Hi,

What is your Datsource?. Instead of prompt , select the dimension of the object that parameter is created.

Thanks,

Jothi

[ido_millet]

If you are using Crystal 2011, there is a new option that allows you to display the Description instead of the value.  Here is a picture: http://screencast.com/t/RXwVMPERia

[DebjitSingha]

My requirement is to show text of the value selected in prompts.

[DebjitSingha]

Thanks,

I am using Crystal Reports Enterprise 4.0. Not sure though how to get text displayed in the report.

Thanks,

Debjit

[jyothirmayee_s]

Hi Debjit,

I mean you backend data source?. What is it?. and also can you drag and drop both Dimension and it's objects which says Key and Text.

Post a screen shot of the field explorer pls.

Thanks,

Jothi

[DebjitSingha]

Hi Jothi,

we are pulling data from BW system (BEx data source).

Thanks,

Debjit

[jyothirmayee_s]

Hi,

Is it Project Definition or Project Type?.

Assume if it is Project Definition then Drag Praject Definition  from Data Explorer and place in a text field.

if you still see a key values from the dimension object then  Edit the query and select Text from the attributes which says "Project Definition - Text".

you can find the attribute when you drag the Dimension (easiest way is to search "Project Description or justscroll down to see it)

Thanks,

Jothi