Value Part as "User ID" and Description Part as "User name".

 

For UI display we have set as "Prompt Discription only =True".

 

While i am calling this parameter in to the Report page, its showing the UserID only. But i need to show "User Name".

 

Kindly help me on this topic.

 

 

 

Are we have any funtion to retrive the Description part of parameter?

 

Kindly help me on this topic

 

Always when you place a parameter field onto the report which has the description field(inspite of whether it is set to true or false), only the value of the parameter is displayed not the desc.

 

To display the description field

- Use the description( fieldname) in a formula like

if User ID = value 1 then Desc 1

elsif User ID = value 1 then Desc 1

else so on

But this is preferred for some small number of values or static parameters.

 

- Place the "User name"  field directly in the report where u have placed the parameter field. This will display the desc of the User ID what you have selected in the parameter.

 

I think, I have mentioned the things very clearly.

 

I have assumed the USER NAME field as a database field, which you have taken in the description field of the prompt. And I have also assumed that the parameter is not multi-valued.

 

Instead of placing the parameter i.e. USER ID(value) and USER NAME(desc) on to the report, put the USER NAME field directly onto the report.

So u ll get the required output.

 

 

Thanks for the reply. Let i explain you clearly.

 

Process steps:

 

1) Paramater Name called as "SalesManager".

2) Value part as "UserID".

3) Desc part as "UserName".

6) I need to show the "UserName" in the report page instead of "User Id"

 

I think now you are clear about my requirement.

 

Kindly help me on this topic. 

U create the parameter with what ever credentials u have mentioned

i.e. "UserID as a Value part" and "UserName as Desc Part".

But put the User name field (which u have selected in the description of the "SalesManager" parameter) into ur report where u want to display USER name instead of that parameter.

Hence when u select User Id 1 in ur parameter, User name 1 will be displayed accordingly.

I have done, what ever you said. But Its not working. Its not bringing the userName. Its Showing all users but not selected users.

 

But i have done with SubReport. I have passed the userid to that sub report and i am displaying the username from parameter using query.

 

 

 

 

Step 1:

 

Create "Dynamic Parameter" as "Number" as Value and "Name" as Description on the Main report and call the Parameter on the main report.

 

Step 2:

 

Create one Subreport for showing "Name". This subreport for dedicated to show "Name" only. put query like "Select number, name from table"

 

Step3:

 

Create one "Static parameter" for "Number" in the Subreport

 

Step4:

 

Call the subreport in the main report and

Map Mainreport and subreport for that "number" field.

 

Step 5

 

Add "Select Expert" for that number field on the sub report.

example:

 "{Command.number} = {?Pm-?Select - number}"

 

Step6:

 

Place the "Name" field on the sub report and run the main report.

 

Select few names from the parameter and it will pass the "number" to subreport and the subreport will match with that and will show the name.

 

i hope, it will help you.

 

Regards

Pandian