Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] The ALL parameter not passing to the child report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] The ALL parameter not passing to the child report
 Login/Join
 
<AM>
posted
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,
 
Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
<AM>
posted
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
 
Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
<AM>
posted
The HTML Source from the Parent: Looks Like the one paramter sent is defaulting to all the other parameters??





WebFOCUS Report

<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
 
 
Report This Post
Virtuoso
posted Hide Post
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,


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
<AM>
posted
After putting the set &echo on the parent I got
(FOC3213) ILLEGAL SET VALUE: ALL; ???
 
Report This Post
Expert
posted Hide Post
-SET &ECHO=ALL;


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


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
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.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
<AM>
posted
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>,
 
Report This Post
Expert
posted Hide Post
AM,

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


</>


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
<AM>
posted
Also, the parameters on this report are all Dynamic and getting values from a hold file.
 
Report This Post
Virtuoso
posted Hide Post
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.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
<AM>
posted
Will the
-DEFAULT &LV13_DESC = 'FOC_NONE'
work for passing to the child, if ALL is selected?
 
Report This Post
Virtuoso
posted Hide Post
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' \
	 ),
$


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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?


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
<AM>
posted
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.
 
Report This Post
<AM>
posted
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.
 
Report This Post
<AM>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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')


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
<AM>
posted
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?
 
Report This Post
Virtuoso
posted Hide Post
Can you show us exactly what it looks like as they are passed?

Maybe this link is similar to your problem?


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Try a Forum search for QUOTEDSTRING


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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,


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
<AM>
posted
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'),
$
 
Report This Post
<AM>
posted
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
 
Report This Post
Virtuoso
posted Hide Post
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,


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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,


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
<AM>
posted
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 Big Grin
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] The ALL parameter not passing to the child report

Copyright © 1996-2020 Information Builders