How to access parameter description chosen?

[BernieBeattie]

We have a dynamic parameter which gives a choice of entries on a lookup table, so the value is the lookup id and the description is the lookup text. We want to show the chosen parameter's description rather than the value in the report heading without creating a formula field to look it up again. Is that possible?

Thanks for any help.
Bernie

 

[lbass]

You could use a subreport that uses the lookup table, where you add the description to the detail section and add a record selection formula like:

{table.ID} = {?parm}

Then link the subreport to the main report on {?parm}. Be sure to use the dropdown to select {?parm}, not {?pm-?parm}.

-LB