Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parameters

Hi Guys,

I am unsure how to achieve the following, all help would be greatly appreciated.

I have a table with the fields:-

ID

Forename

Surname

I have created a static parameter field based on the ID field, however when the users open the report and the parameter fields pop up, they can choose the code. Just the code is not very informative as there could be dozens.

I would like to display the Forename & Surname along with the ID for the user to choose the correct person, in a single drop down parameter option.

Is this possible?

Regards

replied

Hi,

To be able to use both the Forename and Surname, you would need to create a simple SQL query and point the parameter field to the field in this SQL Query:

1) Open the Database Expert > Click Add Command and type in a SQL Query like this:

Select ID, ForeName + ' ' + SurName Name from Table

For Oracle database, this would be:

Select ID, ForeName || ' ' || SurName Name from Table

2) Add this to the report and DO NOT JOIN to the other tables. Ignore the warning that follows.

3) Create a new Dynamic parameter and point the 'Value' field to 'ID' from the Command SQL and the Description to 'Name' from the same SQL.

-Abhilash

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question