i have a dropdown box in my jsp page that allows users to select multiple values from the list.
the parameter that i am passing to my .fex file is &fundid.
i have inserted the code below to the .fex file so that it can read all the values that the user selects:
______________________________________

...
SET &COUNTERA=0;
TABLE FILE TEMP1
PRINT total f_fund_id_code


-IF &fundid.EXISTS THEN GOTO FIRST ELSE GOTO PART2;
-FIRST
IF f_fund_id_code EQ '&fundid'
-IF &fundid0.EXISTS THEN GOTO START ELSE GOTO PART2;
-START
-REPEAT LOOP FOR &COUNTERA FROM 2 TO &fundid0;
OR &fundid.&COUNTERA
-LOOP
-PART2
END
______________________________________
My problem is that whenever i run the report, it only shows the first value that i selected.
Everytime a right click on the report and do a view source, it seems that the .fex page is getting all the passed values but it just does not print it all out.
Please see the code below (generated when i select view source), there are two values that I select, FYA and GAA however only FYA is printed out. Please help.Thanks.
------------------------------------
TABLE FILE TEMP1
PRINT total f_fund_id_code
-*SET &COUNTERA=0;
-IF 1 THEN GOTO FIRST ELSE GOTO PART2;
-FIRST
IF f_fund_id_code EQ 'FYA'
-IF 1 THEN GOTO START ELSE GOTO PART2;
-START
-REPEAT LOOP FOR COUNTERA FROM 2 TO 2;
OR GAA
-REPEAT LOOP FOR COUNTERA FROM 2 TO 2;
-LOOP
-PART2
END

what i notice is that the first value 'FYA' is in quotes and the second value GAA is not in quotes so you're probably getting some kind of error in your fex; probably thinks GAA is the name of some variable.
So your fex is probably treating these two filter values differently.
Maybe your dropdown list needs to make sure the ' marks are included in all the values.

If the html source has the correct code, then the values are getting passed. The problem is probably something more obviuos. Are you sure GAA is actaully in the data? The file you're reporting off of a HOLD file? If so, how did the data get populated? Maybe you need to apply the looping logic at a different point in your fex. Maybe futher up where the hold file gets created.