A couple of things - First, in order to display your HTML code (and not the report rendered by the HTML code,) you've got to click on the OPTIONS when you post and disable HTML. Otherwise we don't see the code.

Second, in your code, you are not passing ANY of the selected parameters. You are only passing field values. In order to pass parameter values it would be something like DATA_TYPE=&DATA_TYPE (needs quotes if the value contains embedded spaces).

Last, Ginny has made a couple of excellent suggestions to help you out. Do some research on FOC_NONE to see how it works. I usually prefer NOT to use it (because it likes to make code disappear) and instead test for the ALL or $* values and branch around WHERE statements.

Also, turn on the ECHO (-SET &ECHO=ALL;) in the parent and child procedures and when you view source for the browser report, you can see how the parameter values are affecting your code.

This message has been edited. Last edited by: Darin Lee,

After putting the set &echo on the parent I got
(FOC3213) ILLEGAL SET VALUE: ALL; ???

-SET &ECHO=ALL;

Some of the characters got translated in Darin's post. Maybe your syntax is wrong because of that.

When ALL is selected, did you mean the ALL in one of the selection parameters or did you mean the 'Export ALL categories' from the drilldown menu?

If it is the first, then follow Ginny and Darin's suggestion of the echo to find out what exactly gets sent on to your child process.

If the latter, then your child report should cater for the absence of the DATA_TYPE variable, since if you do select ALL from the drilldown, this parameter is not included in the parameters that get sent to the child. Alternatively you could give it a standard value in the drilldowns, but then you'd still have to check it in the child process.

quote:

that get sent to the child

Ok, I have added the set echo&=ALL to my child reports. When I select it for a specfic section this is what is returned:

  
TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
 PRINT
 DATA_TYPE
 PARENT_GROUP
 MONTH_ENDING
 SUBGROUP
 STATUS
 SERVER_NAME
 AAA_APP_STATUS/I5
 COST_CENTER/I5
 LV/I5
 CC_KEY_DESC
 CC_MGR_NAME
 LVL14_DESC AS 'OCM_DETAIL'
 LVL13_DESC AS 'OCM_BU_MIDLEVEL_DETAIL'
 LVL12_DESC AS 'BU_DETAIL'
 LVL11_DESC AS 'BU_DEPARTMENT'
 HEADING
 ""
 FOOTING
 ""
 WHERE DATA_TYPE EQ 'HW EOL - Monthly Raw Data';
 WHERE LVL14_DESC EQ 'Devonshire Investors';
 WHERE LVL13_DESC EQ 'Devonshire Investors Administration';
 WHERE LVL11_DESC EQ 'KVH/Asia Telecom';
 WHERE LVL12_DESC EQ 'Devonshire Investors Operations & HR Services';
 WHERE MONTH_ENDING EQ '07/31/2009';
 ON TABLE SET PAGE-NUM OFF
 ON TABLE NOTOTAL
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *
 UNITS=IN,
 SQUEEZE=ON,
 ORIENTATION=PORTRAIT,
 $
 TYPE=REPORT,
 GRID=OFF,
 FONT='ARIAL',
 SIZE=10,
 LINES-PER-PAGE=20,
 $
 TYPE=TITLE,
 COLUMN=N1,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N14,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N2,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N3,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N4,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N5,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N6,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N7,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N8,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N9,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N13,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N12,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N11,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N10,
 FONT='ARIAL',
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=N15,
 COLOR='WHITE',
 BACKCOLOR=RGB(66 99 33),
 STYLE=BOLD,
 $
 TYPE=TABHEADING,
 BACKCOLOR=RGB(66 99 33),
 $
 TYPE=TABHEADING,
 LINE=2,
 JUSTIFY=CENTER,
 $
 TYPE=REPORT,
 OBJECT=MENU,
 BACKCOLOR=RGB(66 99 33),
 HOVER-BACKCOLOR=RGB(255 255 153),
 $
 TYPE=REPORT,
 COLUMN=N14,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N2,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N3,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N4,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N5,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N6,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N7,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N8,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N9,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N13,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N12,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N11,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N10,
 WRAP=3.000000,
 $
 TYPE=REPORT,
 COLUMN=N15,
 WRAP=3.680556,
 $
 ENDSTYLE
 END
 0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0

The valid entried that were selected at run time were:
WHERE DATA_TYPE EQ 'HW EOL - Monthly Raw Data';
 WHERE LVL14_DESC EQ 'Devonshire Investors';
 WHERE LVL13_DESC EQ SHOULD BE ALL;
 WHERE LVL11_DESC EQ SHOULD BE ALL;
 WHERE LVL12_DESC EQ SHOULD BE ALL;
 WHERE MONTH_ENDING EQ '07/31/2009';

and I can not determine what it is grabbing for the paramters that should be 'ALL'

This message has been edited. Last edited by: <AM>,

AM,

Put your code between the RED code tags, upper right on the toolbar:


</>

Also, the parameters on this report are all Dynamic and getting values from a hold file.

Like I mentioned before, you are passing field values for those parameters to the child instead of passing the parameter values themselves.

Instead of having

DRILLMENUITEM='Export ALL Categories',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL14_DESC=N7 LVL13_DESC=N8 LVL12_DESC=N9 LVL11_DESC=N10 MONTH_ENDING=N6),

You should have

DRILLMENUITEM='Export ALL Categories',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL14_DESC=&LVL14_DESC LVL13_DESC=&LVL13_DESC LVL12_DESC=&LVL12_DESC LVL11_DESC=&LVL11_DESC MONTH_ENDING=&MONTH_ENDING),

For some of those parameters you may want to the the actual field value in which case you would use the Nn notation instead of the parameter name, but if your are passing field values for ALL of the parameters, it is not possible to pass the "ALL" value through to the child.

Will the
-DEFAULT &LV13_DESC = 'FOC_NONE'
work for passing to the child, if ALL is selected?

Not really. As Ginny mentioned, any line that contains FOC_NONE is completely ignored, so if you try to pass that value the line in the stylesheet that contains the value is ignored and the parameter is not passed at all. The way around it is to set the default value in the child fex to FOC_NONE using the code you last posted. Then if the value is not passed, the parameter defaults to ALL. If the value is something other than ALL then the correct parameter value is passed. You'll need to make sure that your stylesheet is formed correctly in order to pass the parm correctly (i.e. the parm with a value that may be FOC_NONE must be on a line by itself.) See my example below:

TYPE=DATA,
     COLUMN=N1,
     FOCEXEC=app/test.fex( \
	 MONTH_ENDING='&MONTH_ENDING' \
	 LVL13_DESC ='&LVL13_DESC' \
	 ),
$

quote:

WHERE DATA_TYPE EQ 'HW EOL - Monthly Raw Data';
WHERE LVL14_DESC EQ 'Devonshire Investors';
WHERE LVL13_DESC EQ 'Devonshire Investors Administration';
WHERE LVL11_DESC EQ 'KVH/Asia Telecom';
WHERE LVL12_DESC EQ 'Devonshire Investors Operations & HR Services';
WHERE MONTH_ENDING EQ '07/31/2009';
. . .
END
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

The valid entried that were selected at run time were:
WHERE DATA_TYPE EQ 'HW EOL - Monthly Raw Data';
WHERE LVL14_DESC EQ 'Devonshire Investors';
WHERE LVL13_DESC EQ SHOULD BE ALL;
WHERE LVL11_DESC EQ SHOULD BE ALL;
WHERE LVL12_DESC EQ SHOULD BE ALL;
WHERE MONTH_ENDING EQ '07/31/2009';

and I can not determine what it is grabbing for the paramters that should be 'ALL'

It was grabbing then, as directed, from the NOPRINT values that you referenced in the parent's drilldown stylesheet code:

TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
SUM
CNT.SERVER_NAME AS 'Instance Count'
AAA_APP_STATUS/I5 AS 'AAA Apps'
MONTH_ENDING NOPRINT
LVL14_DESC NOPRINT <--
LVL13_DESC NOPRINT <--
LVL12_DESC NOPRINT <--
LVL11_DESC NOPRINT <--
BY DATA_TYPE AS ''
BY HIGHEST STATUS AS ''
BY SUBGROUP AS ''

ON TABLE SUBHEAD
"Monthly EOL Reporting - WHERE DATA_TYPE EQ &DATA_TYPE.(OR(FIND DATA_TYPE IN eolmonthlyrawhldfile_working)).Select a Category(s).;
WHERE LVL12_DESC EQ &LVL12_DESC.(OR(FIND LVL12_DESC IN eolmonthlyrawhldfile_working)).LVL12_DESC.;
WHERE MONTH_ENDING EQ '&MONTH_ENDING.(FIND MONTH_ENDING IN eolmonthlyrawhldfile_working).Select a Month.';
WHERE LVL14_DESC EQ &LVL14_DESC.(OR(FIND LVL14_DESC IN eolmonthlyrawhldfile_working)).Select OCM.;
WHERE LVL13_DESC EQ &LVL13_DESC.(OR(FIND LVL13_DESC IN eolmonthlyrawhldfile_working)).Select Midlevel.;
WHERE LVL11_DESC EQ &LVL11_DESC.(OR(FIND LVL11_DESC IN eolmonthlyrawhldfile_working)).LVL11_DESC.;
. . .
TYPE=DATA,
COLUMN=N1,
. . .
DRILLMENUITEM='Export this Category only',
FOCEXEC=eolmonthlyrawdetailchild_test(DATA_TYPE=N1 LVL14_DESC=N7 LVL13_DESC=N8 LVL12_DESC=N9 LVL11_DESC=N10 MONTH_ENDING=N6), <--
DRILLMENUITEM='Export ALL Categories',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL14_DESC=N7 LVL13_DESC=N8 LVL12_DESC=N9 LVL11_DESC=N10 MONTH_ENDING=N6), <--
$

The drilldown parameter phrases
LVL14_DESC=N7
LVL13_DESC=N8
LVL12_DESC=N9
LVL11_DESC=N10
refers back to the four corresponding NOPRINT verb objects in...
SUM ...
LVL14_DESC NOPRINT
LVL13_DESC NOPRINT
LVL12_DESC NOPRINT
LVL11_DESC NOPRINT

which is equivalent to
SUM ...
LST.LVL14_DESC NOPRINT
LST.LVL13_DESC NOPRINT
LST.LVL12_DESC NOPRINT
LST.LVL11_DESC NOPRINT
-- i.e., the drilldown report is screening for the single value (last incoming value within sort-break) of each of the four variables (the values that would have appeared in the report line that the user clicked on if not for the NOPRINT). Depending on the relationship of the data columns in the original data ource, such a combination might not exist, in which case LINES=0 would be the natural outcome.

As far as I can see, these four NOPRINT verb objects serve no purpose in the parent report.

BTW, the HEADING is missing a closing double-quote. Is the code you copied complete and accurate?

quote:

NOPRINT

I am new to WEBFocus and this is really frustrating. When I remove the hidden columns, i.e. the NOPRINT columns, they are not available as fields to map to the child parameters? My parent reports has them as paramters as does the child report but can not map to them.

Also when trying to update the Text on the drill downs per Darin's suggestions the report error's out, i.e.

 
DRILLMENUITEM='Export ALL Categories',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL14_DESC=&LVL14_DESC LVL13_DESC=&LVL13_DESC LVL12_DESC=&LVL12_DESC LVL11_DESC=&LVL11_DESC MONTH_ENDING=&MONTH_ENDING),

"For some of those parameters you may want to the the actual field value in which case you would use the Nn notation instead of the parameter name, but if your are passing field values for ALL of the parameters, it is not possible to pass the "ALL" value through to the child."

I am not sure what is meant by the "Nn notation".

I am at my wits end and hoping someone can help me, please.

I have read every forum post for the FOC_NONE, FOC_ALL and have tried most of the suggestions and I am still at a loss. I need this report ready by tomorrow and time is of the essence for me right now. So if I have to pay someone to get me through this issue I will!

I have tried -Default's and -SET and still have no luck. I need a specific breakdown on what needs to be in the parent and what the child needs.

Again I am posting my code for the parent and child below.

This is the Parent Report:

  
TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
-DEFAULT &DATA_TYPE = 'FOC_ALL'
-DEFAULT &LVL14_DESC = 'FOC_ALL'
-DEFAULT &LVL13_DESC = 'FOC_ALL'
-DEFAULT &LVL12_DESC = 'FOC_ALL'
-DEFAULT &LVL11_DESC = 'FOC_ALL'
-DEFAULT MONTH_ENDING = 'FOC_ALL'


-*-SET &DATA_TYPE = IF &DATA_TYPE EQ 'FOC_NONE' THEN '$*' ELSE &DATA_TYPE;
-*-SET &LVL14_DESC = IF &LVL14_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL14_DESC;
-*-SET &LVL13_DESC = IF &LVL13_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL13_DESC;
-*-SET &LVL12_DESC = IF &LVL12_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL12_DESC;
-*-SET &LVL11_DESC = IF &LVL14_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL11_DESC;
SUM
     CNT.SERVER_NAME AS 'Instance Count'
     AAA_APP_STATUS/I5 AS 'AAA Apps'
     MONTH_ENDING NOPRINT
     LVL14_DESC NOPRINT
     LVL13_DESC NOPRINT
     LVL12_DESC NOPRINT
     LVL11_DESC NOPRINT
BY DATA_TYPE AS ''
BY HIGHEST STATUS AS ''
BY SUBGROUP AS ''

ON DATA_TYPE SUBTOTAL AS 'TOTAL'
ON TABLE SUBHEAD
"Monthly EOL Reporting - <MONTH_ENDING "
"&LVL12_DESC"
WHERE DATA_TYPE EQ &DATA_TYPE.(OR(FIND DATA_TYPE IN EOLMONTHLYRAWHLDFILE_WORKING)).Select a Category(s).;
WHERE MONTH_ENDING EQ '&MONTH_ENDING.(FIND MONTH_ENDING IN eolmonthlyrawhldfile_working).Select a Month.';
WHERE LVL14_DESC EQ &LVL14_DESC.(OR(FIND LVL14_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select OCM.;
WHERE LVL13_DESC EQ &LVL13_DESC.(OR(FIND LVL13_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select Midlevel.;
WHERE LVL12_DESC EQ &LVL12_DESC.(OR(FIND LVL12_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Business Unit(s).;
WHERE LVL11_DESC EQ &LVL11_DESC.(OR(FIND LVL11_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Dept.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<PowerPoint,PPT>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N2 EQ '1 - Emerging',
$
     DEFMACRO=COND0003,
     MACTYPE=RULE,
     WHEN=N2 EQ '3 - Upgrade',
$
     DEFMACRO=COND0005,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 1',
$
     DEFMACRO=COND0006,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 2',
$
     DEFMACRO=COND0007,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 3',
$
     DEFMACRO=COND0002,
     MACTYPE=RULE,
     WHEN=N2 EQ '2 - Preferred',
$
     DEFMACRO=COND0008,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 4',
$
     DEFMACRO=COND0009,
     MACTYPE=RULE,
     WHEN=N2 EQ '4 - Mandatory Upgrade',
$
     DEFMACRO=COND0010,
     MACTYPE=RULE,
     WHEN=N2 EQ '3 - Upgrade',
$
     DEFMACRO=COND0011,
     MACTYPE=RULE,
     WHEN=N2 EQ '2 - Preferred',
$
     DEFMACRO=COND0012,
     MACTYPE=RULE,
     WHEN=N2 EQ '1 - Emerging',
$
     DEFMACRO=COND0014,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 2',
$
     DEFMACRO=COND0015,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 3',
$
     DEFMACRO=COND0013,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 1',
$
     DEFMACRO=COND0004,
     MACTYPE=RULE,
     WHEN=N2 EQ '4 - Mandatory Upgrade',
$
     DEFMACRO=COND0016,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 4',
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
     BACKCOLOR=RGB(204 255 204),
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(128 128 255),
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(128 128 255),
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0009,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0010,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0011,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0012,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0005,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='BLACK',
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0014,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='BLACK',
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0015,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0016,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BACKCOLOR=RGB(204 255 204),
     STYLE=BOLD,
     DRILLMENUITEM='Export this Category only',
          FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC=N10 LVL12_DESC=N9 LVL13_DESC=N8 LVL14_DESC=N7 MONTH_ENDING=N6),
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP-STYLE=NONE,
     BORDER-BOTTOM-STYLE=NONE,
     BORDER-LEFT-STYLE=NONE,
     BORDER-RIGHT-STYLE=NONE,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0007,
$
TYPE=DATA,
     COLUMN=N2,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0005,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0006,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0008,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0004,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N1,
     BACKCOLOR=RGB(204 255 204),
     STYLE=BOLD,
     DRILLMENUITEM='Export this Category only',
          FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC=N10 LVL12_DESC=N9 LVL13_DESC=N8 LVL14_DESC=N7 MONTH_ENDING=N6),
$
TYPE=TITLE,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0006,
$
TYPE=TITLE,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0002,
$
TYPE=TITLE,
     COLUMN=N2,
     COLOR=RGB(204 255 204),
     BACKCOLOR=RGB(204 255 204),
     STYLE=NORMAL,
     MACRO=COND0008,
$
TYPE=TITLE,
     COLUMN=N2,
     COLOR=RGB(204 255 204),
     STYLE=NORMAL,
     MACRO=COND0004,
$
TYPE=TABHEADING,
     SIZE=14,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     BACKCOLOR=RGB(255 255 153),
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
     BY=1,
     BACKCOLOR='OLIVE',
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=2.930556,
$
TYPE=REPORT,
     COLUMN=N2,
     SQUEEZE=2.027778,
$
TYPE=REPORT,
     COLUMN=N6,
     SQUEEZE=1.263889,
$
TYPE=REPORT,
     COLUMN=N10,
     WRAP=1.430556,
$
TYPE=REPORT,
     COLUMN=N9,
     WRAP=0.916667,
$
TYPE=REPORT,
     COLUMN=N8,
     WRAP=0.680556,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=0.930556,
$
ENDSTYLE
END

CHILD Report:

  
-SET &ECHO=ALL
TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING

-*-DEFAULT &LVL14_DESC = 'FOC_NONE'
-*-DEFAULT &LVL13_DESC = 'FOC_NONE'
-*-DEFAULT &LVL12_DESC = 'FOC_NONE'
-*-DEFAULT &LVL11_DESC = 'FOC_NONE'
-*-SET &DATA_TYPE = IF &DATA_TYPE EQ 'FOC_NONE' THEN '$*' ELSE &DATA_TYPE;
-*-SET &LVL14_DESC = IF &LVL14_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL14_DESC;
-*-SET &LVL13_DESC = IF &LVL13_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL13_DESC;
-*-SET &LVL12_DESC = IF &LVL12_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL12_DESC;
-*-SET &LVL11_DESC = IF &LVL14_DESC EQ 'FOC_NONE' THEN '$*' ELSE &LVL11_DESC;
PRINT
     DATA_TYPE
     PARENT_GROUP
     MONTH_ENDING
     SUBGROUP
     STATUS
     SERVER_NAME
     AAA_APP_STATUS/I5
     COST_CENTER/I5
     LV/I5
     CC_KEY_DESC
     CC_MGR_NAME
     LVL14_DESC AS 'OCM_DETAIL'
     LVL13_DESC AS 'OCM_BU_MIDLEVEL_DETAIL'
     LVL12_DESC AS 'BU_DETAIL'
     LVL11_DESC AS 'BU_DEPARTMENT'
HEADING
""
FOOTING
""
WHERE LVL14_DESC EQ '&LVL14_DESC';
WHERE LVL13_DESC EQ '&LVL13_DESC';
WHERE LVL11_DESC EQ '&LVL11_DESC';
WHERE LVL12_DESC EQ '&LVL12_DESC';
WHERE MONTH_ENDING EQ '&MONTH_ENDING';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     LINES-PER-PAGE=20,
$
TYPE=TITLE,
     COLUMN=N1,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N14,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N2,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N3,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N4,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N5,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N6,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N7,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N8,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N9,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N13,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N12,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N11,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N10,
     FONT='ARIAL',
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N15,
     COLOR='WHITE',
     BACKCOLOR=RGB(66 99 33),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     BACKCOLOR=RGB(66 99 33),
$
TYPE=TABHEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=REPORT,
     OBJECT=MENU,
     BACKCOLOR=RGB(66 99 33),
     HOVER-BACKCOLOR=RGB(255 255 153),
$
TYPE=REPORT,
     COLUMN=N14,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N2,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N3,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N4,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N5,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N6,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N8,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N9,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N13,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N12,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N11,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N10,
     WRAP=3.000000,
$
TYPE=REPORT,
     COLUMN=N15,
     WRAP=3.680556,
$
ENDSTYLE
END

Based on previous post if I try to change the drilldown from LVL14_DESC = N10 to LVL14_DESC=&LVL14_DESC I get an error on line 190

If I remove the NOPRINT columns then the variables are unavailable under the PARAMETERS to be linked to the child.

No matter what I try it is still not passing the 'No Selection' parameters.

Ok, I have adjusted my parent, but now I am getting the message of (FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 190: LVL14_DESC?? This happens to be the parameter that I did select a value?

Here is the parent coed:

  
-DEFAULT &DATA_TYPE = 'FOC_ALL'
-DEFAULT &LVL14_DESC = 'FOC_ALL'
-DEFAULT &LVL13_DESC = 'FOC_ALL'
-DEFAULT &LVL12_DESC = 'FOC_ALL'
-DEFAULT &LVL11_DESC = 'FOC_ALL'
-DEFAULT MONTH_ENDING = 'FOC_ALL'

TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING

SUM
     CNT.SERVER_NAME AS 'Instance Count'
     AAA_APP_STATUS/I5 AS 'AAA Apps'
     MONTH_ENDING NOPRINT
     LVL14_DESC NOPRINT
     LVL13_DESC NOPRINT
     LVL12_DESC NOPRINT
     LVL11_DESC NOPRINT
BY DATA_TYPE AS ''
BY HIGHEST STATUS AS ''
BY SUBGROUP AS ''

ON DATA_TYPE SUBTOTAL AS 'TOTAL'
ON TABLE SUBHEAD
"Monthly EOL Reporting - <MONTH_ENDING "
"&LVL12_DESC"
WHERE DATA_TYPE EQ &DATA_TYPE.(OR(FIND DATA_TYPE IN EOLMONTHLYRAWHLDFILE_WORKING)).Select a Category(s).;
WHERE MONTH_ENDING EQ '&MONTH_ENDING.(FIND MONTH_ENDING IN eolmonthlyrawhldfile_working).Select a Month.';
WHERE LVL14_DESC EQ &LVL14_DESC.(OR(FIND LVL14_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select OCM.;
WHERE LVL13_DESC EQ &LVL13_DESC.(OR(FIND LVL13_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select Midlevel.;
WHERE LVL12_DESC EQ &LVL12_DESC.(OR(FIND LVL12_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Business Unit(s).;
WHERE LVL11_DESC EQ &LVL11_DESC.(OR(FIND LVL11_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Dept.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<PowerPoint,PPT>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N2 EQ '1 - Emerging',
$
     DEFMACRO=COND0003,
     MACTYPE=RULE,
     WHEN=N2 EQ '3 - Upgrade',
$
     DEFMACRO=COND0005,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 1',
$
     DEFMACRO=COND0006,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 2',
$
     DEFMACRO=COND0007,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 3',
$
     DEFMACRO=COND0002,
     MACTYPE=RULE,
     WHEN=N2 EQ '2 - Preferred',
$
     DEFMACRO=COND0008,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 4',
$
     DEFMACRO=COND0009,
     MACTYPE=RULE,
     WHEN=N2 EQ '4 - Mandatory Upgrade',
$
     DEFMACRO=COND0010,
     MACTYPE=RULE,
     WHEN=N2 EQ '3 - Upgrade',
$
     DEFMACRO=COND0011,
     MACTYPE=RULE,
     WHEN=N2 EQ '2 - Preferred',
$
     DEFMACRO=COND0012,
     MACTYPE=RULE,
     WHEN=N2 EQ '1 - Emerging',
$
     DEFMACRO=COND0014,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 2',
$
     DEFMACRO=COND0015,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 3',
$
     DEFMACRO=COND0013,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 1',
$
     DEFMACRO=COND0004,
     MACTYPE=RULE,
     WHEN=N2 EQ '4 - Mandatory Upgrade',
$
     DEFMACRO=COND0016,
     MACTYPE=RULE,
     WHEN=N2 EQ 'Stage 4',
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
     BACKCOLOR=RGB(204 255 204),
$
TYPE=DATA,
     COLUMN=N5,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(128 128 255),
$
TYPE=DATA,
     COLUMN=N4,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(128 128 255),
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0009,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0010,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0011,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0012,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0005,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='BLACK',
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0014,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     COLOR='BLACK',
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0015,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0016,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BACKCOLOR=RGB(204 255 204),
     STYLE=BOLD,
     DRILLMENUITEM='Export this Category only',
          OCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC='&LVL11_DESC' \
		  LVL12_DESC='&LVL12_DESC' \
		  LVL13_DESC='&LVL13_DESC' \
		  LVL14_DESC='&LVL14_DESC' \
		  MONTH_ENDING='&MONTH_ENDING'),
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP-STYLE=NONE,
     BORDER-BOTTOM-STYLE=NONE,
     BORDER-LEFT-STYLE=NONE,
     BORDER-RIGHT-STYLE=NONE,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0001,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0003,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='YELLOW',
     STYLE=BOLD,
     MACRO=COND0007,
$
TYPE=DATA,
     COLUMN=N2,
     COLOR='WHITE',
     BACKCOLOR=RGB(67 67 192),
     STYLE=BOLD,
     MACRO=COND0005,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0006,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0002,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0008,
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='RED',
     STYLE=BOLD,
     MACRO=COND0004,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N1,
     BACKCOLOR=RGB(204 255 204),
     STYLE=BOLD,
     DRILLMENUITEM='Export this Category only',
          FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC='&LVL11_DESC' \
		  LVL12_DESC='&LVL12_DESC' \
		  LVL13_DESC='&LVL13_DESC' \
		  LVL14_DESC='&LVL14_DESC' \
		  MONTH_ENDING='&MONTH_ENDING'),
$
TYPE=TITLE,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0006,
$
TYPE=TITLE,
     COLUMN=N2,
     BACKCOLOR='GREEN',
     STYLE=BOLD,
     MACRO=COND0002,
$
TYPE=TITLE,
     COLUMN=N2,
     COLOR=RGB(204 255 204),
     BACKCOLOR=RGB(204 255 204),
     STYLE=NORMAL,
     MACRO=COND0008,
$
TYPE=TITLE,
     COLUMN=N2,
     COLOR=RGB(204 255 204),
     STYLE=NORMAL,
     MACRO=COND0004,
$
TYPE=TABHEADING,
     SIZE=14,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     BACKCOLOR=RGB(255 255 153),
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
     BY=1,
     BACKCOLOR='OLIVE',
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=2.930556,
$
TYPE=REPORT,
     COLUMN=N2,
     SQUEEZE=2.027778,
$
TYPE=REPORT,
     COLUMN=N6,
     SQUEEZE=1.263889,
$
TYPE=REPORT,
     COLUMN=N10,
     WRAP=1.430556,
$
TYPE=REPORT,
     COLUMN=N9,
     WRAP=0.916667,
$
TYPE=REPORT,
     COLUMN=N8,
     WRAP=0.680556,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=0.930556,
$
ENDSTYLE
END

Any Idea's

put -SET &ECHO=ALL; at the top of your parent and child reports. Also, in your child report add
-? &

This will show all the parameter settings that will be used for the child report.

Run the parent report, view source and scroll to where the code is to see what values have been inserted wherever you have used a parameter.

Then click on a link in the parent report to run the child procedure and see what values were passed as well. I am guessing that you are not passing what you are wanting to pass. If you are multi-selecting values, this is going to cause syntax errors because it inserts quote marks and ORs into the parm string. (OR 'value' OR 'value')

Darin, my parent report is picking up the parameters as expected but it is adding quotes to the selection which is causing the error? How do I get rid of the quotes?

Can you show us exactly what it looks like as they are passed?

Maybe this link is similar to your problem?

Try a Forum search for QUOTEDSTRING

AM: Please, re-read Darin Lee's response on 8/27, and mine on 8/28.

Try the parent and Child fex code below. I stripped out the format-related code, retaining just the drilldown.

Substantive changes:

• coded the four "Level" WHEREs in the parent to reference the "&" parameter values (within quotes!) for the four LVL descriptions, rather than values listed in the parent report. (If the values may include quote characters, you should use =&var.QUOTEDSTRING in place of ='&var')
  
• removed LVL11 thru 14 as verb objects in the parent report.
  
• placed each focexec parameter of the drilldowns in the parent's stylesheet on a separate line, as required for proper handling of FOC_NONE.
  
• added DATA_TYPE as a drilldown parameter, and inserted a corresponding WHERE in the child report.
  
• changed the columns title for DATA_TYPE from empty ('') to something printable to hold the hyperlink for the second drilldown.
  

* Parent:

-SET &ECHO=ON;

-? &LVL
-? &DATA
-? &MONTH

TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
SUM
     CNT.SERVER_NAME AS 'Instance Count'
     AAA_APP_STATUS/I5 AS 'AAA Apps'
     MONTH_ENDING NOPRINT
-*   LVL14_DESC NOPRINT
-*   LVL13_DESC NOPRINT
-*   LVL12_DESC NOPRINT
-*   LVL11_DESC NOPRINT
BY DATA_TYPE AS 'Data Type'
BY HIGHEST STATUS AS ''
BY SUBGROUP AS ''

ON TABLE SUBHEAD
"Monthly EOL Reporting - <MONTH_ENDING "
"&LVL12_DESC"

WHERE DATA_TYPE    EQ  &DATA_TYPE.(OR(FIND DATA_TYPE IN EOLMONTHLYRAWHLDFILE_WORKING)).Select a Category(s).;
WHERE MONTH_ENDING EQ '&MONTH_ENDING.(FIND MONTH_ENDING IN eolmonthlyrawhldfile_working).Select a Month.';
WHERE LVL14_DESC   EQ  &LVL14_DESC.(OR(FIND LVL14_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select OCM.;
WHERE LVL13_DESC   EQ  &LVL13_DESC.(OR(FIND LVL13_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select Midlevel.;
WHERE LVL12_DESC   EQ  &LVL12_DESC.(OR(FIND LVL12_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Business Unit(s).;
WHERE LVL11_DESC   EQ  &LVL11_DESC.(OR(FIND LVL11_DESC IN eolmonthlyrawhldfile_bulistings_working)).Select a Dept.;

ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<PowerPoint,PPT>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$ ...
TYPE=DATA,
     COLUMN=N1,
     DRILLMENUITEM='Export this Category only',
-*        FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC=N10 LVL12_DESC=N9 LVL13_DESC=N8 LVL14_DESC=N7 MONTH_ENDING=N6),
          FOCEXEC=eolmonthlyrawdetailchild2_test1( \
            LVL11_DESC='&LVL01_DESC' \
            LVL12_DESC='&LVL12_DESC' \
            LVL13_DESC='&LVL13_DESC' \
            LVL14_DESC='&LVL14_DESC' \
            MONTH_ENDING=N6  \
            DATA_TYPE='&DATA_TYPE'  \
          ),
$
TYPE=TITLE,
     COLUMN=N1,
     DRILLMENUITEM='Export every Category',
-*        FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC=N10 LVL12_DESC=N9 LVL13_DESC=N8 LVL14_DESC=N7 MONTH_ENDING=N6),
          FOCEXEC=eolmonthlyrawdetailchild2_test1( \
            LVL11_DESC='&LVL01_DESC' \
            LVL12_DESC='&LVL12_DESC' \
            LVL13_DESC='&LVL13_DESC' \
            LVL14_DESC='&LVL14_DESC' \
            MONTH_ENDING=N6  \
          ),
$
ENDSTYLE
END

* Child:

-SET &ECHO=ON;
-DEFAULT &LVL14_DESC = 'FOC_NONE'
-DEFAULT &LVL13_DESC = 'FOC_NONE'
-DEFAULT &LVL12_DESC = 'FOC_NONE'
-DEFAULT &LVL11_DESC = 'FOC_NONE'

-? &LVL
-? &DATA
-? &MONTH

TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
PRINT
     DATA_TYPE
     PARENT_GROUP
     MONTH_ENDING
     SUBGROUP
     STATUS
     SERVER_NAME
     AAA_APP_STATUS/I5
     COST_CENTER/I5
     LV/I5
     CC_KEY_DESC
     CC_MGR_NAME
     LVL14_DESC AS 'OCM_DETAIL'
     LVL13_DESC AS 'OCM_BU_MIDLEVEL_DETAIL'
     LVL12_DESC AS 'BU_DETAIL'
     LVL11_DESC AS 'BU_DEPARTMENT'

WHERE DATA_TYPE    EQ '&DATA_TYPE';
WHERE LVL14_DESC   EQ '&LVL14_DESC';
WHERE LVL13_DESC   EQ '&LVL13_DESC';
WHERE LVL11_DESC   EQ '&LVL11_DESC';
WHERE LVL12_DESC   EQ '&LVL12_DESC';
WHERE MONTH_ENDING EQ '&MONTH_ENDING';

ON TABLE PCHOLD FORMAT EXL2K
END

Let us know whether you can get this basic code working.

Note: The way you have them, LVL11 thru 14 are prompted for independently. If any of the four are "nested" (rather than "crossed"), you should use a launch page with appropriate chaining of parameters, rather than relying on Autoprompt. -- but first get the basic report working.

EDITED: .QUOTEDSTRING

This message has been edited. Last edited by: j.gross,

TYPE=TITLE,
COLUMN=N1,
BACKCOLOR=RGB(204 255 204),
STYLE=BOLD,
DRILLMENUITEM='Export this Category only',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC='FOC_NONE' \
LVL12_DESC='FOC_NONE' \
LVL13_DESC='FOC_NONE' \
LVL14_DESC=''Devonshire Investors'' \
MONTH_ENDING='07/31/2009'),
$

Parameters are nowing passing to the child, except the Month_ending, that is one parameter that has to be selected.
(BTW, there is a luach page with the chained parameters)

Here is what is being passed to the child:

CURRENTLY DEFINED & VARIABLES STARTING WITH 'LVL':
&LVL11_DESC = FOC_NONE
&LVL12_DESC = FOC_NONE
&LVL13_DESC = FOC_NONE
&LVL14_DESC = Devonshire Investors
CURRENTLY DEFINED & VARIABLES STARTING WITH 'DATA':
&DATA_TYPE = FOC_NONE
CURRENTLY DEFINED & VARIABLES STARTING WITH 'MONTH':
&MONTH_ENDING =
TABLE FILE EOLMONTHLYRAWHLDFILE_WORKING
PRINT
DATA_TYPE
PARENT_GROUP
MONTH_ENDING
SUBGROUP
STATUS
SERVER_NAME
AAA_APP_STATUS/I5
COST_CENTER/I5
LV/I5
CC_KEY_DESC
CC_MGR_NAME
LVL14_DESC AS 'OCM_DETAIL'
LVL13_DESC AS 'OCM_BU_MIDLEVEL_DETAIL'
LVL12_DESC AS 'BU_DETAIL'
LVL11_DESC AS 'BU_DEPARTMENT'
HEADING
""
FOOTING
""
WHERE DATA_TYPE EQ 'FOC_NONE';
WHERE LVL14_DESC EQ 'Devonshire Investors';
WHERE LVL13_DESC EQ 'FOC_NONE';
WHERE LVL11_DESC EQ 'FOC_NONE';
WHERE LVL12_DESC EQ 'FOC_NONE';
WHERE MONTH_ENDING EQ ' ';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K

My guess is that you've got a syntax error somewhere that is causing it to lose the last parm - like the double quotes around the lvl14_desc. &MONTH_ENDING is just a regular string so it should be the easiest of all to pass - MONTH_ENDING='&MONTH_ENDING'

This message has been edited. Last edited by: Darin Lee,

quote:

TYPE=TITLE,
COLUMN=N1,
BACKCOLOR=RGB(204 255 204),
STYLE=BOLD,
DRILLMENUITEM='Export this Category only',
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC='FOC_NONE' \
LVL12_DESC='FOC_NONE' \
LVL13_DESC='FOC_NONE' \
LVL14_DESC=''Devonshire Investors'' \
MONTH_ENDING='07/31/2009'),
$

That's an echo (and the LVL11,12,13 values are FOC_NONE).

Two things are wrong, probably leading to an error message about invalid Stylesheet syntax:

1. The first paraneter needs to be detached from "FOCEXEC=eolmonthlyrawdetailchild2_test1(", and placed by itself on a continuation line, thus:

FOCEXEC=eolmonthlyrawdetailchild2_test1( \
LVL11_DESC='FOC_NONE' \

As your code stands, when the launch or autoprompt page feeds LVL11_DESC=FOC_NONE to the parent fex the whole line reading
FOCEXEC=eolmonthlyrawdetailchild2_test1(LVL11_DESC='FOC_NONE' \
and the other two lines with FOC_NONE all effecively get dropped. After removing them, what's left of this stylesheet phrase is

TYPE=TITLE,
COLUMN=N1,
BACKCOLOR=RGB(204 255 204),
STYLE=BOLD,
DRILLMENUITEM='Export this Category only',
LVL14_DESC=''Devonshire Investors'' \
MONTH_ENDING='07/31/2009'),
$
which has unbalanced parens amonf other things.

2. The value received for LVL14_DESC already contains surrounding quotes; so you need to use .QUOTEDSTRING:
LVL14_DESC=&LVL14_DESC.QUOTEDSTRING \

Correct those items and you should be able to get the child report. When you run the parent to HTML, "view source" should show the stylesheet drilldown as:

TYPE=TITLE,
COLUMN=N1,
BACKCOLOR=RGB(204 255 204),
STYLE=BOLD,
DRILLMENUITEM='Export this Category only',
FOCEXEC=eolmonthlyrawdetailchild2_test1( \
LVL11_DESC='FOC_NONE' \
LVL12_DESC='FOC_NONE' \
LVL13_DESC='FOC_NONE' \
LVL14_DESC='''Devonshire Investors''' \
MONTH_ENDING='07/31/2009' \
),
$

This message has been edited. Last edited by: j.gross,

I want to thank everyone who helped on this thread! I was able to get it all working properly and it is because of all your help.

Added -SET for the variable fields in the Parent

  
-SET &DATA_TYPE1 = IF &DATA_TYPE EQ 'FOC_NONE' THEN ''''||' '|'''' ELSE &DATA_TYPE;
-SET &LVL11_DESC1 = IF &LVL11_DESC EQ 'FOC_NONE' THEN ''''||' '|'''' ELSE &LVL11_DESC;
-SET &LVL12_DESC1 = IF &LVL12_DESC EQ 'FOC_NONE' THEN ''''||' '|'''' ELSE &LVL12_DESC;
-SET &LVL13_DESC1 = IF &LVL13_DESC EQ 'FOC_NONE' THEN ''''||' '|'''' ELSE &LVL13_DESC;
-SET &LVL14_DESC1 = IF &LVL14_DESC EQ 'FOC_NONE' THEN ''''||' '|'''' ELSE &LVL14_DESC;

Change the DRILLMENU items on the Parent:

  

TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BACKCOLOR=RGB(204 255 204),
     STYLE=BOLD,
     DRILLMENUITEM='Export ALL Categories',
      FOCEXEC=eolmonthlyrawdetailchild2(LVL11_DESC=&LVL11_DESC1 \
      LVL12_DESC=&LVL12_DESC1 \
      LVL13_DESC=&LVL13_DESC1 \
      LVL14_DESC=&LVL14_DESC1 \
      MONTH_ENDING='&MONTH_ENDING'),

$

On the Child, also added SET statements:

  

-SET &LVL11_DESC  = IF &LVL11_DESC EQ ' ' THEN FOC_NONE ELSE &LVL11_DESC;
-SET &LVL12_DESC  = IF &LVL12_DESC EQ ' ' THEN FOC_NONE ELSE &LVL12_DESC;
-SET &LVL13_DESC  = IF &LVL13_DESC EQ ' ' THEN FOC_NONE ELSE &LVL13_DESC;
-SET &LVL14_DESC  = IF &LVL14_DESC EQ ' ' THEN FOC_NONE ELSE &LVL14_DESC;

I hope this helps other novices. I know I learned a lot and a lot more to go