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!

Accessing Parameter Description From a Formula

Status
Not open for further replies.

dv10lv

Programmer
Jan 4, 2007
8
US
Parameter:
Department
Values Description
0 All
1 Dep1
2 Dep2

I want to display the description now I am displaying
the value but that is not descriptive enough. I don't want
to do it from a case statement because I will have to
update the report everytime a new department is added.



*************CODE*****************************
global numbervar counter;
//increments the loop so that all parameter entries can be displayed
global stringvar display;
//creates a string "running total" so that all entries can be displayed
for counter := 1 to count({?Department}) do
(
display := display + totext({?Department}[counter],0,"") + chr(10);
);
display;
 
Unfortunately the description is not available to formulas, most people would contain that information in the database as a lookup...

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top