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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display Multiple Parameters - Problem with a twist 1

Status
Not open for further replies.

DataDog

Technical User
Jun 19, 2002
190
US
In previous Tek-Tips posts, users have explained very nicely, how to display multiple parameters in a report with:

Method 1
numbervar counter;
numbervar final;
stringvar holder;
counter := count({?Multi});
while counter > 0 do
(holder := holder + {?Multi}[counter] + ',';
counter := counter - 1);
holder [1 to (length(holder)-1)]

or:
Method 2
join({?Multi},", ")

My Problem is that I need to display the Parameter Descriptions, NOT the Parameters.

I do have a formula (used for Grouping) (Below) that explains: if ?MyParameter=”P” then Group on “Pool” but I can’t figure out how to display ALL the Parameter Descriptions in the Header of the report.

Any help would be appreciated …….


Grouping Formula
if {LA867.VEH_USE_CD}="P" then "Pool" else
if {LA867.VEH_USE_CD}="S" then "Pool- Service" else
if {LA867.VEH_USE_CD}="A" then "Assigned" else
if {LA867.VEH_USE_CD}="V" then "Vanpool" else
if {LA867.VEH_USE_CD}="E" then "Special Use - Canada Only"
 
numberVar i;
stringVar d;
d:="";
for i := 1 to UBound({?Multi}) do
(
select {?Multi}
case "P": (d:=d+"Pool ";)
case "S": (d:=d+"Pool-Servive ";)
case "A": (d:=d+ "Assigned ";)
case "V": (d:=d+ "Vanpool ";)
case "E": (d:=d+"Special Use - Canada Only ";)
default : (d:=d;);
);
d
 
JoeCrystal:

It works Great! Thanks !

DataDog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top