How to Bring back Selection 1

[danzing]

Hi all I have a question that is stumping me

I have a table with fields of numbers 1 through 19

each number represents a name which is not in the database


like 1 = kmart
2 = walmart and so on

What I am doing is using a parameter to select the store

What I have done is create a forumula for each one their is 19 stores

if {ppeverbatims.Property} = "1" then "kmart"


I have made 19 of these formulas and I was thinking how would it have been easier to do this

I thought I could do,

if {ppeverbatims.Property} = "1" then "kmart" or
if {ppeverbatims.Property} = "2" then "walmart"

this does not work so I assume I am doing something wrong

But the end result is I need to do a paremeter that lets users pick one of the 19 propertys or all propertys which is not in the data base ( all =O ) ? I am not sure how to forumala this eithier.

I would appricate any help on how to do this a little easier thanks in advance

Chris

http://www.whiteyman.com

 

[danzing]

I figured out the putting them all it is the ELSE statment I was using or

if {ppeverbatims.Property} = "1" then "Kmart" else
if {ppeverbatims.Property} = "2" then "Walmart" else
if {ppeverbatims.Property} = "3" then "shopco" else

And so on for all

Now my question is in the parm how do I create a bring back all

Thanks
Chris

http://www.whiteyman.com

 

[Ngolem]

An easier way to do this is to put all your Store "names" into a string array...then the number 1 would refer to the first element of the array

Stringvar array property := ["KMart", "Walmart".....]

Then when you want "KMart" you just specify the number

property[1] or property[value] (where value = 1) Jim Broadbent

 

[danzing]

Awesome I knew I was missing something I took your example and now it works thanks

Chris

http://www.whiteyman.com