I am using two parameters in the select expert and I can't seem to get them working properly. I'm actually working with three parameters but one is not used in the select expert, it's just used for sorting.
The user first selects whether to view a list of codes sorted alphabetically either by code or description (this parameter is working properly). Next, they get to pick a range of codes or descriptions that can be alphabetic or numeric. The user types in what they want to see but they also have one default option, which is 'All'. I'm having problems getting the 'All' to work properly, whenever 'All' is selected, it comes up blank. I got it to work with some kinks earlier but for some reason it just doesn't work at all now (as far as the 'All' is concerned). The second parameter allows the user to select whether or not active, inactive or all codes should be viewed. I set up that parameter to have a picklist of default values (A, I, or All) and this parameter seems to work except I don't know how to get 'All' codes option to display (for now I have it as a default of "F" which ends up being active codes).
Anyway, this is the formula I have for now. I realize the first one can be cut short because it just repeats the same result ({?Range} = {ALLERGIES.DESCRIPTION}) but some reason it was working (to an extent) like this before whereas the shortened version is not working. I hope this makes some sense.
Any help is appreciate, I really hope this understandable. Thanks!
The user first selects whether to view a list of codes sorted alphabetically either by code or description (this parameter is working properly). Next, they get to pick a range of codes or descriptions that can be alphabetic or numeric. The user types in what they want to see but they also have one default option, which is 'All'. I'm having problems getting the 'All' to work properly, whenever 'All' is selected, it comes up blank. I got it to work with some kinks earlier but for some reason it just doesn't work at all now (as far as the 'All' is concerned). The second parameter allows the user to select whether or not active, inactive or all codes should be viewed. I set up that parameter to have a picklist of default values (A, I, or All) and this parameter seems to work except I don't know how to get 'All' codes option to display (for now I have it as a default of "F" which ends up being active codes).
Anyway, this is the formula I have for now. I realize the first one can be cut short because it just repeats the same result ({?Range} = {ALLERGIES.DESCRIPTION}) but some reason it was working (to an extent) like this before whereas the shortened version is not working. I hope this makes some sense.
Code:
if {?CodeDescriptionSort} = 'D'
then if {?Range} = 'All'
then {?Range} = {ALLERGIES.DESCRIPTION}
else {?Range} = {ALLERGIES.DESCRIPTION}
else
if {?CodeDescriptionSort} = 'C'
then if {?Range} = 'All'
then {?Range} = {ALLERGIES.CODE}
else {?Range} = {ALLERGIES.CODE}
and
if {?Status} = 'A'
then {ALLERGIES.DISCONTINUED} = 'F'
else if {?Status} = 'I'
then {ALLERGIES.DISCONTINUED} = 'T'
else if {?Status} = 'All'
then {ALLERGIES.DISCONTINUED} = 'F'
Any help is appreciate, I really hope this understandable. Thanks!