CR2008 and SAP BW - Technical Values for variable values not displayable ?

[former_member593901]

Hello Experts,

we have the following constellation / problem:

- SAP Query BW 7.0 with variables

- a report built upon this query with Crystal Reports 2008

- now if we execute the report and try to fill in the parameters (= SAP BW variables), only the (SAP) description of each value is displayed

Since it is common for the business users to communicate with the key instead of the description (e.g. Project 50010001 instead of Project 'something etc something'), it is necessary for us to give them the opportunity from a list that contains the key (maybe as well as the description) instead of only the description. Is there a possibility in SAP BW or Crystal Reports 2008 to make that possible ?

I tried to do it in the infoobject, in the query, in the 'options'-section of Crystal Reports and in the properties of the parameter field itself, but to no avail.

Many thanks for your help in advance !

Frank

[IngoH · Accepted solution]

Hi,

go to Crystal Reports, Edit the parameter that was created, select the property "promtp with description only" and set it to "False"

ingo

[former_member593901 · Accepted solution]

Hi Ingo,

many thanks, that solved the problem.

Frank

[Former Member · Accepted solution]

Hello Experts,

I facing a problem.

I have a crystal report based on a BW Query. It has one parameter called Country.

Eg:

Until now, in BW query country variable has the following values.

USA

JAPAN

GERMANY

Now, from this fiscal year we have the following values for country variable

USA

JAPAN

INDIA

GERMANY

UK

I am trying to edit the list of values for the country variable in crystal reports. It is not getting reflected in SAP BW. I also tried refreshing it several times.

Can any one Please help.!!

Regards

NMU

[IngoH · Accepted solution]

see the other forum entry

Ingo