I have a main report that has 5 paramters that are multi-select, the child report has the same paramters but when selecting ALL it is returning 0 rows. Any idea's?

Here is the parent report text:

SET LINES = 9999
SET PAGE-NUM = NOPAGE

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 - "&LVL12_DESC"
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.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(,,,).Select type of display output.
ON TABLE SET HTMLCSS ON

Here is the child report text:

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 '&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 SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K

This message has been edited. Last edited by: Kerry,

What's in the stylesheet for the drill on the parent report. You have to pass the selected parms to the child report. It doesn't automatically know what was selected in the parent report.

Here is the entire parent report:

SET LINES = 9999
SET PAGE-NUM = NOPAGE

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 - "&LVL12_DESC"
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.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(,,,).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=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),
$
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=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),
$
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,
DRILLMENUITEM='Export this section 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 Sections',
FOCEXEC=eolmonthlyrawdetailchild2_test(LVL14_DESC=N7 LVL13_DESC=N8 LVL12_DESC=N9 LVL11_DESC=N10 MONTH_ENDING=N6),
$
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=N10,
WRAP=1.041667,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=1.555556,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=1.263889,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.027778,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=0.805556,
$
ENDSTYLE
END

The ALL selection generates the string FOC_NONE and the entire line with that on it is not placed in the focstack. For the stylesheet drill for the child report, you are either going to have to pass the value FOC_NONE so that the where in it will be bypassed or you are going to have to alter your drill to pass a flag to bypass the where statements in the child.

Hopefully, this will help you understand what is happening. If you do a view source on your parent output, check out how the drill syntax is represented when you select ALL. That will give you a better idea as to why your child program is failing to return any rows.

Also do a forum search on FOC_NONE. There are lots of discussions on how it operates which might help you.

The HTML Source from the Parent: Looks Like the one paramter sent is defaulting to all the other parameters??







<script language='javascript'>
var ibiOptions = new Array("multidrill");
var focexurl = "/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&";
var fochtmlurl = "/ibi_html";
var serverLanguage='en';

<script language='javascript' src='/ibi_html/javaassist/nls.js'>
<script language='javascript' src='/ibi_html/javaassist/ibi/html/js/ibigbl.js'>

<script language='javascript'>
ibigblloadCss(null);

<script LANGUAGE=JAVASCRIPT>
var MDitems=new Array();
MDitems[0]=new Object();
MDitems[0].text="Export this Category only";
MDitems[0].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild_test&";
MDitems[0].target="";
MDitems[1]=new Object();
MDitems[1].text="Export ALL Categories";
MDitems[1].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild2_test1&";
MDitems[1].target="";
MDitems[2]=new Object();
MDitems[2].text="Export this Category only";
MDitems[2].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild_test&";
MDitems[2].target="";
MDitems[3]=new Object();
MDitems[3].text="Export ALL Categories";
MDitems[3].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild2_test1&";
MDitems[3].target="";
MDitems[4]=new Object();
MDitems[4].text="Export this section only";
MDitems[4].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild_test&";
MDitems[4].target="";
MDitems[5]=new Object();
MDitems[5].text="Export ALL Sections";
MDitems[5].url="/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=a314262_mcgowan&IBIF_ex=eolmonthlyrawdetailchild2_test&";
MDitems[5].target="";

Monthly EOL Reporting - 07/31/2009
			Instance Count	AAA Apps
Database EOL - Monthly Raw Data	4 - Mandatory Upgrade	SQL SERVER 8.X	1	1
	2 - Preferred	ORACLE 10.2	4	0
TOTAL Database EOL - Monthly Raw Data			5	1
HW EOL - Monthly Raw Data	Stage 4	Hardware	93	1
	Stage 3	Hardware	77	4
	Stage 2	Hardware	285	11
	Stage 1	Hardware	15	0
TOTAL HW EOL - Monthly Raw Data			470	16
Middleware EOL - Monthly Raw Data	4 - Mandatory Upgrade	Websphere 5.1	2	0
	2 - Preferred	Websphere 6.1	7	0
TOTAL Middleware EOL - Monthly Raw Data			9	0
OS Compliance - Monthly Raw Data	4 - Mandatory Upgrade	LINUX	3	0
		SOLARIS	1	1
		WINDOWS	2	2
	2 - Preferred	AIX	5	0
		LINUX	8	1
		SOLARIS	5	0
		WINDOWS	12	1
TOTAL OS Compliance - Monthly Raw Data			36	5
OS EOL - Monthly Raw Data	4 - Mandatory Upgrade	LINUX RHEL 3.0	2	0
		SOLARIS 8	5	1
	3 - Upgrade	SOLARIS 9	1	0
	2 - Preferred	AIX 5.3	5	0
		LINUX RHEL 4.0	9	1
		WINDOWS 2003	14	3
TOTAL OS EOL - Monthly Raw Data			36	5

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

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