I keep receiving this error when trying to drill down to the final fex of report.

0 ERROR AT OR NEAR LINE 17 IN PROCEDURE newrefundteamroll
(FOC257) MISSING QUOTE MARKS: ''Bank Error'';
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
It appears not to like my radio option. The radio option lets you select one of two values. I used the GUI to choosed single select and choosed the values for the parameter. Code below:

 TABLE FILE TEAM_HIARCHY
SUM
     REFUNDAMT/D10.2CM AS 'Amount'
BY TOTAL HIGHEST REFUNDAMT NOPRINT
BY TEAMNAME
HEADING
"&MANG<+0>'s <TYPE Report"
"For <+0>&dte through &edte"
FOOTING
""
WHERE NEWMDY GE '&dte' AND NEWMDY LE '&edte';
WHERE TYPE EQ &TYPE.(OR(<'Bank Error',Bank Error>,<'Override',Override>)).Select Report Type.;WHERE MANAGER EQ '&MANG';
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE MANREFUND.SEG01.REFUNDAMT AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.500000,
     RIGHTMARGIN=0.500000,
     TOPMARGIN=0.500000,
     BOTTOMMARGIN=0.500000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=ITALIC,
     RIGHTGAP=0.125000,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
TYPE=DATA,
     BORDER-LEFT=MEDIUM,
     BORDER-RIGHT=MEDIUM,
     BACKCOLOR='WHITE',
$
TYPE=DATA,
     COLUMN=N2,
     TARGET='_parent',
     FOCEXEC=newrefundteamroll(TEAM=N2 TYPE=&TYPE.QUOTEDSTRING dte=&dte.QUOTEDSTRING edte=&edte.QUOTEDSTRING),
$
TYPE=DATA,
     COLUMN=ROWTOTAL(1),
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     BORDER-TOP=MEDIUM,
     BORDER-BOTTOM=MEDIUM,
     BORDER-LEFT=MEDIUM,
     BORDER-RIGHT=MEDIUM,
     COLOR='WHITE',
     BACKCOLOR='BLACK',
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     COLUMN=ROWTOTAL(1),
     BORDER-TOP=MEDIUM,
     BORDER-BOTTOM=MEDIUM,
     BORDER-LEFT=MEDIUM,
     BORDER-RIGHT=MEDIUM,
     COLOR='WHITE',
     STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
     SIZE=16,
     STYLE=BOLD+ITALIC,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD+ITALIC,
$
TYPE=HEADING,
     SIZE=16,
     STYLE=BOLD+ITALIC,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=14,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=14,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=14,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=14,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=12,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     FONT='PHOTINA CASUAL BLACK',
     SIZE=12,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD+ITALIC,
$
TYPE=SUBTOTAL,
     STYLE=BOLD+ITALIC,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BORDER-TOP=MEDIUM,
     BORDER-BOTTOM=MEDIUM,
     BORDER-LEFT=MEDIUM,
     BORDER-RIGHT=MEDIUM,
     COLOR='WHITE',
     BACKCOLOR='BLACK',
     STYLE=ITALIC,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
TYPE=ACROSSVALUE,
     COLUMN=ROWTOTAL(1),
     BACKCOLOR='WHITE',
     STYLE=BOLD+ITALIC,
$
TYPE=ACROSSTITLE,
     COLOR='WHITE',
     BACKCOLOR='BLACK',
     STYLE=BOLD+ITALIC,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
TYPE=ACROSSTITLE,
     ACROSS=1,
     BORDER-TOP=MEDIUM,
     BORDER-BOTTOM=MEDIUM,
     BORDER-LEFT=MEDIUM,
     BORDER-RIGHT=MEDIUM,
     STYLE=BOLD+ITALIC,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
TYPE=GRANDTOTAL,
     COLOR='WHITE',
     BACKCOLOR='BLACK',
     STYLE=BOLD+ITALIC,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
ENDSTYLE
END

Thanks for any help!
Joe

quote:

WHERE TYPE EQ &TYPE.(OR(<'Bank Error',Bank Error>,<'Override',Override>)).Select Report Type.;WHERE MANAGER EQ '&MANG';

I think you need single quotes around the whole select if &TYPE is against an alphabetic field.

quote:

WHERE TYPE EQ &TYPE.(

So if the value for &TYPE becomes "Bank Error", then your WHERE statement becomes:

WHERE TYPE EQ Bank Error; - which would be bad syntax.

Try using -SET &ECHO=ALL; at the beginning of the fex and then reviewing the code that is being run and you can see this. By putting single quotes around the parm as Leah suggests, it should resolve the problem.

If that's how it was made by the GUI, well, that's why I try not to depend too much on the GUI (or GUPI as I sometimes call it - the P standing for "problematic")