Show multiple value parameter on report

[alc25]

I have a multi value paramer field used to enter 1 or more item numbers. I have created a formula field to display the values of this field using: Join({?ItemParam}, ", ")

I would also like to see the item descriptions for each item entered in the parameter. How would I display these?

 

[GJParker]

It would depend where you wanted to display this information, you don't have access to the paramater descriptions so you can't build the formula as you did with the parameter codes.

If you need the descriptions in the report header section then you would need to create a simple subreport whch displayed the descriptions for the parameter codes.

or in the main report you could use shared variables to build a string of the deistinct descriptions, but this data won't be available untiol the report footer sections.

HTH

Gary

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

As an alternative to the subreport approach, if you don't have too many values, you can create a formula like the following:

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

for i := 1 to j do(
parm := parm + {?parm} + " : " +
(
if {?parm} = "ABC" then "Shoes" else
if {?parm} = "DEF" then "Cosmetics" else
if {?parm} = "GHI" then "Accessories"
) + chr(13));
parm

You would need to right click on the formula->format field->common->"Can Grow".

-LB