Hi,
I am trying to show a list such as:
Groceries:
Apples
Oranges
Bananas
Where all the listed fruit is actually different variables (ex. Fruit1=true, Fruit2=true, Fruit3=true). I know this is not the best way to do this however, this is the way it is set up and I must find a way to report on it.
I've got it working however, is there anyway to eliminate the space if a variable is null? For example if Fruit1=true, Fruit2=false, and Fruit3=True - it is currently displaying:
Groceries
Apples
Bananas
I'm sure there's a way to do this but I can't seem to figure it out. Please help. Thanks!
I am trying to show a list such as:
Groceries:
Apples
Oranges
Bananas
Where all the listed fruit is actually different variables (ex. Fruit1=true, Fruit2=true, Fruit3=true). I know this is not the best way to do this however, this is the way it is set up and I must find a way to report on it.
I've got it working however, is there anyway to eliminate the space if a variable is null? For example if Fruit1=true, Fruit2=false, and Fruit3=True - it is currently displaying:
Groceries
Apples
Bananas
I'm sure there's a way to do this but I can't seem to figure it out. Please help. Thanks!