April 30, 2007, 01:05 PM
Jason K.minor trouble with Multiselect OR
I'm having trouble trying to create a Multiselect OR without having to create a list of values for it. I'm using an HTML form to pass values to it, so I'd just like to allow multiple selection.
In my .fex I've taken some of the code and duplicated it in order to avoid syntax errors, but it's sloppy to say the least.
WHERE FACILITY_CODE EQ &FACILITY_CODE.(OR(FIND STORE_NAME IN MATRIX_DIV_MTD)).FACILITY_TEST.;
WHERE STORE_BUDGETED_NUMBER EQ &STORE_CODE.(OR(FIND STORE_CODE IN MATRIX_DIV_MTD)).STORE_TEST.;
As you can see, I simply pointed these ampersand variables toward the same field in a datasource. Is there any way to simply create an (OR) without having to reference a file in my .fex?
Thanks!
May 08, 2007, 05:00 PM
KerryHi Jason,
Can you please let me know, are you using Dev Studio to build it? You do have an option when build the request to use dynamic or static lists.
Thank you in advance for clarifications.
Cheers,
Kerry