Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Description of parameter field

Status
Not open for further replies.

crystal28

Programmer
Oct 23, 2002
108
US
Is there a way to display just the Description of parameter field in the report?The value of the field is always displayed when the parameter field is placed in the report.
 
Click on 'Default Values' button in 'Edit Parameter Field' Window.It would take you to 'Set Default Values' window. first set the description for the values of your field and then select 'Description' for 'Display' Option in the same window.
 
If there are not too many parameter options, you can hardcode the description in a formula like the following:

numbervar i;
numbervar j := ubound({?parm});
stringvar desc;

for i := 1 to j do(
desc := desc +
(
if {?parm} = "value1" then
"description1" else
if {?Parm = "value2" then
"description2" else //etc.
)
+ ", ");
left(desc, len(desc)-2);

If you have many values and your description field appears in a table, then the simplest approach is to use a subreport where you display the description field. Link the subreport to the main report using the parameter field in the main report linked to the value in the subreport.

-LB
 
Unfortunately not.

The description can be displayed during the prompt, but one can't access it for display on the report, you'd have to create an external means for displaying it (I know, it sux), such as a formula or array or from a table.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top