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     [CLOSED]Chaining Help

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Chaining Help
 Login/Join
 
Member
posted
I am having some trouble getting the chaining feature to work on my html page. I keep getting an error that says there appears to be an issue chaining listbox1 to listbox2. Please check the procedures and Resolve parameter values. I have read the article written by Barry Soloman and understand that the parameters must match in both the procedure and resolve to, but I am still receiving this error. Has anyone else had this problem? How did you overcome it?

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


WebFOCUS 8.1.05
Linux, All Outputs
 
Posts: 5 | Registered: July 20, 2015Report This Post
Virtuoso
posted Hide Post
Shauna,

Are you working in AppStudio trying to build it within the GUI? Would you be willing to post all code involved so we can look at it? (Note: When doing so, use the angle bracket icon to create code tags to copy your code inside of before pasting.)

Thanks!


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Member
posted Hide Post
Hi CoolGuy,

I am using AppStudio for the chaining part of the html, however the fex was written in DevStudio. I followed the directions outlined in Barry Solomans article, but I must confess I have very little experience in both AppStudio and the GUI. I would be happy to post the code. I appreciate any assistance you can offer.

The code below reflects that of the fex
  
APP PATH PROD
-*-------------------------------------------------------------------------------------
-SET &SEMESTER_TERM = EDIT(&TERM,'9999');
-SET &SEMESTER_CODE = EDIT(&TERM,'$$$$99');
-SET &YEAR_MINUS_1 = EDIT(&SEMESTER_TERM - 1);
-SET &YEAR_MINUS_2 = EDIT(&SEMESTER_TERM - 2);
-SET &YEAR_MINUS_3 = EDIT(&SEMESTER_TERM - 3);
-SET &YEAR_MINUS_4 = EDIT(&SEMESTER_TERM - 4);
-*-------------------------------------------------------------------------------------
-SET &PREVIOUS_TERM1 = &YEAR_MINUS_1||&SEMESTER_CODE;
-SET &PREVIOUS_TERM2 = &YEAR_MINUS_2||&SEMESTER_CODE;
-SET &PREVIOUS_TERM3 = &YEAR_MINUS_3||&SEMESTER_CODE;
-SET &PREVIOUS_TERM4 = &YEAR_MINUS_4||&SEMESTER_CODE;
-*-------------------------------------------------------------------------------------
-TYPE &SEMESTER_TERM;
-TYPE &YEAR_MINUS_1;
-TYPE &YEAR_MINUS_2;
-TYPE &YEAR_MINUS_3;
-TYPE &YEAR_MINUS_4;
-TYPE Enrollment Term = &SEMESTER_TERM
-TYPE Previous term1 = &PREVIOUS_TERM1
-TYPE Previous term2 = &PREVIOUS_TERM2
-TYPE Previous term3 = &PREVIOUS_TERM3
-TYPE Previous term4 = &PREVIOUS_TERM4
-*-------------------------------------------------------------------------------------
*IA_GRAPH_BEGIN
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-*-------------------------------------------------------------------------------------
-*Do not delete or modify the comments above
-*-------------------------------------------------------------------------------------
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments above
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments above
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments below
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments above
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT WHERE TERM_CODE_KEY IN ('&TERM','&PREVIOUS_TERM1','&PREVIOUS_TERM2','&PREVIOUS_TERM3','&PREVIOUS_TERM4')
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.TERM_CODE_KEY EQ &TERM. (|FORMAT=A6V).QUOTEDSTRING;
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments above
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments below
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT -*Do not delete or modify the comments above
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT WHERE TERM_CODE_KEY IN ('&TERM','&PREVIOUS_TERM1','&PREVIOUS_TERM2','&PREVIOUS_TERM3','&PREVIOUS_TERM4')
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
-**-INTERNAL_COMMENT WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.TERM_CODE_KEY EQ &TERM. (|FORMAT=A6V).QUOTEDSTRING;
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+CjwhLS0xLjAtLT48Um9vdCB2ZXJzaW9uPSIxLjAiPgogICAgPE9iamVjdCBvYmplY3RJZD0iQ2hhcnRfMSI+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+CiAgICA8L09iamVjdD4KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkdMT0JBTCI+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj5mYWxzZTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj41MDA8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSdW5SZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbE9wdGltaXphdGlvbiIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJmaWVsZERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5sYWJlbDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9InByZWZpeERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkFjdGl2ZV9TdHlsZV9Vc2VyX3R5cGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnBvd2VyPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsVmFsdWVzUGFnaW5nIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj40PC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiPgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkVkaXRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJhdXRvRHJpbGxTY3JpcHQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwRGVmZXJyZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheURhdGFUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9InJ1bk9uU3RhcnR1cEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUludGVyYWN0aXZlTW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXRfbGF5b3V0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVF1aWNrQWNjZXNzVG9vbGJhclNhdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jb21wb3NlX2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UERGPC9FbnRyeT4KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+CiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5PgogICAgICAgIDwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlw
*-INTERNAL_COMMENT LINE#1$ZT0iTWFwIi8+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ik1hc3Rlcl9GaWxlcyIgdHlwZT0iU2V0Ij4KICAgICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciPkFTX1NUVURFTlRfRU5ST0xMTUVOVF9TVU1NQVJZPC9FbnRyeT4KICAgICAgICA8L1Byb3BlcnR5PgogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJtZXRhZGF0YVZpZXdBcyIgdHlwZT0iTWFwIj4KICAgICAgICAgICAgPEVudHJ5IGtleT0iSE9MRDEiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX0RJTVM8L0VudHJ5PgogICAgICAgICAgICA8RW50cnkga2V5PSJBU19TVFVERU5UX0VOUk9MTE1FTlRfU1VNTUFSWSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfRElNUzwvRW50cnk+CiAgICAgICAgPC9Qcm9wZXJ0eT4KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2xpY2VyR3VpSXNsYW5kIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5leUppUVhWMGIxQnlaWFpwWlhjaU9tWmhiSE5sTENKaVQzQjBhVzl1YzBkeWIzVndWbWx6YVdKc1pTSTZkSEoxWlN3aVlsSmxZMHhwYldsMFIzSnZkWEJXYVhOcFlteGxJanAwY25WbExDSmlVSEpsZG1sbGQwTnZiblJ5YjJ4V2FYTnBZbXhsSWpwMGNuVmxMQ0ppVW5WdWRHbHRaVU52Ym5SeWIyeFdhWE5wWW14bElqcDBjblZsZlE9PTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNMSUNFUl9JTkZPUk1BVElPTiIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UEQ5NGJXd2dkbVZ5YzJsdmJqMGlNUzR3SWlCbGJtTnZaR2x1WnowaVZWUkdMVGdpSUhOMFlXNWtZV3h2Ym1VOUltNXZJajgrUENFdExVTlBUVkJNUlZSRlgxTk1TVU5GVWw5SFVrOVZVQzB0UGp4VFRFbERSVkpmUjFKUFZWQStQRWRTVDFWUUlHZHliM1Z3VG5WdFltVnlQU0l3SWlCemJHbGpaWEpIY205MWNFeGhZbVZzUFNKSGNtOTFjQ0F4SWlCemJHbGpaWEpIY205MWNFOXlaR1Z5UFNJd0lpQnpiR2xqWlhKSGNtOTFjRk5wZW1VOUlqQWlJSE5zYVdObGNrZHliM1Z3YUdsa1pUMGlabUZzYzJVaUx6NDhMMU5NU1VORlVsOUhVazlWVUQ0PTwvUHJvcGVydHk+CiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImVuYWJsZVByZXZpZXciIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4KICAgIDwvT2JqZWN0Pgo8L1Jvb3Q+Cg==
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE AS_STUDENT_ENROLLMENT_SUMMARY
-* Created by Info Assist for Graph
SUM CNT.AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.PIDM_KEY AS 'Total'
BY AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.TERM_CODE_KEY AS 'Term'
WHERE TERM_CODE_KEY IN ('&TERM','&PREVIOUS_TERM1','&PREVIOUS_TERM2','&PREVIOUS_TERM3','&PREVIOUS_TERM4')-* (|FORMAT=A6V).QUOTEDSTRING;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.TOTAL_CREDIT_HOURS GT 0;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.COLL_CODE EQ &COLL.(OR(FIND STVCOLL_CODE IN STVCOLL)).College.;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.DEGC_CODE EQ &DEGC.(OR(FIND STVDEGC_CODE IN STVDEGC)).Degree.;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.MAJR_CODE1 EQ &MAJR.(OR(FIND STVMAJR_CODE IN STVMAJR)).Major.;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.LEVL_CODE EQ &LEVL.(OR(FIND STVLEVL_CODE IN STVLEVL)).Level.;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.GENDER EQ &GENDER.(OR(FIND SPBPERS_SEX IN SPBPERS)).Gender.;
WHERE AS_STUDENT_ENROLLMENT_SUMMARY.AS_STUDENT_ENROLLMENT_SUMMARY.ETHN_CODE EQ ÐN.(OR(FIND STVETHN_CODE IN STVETHN)).Ethnic Code.;
HEADING
"Enrollment By Term"
" "
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N2, TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/REC009R-BY-TERMS_Drill_Down.fex(TERM=&TERM.QUOTEDSTRING
GENDER_FILT=&GENDER.QUOTEDSTRING GENDER_DRILL=GENDER COLL_CODEFILT=&COLL.QUOTEDSTRING DEGC_CODEFILT=&DEGC.QUOTEDSTRING MAJR_CODE1FILT=&MAJR.QUOTEDSTRING LEVL_CODEFILT=&LEVL.QUOTEDSTRING ETHN_CODEFILT=ÐN.QUOTEDSTRING), $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
-*setDataTextDisplay(true);
setDataTextPosition(3);
setSeriesType(0,0);
setCurveFitEquationDisplay(false);
setFillColor(getSeries(0),new Color(0,62,128));
setPieTilt(10);
setPieDepth(70);
setDepthRadius(5);
setDepthAngle(100);
setFillColor(getFrame(),new Color(255, 255, 255));
setTextString(getO1Title(),"");
setTransparentFillColor(getFrame(),true);
setColorMode(1);
setFillColor(getChartBackground(),new Color(255,255,255));
setTransparentBorderColor(getChartBackground(),true);
*GRAPH_JS
"riserBevel": "cylinder"
,
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH
-RUN

-*IA_GRAPH_FINISH

-*----------------------------------------------------------------------------
The code below reflects that of the html page in which I am trying to chain the parameters.

 <!DOCTYPE html>
<html><head><meta id="RLT_STANDARDS_MODE_META" http-equiv="X-UA-Compatible" content="IE=Edge"><meta name="mycharsetmeta" http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta name="Generation" content="Created in release 8105, Generation 4"><meta name="viewport" content="width=device-width, initial-scale=1.0">
<script type="text/javascript">
//confidential_id=IBI_OptionsScript
var bRuntimes=true;var szHtmlAlias="./ibi_html/";var is_mobile="false";var szRunTimeHtmlAlias="runTimeHtmlAlias";var cgipath="cgipath";var ib_composer="ib_composer";var map="ib_composer_map";var grid="ib_composer_grid";var emf="ib_composer_emf";var ibiOptions = new Array(cgipath,ib_composer);if(typeof(szRunTimeHtmlAlias) === 'string' && szRunTimeHtmlAlias.indexOf('/') == 0)szHtmlAlias=szRunTimeHtmlAlias;document.write('<script src="'+szHtmlAlias+'ibigbl.js" type="text/javascript"><\/script>');</script><script type="text/javascript">
//confidential_id=IBI_ibigblloadCss
if(typeof ibigblloadCss === 'function'){ibigblloadCss(null);addIntlTranslatedJS("composertrans.js");}else {alert("JavaScript alias './ibi_html/'  is not valid.");window.location("about:blank");}</script><title>HtmlPage</title>
<script type="text/javascript">//confidential_id=clientEventHandlersJS
//Begin function window_onload
function window_onload() {
 
UpdateData();
 
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
//Begin function button3_onclick
function button3_onclick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function button3_onclick
</script>
<style>.internal_default {
	
}
</style><!--//confidential_id=focus_xmlelement
<rootxmlnode focoption="_FOC_NULL" nextelementuniquenumber="6" top="100" left="10" width="150" height="130"><variables><variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="TERM" name="TERM" default="" textvarname="" accept="0" select="0" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,37,90,84" inbinding="1"><requestid id="5">
			
</requestid><requestid id="7"></requestid><data_info datatype="0" modifiedrequest="0" displayfield="TERM" datafield="TERM" datasource="hold1a.mas" ibif_ex="hold1a" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster">
			</data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="College" name="COLL" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,148,90,192" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="STVCOLL_CODE" ibiformat="A2V" datafield="STVCOLL_CODE" datasource="STVCOLL.mas" ibif_ex="STVCOLL" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster">
			</data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="Degree" name="DEGC" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,256,90,304" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="STVDEGC_CODE" ibiformat="A6V" datafield="STVDEGC_CODE" datasource="STVDEGC.mas" ibif_ex="STVDEGC" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="Major" name="MAJR" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,367,90,414" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="STVMAJR_CODE" ibiformat="A4V" datafield="STVMAJR_CODE" datasource="STVMAJR.mas" ibif_ex="STVMAJR" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster">
			
</data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="Level" name="LEVL" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,479,90,522" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="STVLEVL_CODE" ibiformat="A2V" datafield="STVLEVL_CODE" datasource="STVLEVL.mas" ibif_ex="STVLEVL" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster">
			</data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="Gender" name="GENDER" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,577,90,643" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="SPBPERS_SEX" ibiformat="A1V" datafield="SPBPERS_SEX" datasource="SPBPERS.mas" ibif_ex="SPBPERS" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></variable><variable controltype="9" parametercreatedinreslay="0" type="unresolved" desc="Ethnic Code" name="ETHN" default="" textvarname="" accept="0" select="1" create="1" requests_list="Request1;Request2;Request3;Request4" defaultinbindinglocation="70,698,90,743" inbinding="1"><requestid id="5"></requestid><requestid id="7"></requestid><data_info datatype="1" modifiedrequest="0" displayfield="STVETHN_CODE" ibiformat="A2V" datafield="STVETHN_CODE" datasource="STVETHN.mas" ibif_ex="STVETHN" selectedvalue="" operation="OR" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster">
			</data_info></variable></variables><requests nextrequestsid="4"><request requestid="Request1" targettype="iframe" targetname="graph1" sourcetype="typeFex" ibif_ex="/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/REC009R-BY-TERMS-JEREMY1.fex" ibiapp_app="std_reports/dashboardt0c/Local_Data/Shauna_Test" activereport="0" reportcolumns="" reportrealcolumns="">
		
</request><request requestid="Request2" targettype="iframe" targetname="graph2" sourcetype="typeFex" ibif_ex="/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/REC009R-BY-GENDER.fex" ibiapp_app="std_reports/dashboardt0c/Local_Data/Shauna_Test" activereport="0" reportcolumns="" reportrealcolumns=""></request><request requestid="Request3" targettype="iframe" targetname="graph3" sourcetype="typeFex" ibif_ex="/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/REC009R-BY-ETHNICITY1.fex" ibiapp_app="std_reports/dashboardt0c/Local_Data/Shauna_Test" activereport="0"></request><request requestid="Request4" targettype="iframe" targetname="graph4" sourcetype="typeFex" ibif_ex="/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/REC009R-BY-ETHNICITY-FALL-ONLY.fex" ibiapp_app="std_reports/dashboardt0c/Local_Data/Shauna_Test" activereport="0"></request></requests><html_elements><html_element bindcontrolid="button3" oldOnclickEvent="button3_onclick" requests_list="3;0;5;7" autoExecute="false"/><html_element bindcontrolid="graph1" elementtype="3" requests_list="0" autoExecute="True"/><html_element bindcontrolid="graph2" elementtype="3" requests_list="3" autoExecute="True"/><html_element bindcontrolid="panel1" elementtype="34" myviewonautofit="dontyouever"/><html_element bindcontrolid="edit1" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" defaultselection="1" inputcontrol="1" elementtype="7" name="edit1" id="edit1" multiple="0" onetimepopulated="1" controltype="7" inbinding="1" defaultinbindinglocation="20,40,40,80" linktype="none" myviewonautofit="dontyouever"><link linktype="default" persistentuniqueid="compUid_1"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="0" modifiedrequest="0" datasource="as_student_enrollment_summary.mas" ibif_ex="as_student_enrollment_summary" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE" selectedvalue="201630"><static_values><static value="201630" display="201630" selected="1" noinput="0">
							
</static></static_values><selectionto_item type="variable" id="TERM"></selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="listbox1" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,60" inputcontrol="1" elementtype="9" name="listbox1" id="listbox1" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,142,40,199" linktype="none" myviewonautofit="dontyouever" defaultselection="1"><link linktype="default" persistentuniqueid="compUid_4"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="1" modifiedrequest="0" datasource="STVCOLL.mas" ibif_ex="STVCOLL" datafield="STVCOLL.STVCOLL.STVCOLL_CODE" displayfield="STVCOLL.STVCOLL.STVCOLL_CODE" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A2V" dfformat="A2V" accept="0" selectedvalue="" operation="OR" checkForDuplicateValues="0" sorttype="1"><selectionto_item type="variable" id="COLL"></selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="listbox2" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,90" inputcontrol="1" elementtype="9" name="listbox2" id="listbox2" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,252,40,309" linktype="none" myviewonautofit="dontyouever" defaultselection="1"><link linktype="default" persistentuniqueid="compUid_5"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="1" modifiedrequest="0" datasource="stvdegc" ibif_ex="stvdegc" datafield="STVDEGC.STVDEGC.STVDEGC_CODE" displayfield="STVDEGC.STVDEGC.STVDEGC_CODE" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A6V" dfformat="A6V" accept="0" selectedvalue="" operation="OR" checkForDuplicateValues="0" fieldtoresolveparameter="STVCOLL_CODE" sorttype="1"><selectionto_item type="variable" id="DEGC">
						
</selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="listbox3" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,74" inputcontrol="1" elementtype="9" name="listbox3" id="listbox3" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,362,40,419" linktype="none"><link linktype="default" persistentuniqueid="compUid_6" from="listbox2"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="DEGC" resolveparameter="DEGC"><data_info datatype="1" modifiedrequest="0" datasource="STVMAJR.mas" ibif_ex="STVMAJR" datafield="STVMAJR.STVMAJR.STVMAJR_CODE" displayfield="STVMAJR.STVMAJR.STVMAJR_CODE" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A4V" dfformat="A4V" accept="0" selectedvalue="" operation="OR" checkForDuplicateValues="0"><selectionto_item type="variable" id="MAJR"></selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="listbox4" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,60" defaultselection="1" inputcontrol="1" elementtype="9" name="listbox4" id="listbox4" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,472,40,529" linktype="none"><link linktype="default" persistentuniqueid="compUid_3"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="1" modifiedrequest="0" datasource="STVLEVL.mas" ibif_ex="STVLEVL" datafield="STVLEVL.STVLEVL.STVLEVL_CODE" displayfield="STVLEVL.STVLEVL.STVLEVL_CODE" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A2V" dfformat="A2V" accept="0" selectedvalue="" operation="OR" checkForDuplicateValues="0"><selectionto_item type="variable" id="LEVL">
</selectionto_item>
					</data_info></condition>
			</link></html_element><html_element bindcontrolid="listbox5" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,60" inputcontrol="1" elementtype="9" name="listbox5" id="listbox5" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,582,40,639" linktype="none"><link linktype="default"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="1" modifiedrequest="0" datasource="SPBPERS.mas" ibif_ex="SPBPERS" datafield="SPBPERS.SPBPERS.SPBPERS_SEX" displayfield="SPBPERS.SPBPERS.SPBPERS_SEX" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A1V" dfformat="A1V" accept="0" selectedvalue="" operation="OR"><selectionto_item type="variable" id="GENDER"></selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="listbox6" requiredfield="1" boundtovariable="1" defaultlocation="0,0,41,60" defaultselection="1" inputcontrol="1" elementtype="9" name="listbox6" id="listbox6" multiple="1" onetimepopulated="0" controltype="7" inbinding="1" defaultinbindinglocation="20,692,40,749" linktype="none"><link linktype="default" persistentuniqueid="compUid_2"><condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"><data_info datatype="1" modifiedrequest="0" datasource="STVETHN.mas" ibif_ex="STVETHN" datafield="STVETHN.STVETHN.STVETHN_CODE" displayfield="STVETHN.STVETHN.STVETHN_CODE" addalloption="1" sourcetype="typeMaster" cacheruntimedata="0" dynalldisplayvalue="ALL" ibiformat="A2V" dfformat="A2V" accept="0" selectedvalue="" operation="OR" checkForDuplicateValues="0"><selectionto_item type="variable" id="ETHN"></selectionto_item></data_info></condition></link></html_element><html_element bindcontrolid="image1" originalWidth="949" originalHeight="135"/>

		<html_element bindcontrolid="graph3" elementtype="3" requests_list="4" autoExecute="True"/>
		<html_element bindcontrolid="graph4" elementtype="3" requests_list="6" autoExecute="True"/><html_element bindcontrolid="image2" rtFileName="/WFC/Repository/irh7meqy/others/TAMUC_Banner.jpg" originalWidth="949" originalHeight="135" myviewonautofit="dontyouever"/><html_element bindcontrolid="text1" elementtype="4"/><html_body edaconnectionrequired="true" elementtype="21" thumbnailscale="4" maptype="0" use_appl_css="no" autofitchildren="no" mobiledocument="no" ibiapp_app="" ismre="1" ibif_ex="/WFC/Repository/irh7meqy/std_reports/dashboardt0c/Local_Data/Shauna_Test/Enrollment_Demographics/Local_Enrollment1.htm"><html_event eventname="load" eventhandlername="window_onload"/><layer name="default"/></html_body><html_element bindcontrolid="label2" myviewonautofit="dontyouever"/><html_element rtFileName="htmlpathsub/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/default_theme.css" bindcontrolid="LINK1" type="cssfile"/><html_element rtFileName="htmlpathsub/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/ibi.css" bindcontrolid="IBI_THEME_CSS" desc="Information Builders" type="cssfile"/></html_elements><tasks><task id="load" trigger="load"><taskitem id="Request1" sourcetype="typeFex" targettype="iframe" targetname="graph1"/><taskitem id="Request2" sourcetype="typeFex" targettype="iframe" targetname="graph2"/><taskitem id="Request3" sourcetype="typeFex" targettype="iframe" targetname="graph3"/><taskitem id="Request4" sourcetype="typeFex" targettype="iframe" targetname="graph4"/></task><task id="task2" trigger="click" specifictrigger="button3"><taskitem id="Request1" sourcetype="typeFex" targetname="graph1" targettype="iframe"/><taskitem id="Request2" sourcetype="typeFex" targetname="graph2" targettype="iframe"/><taskitem id="Request3" sourcetype="typeFex" targetname="graph3" targettype="iframe"/><taskitem id="Request4" sourcetype="typeFex" targetname="graph4" targettype="iframe"/>
</task></tasks><animations></animations></rootxmlnode>
--><script type="text/javascript">
//confidential_id=updateHeadElements
if(typeof updateHeadElements === 'function'){updateHeadElements();}</script></head>
<body class="IBI_PageBg" style="z-index: 0; background-color: transparent;"><iframe title="REC009R-BY-TERMS-JEREMY1.fex" class="IBIfield IBI_Report-iFrame IBI_rounded_m" id="graph1" frameborder="no" style="left: 40px; top: 317px; width: 450px; height: 350px; position: absolute; z-index: 1; background-color: transparent;" heightold="350" widthold="450" size_to_fit="1" name="graph1"></iframe><iframe title="REC009R-BY-GENDER.fex" class="IBIfield IBI_Report-iFrame IBI_rounded_m" id="graph2" frameborder="no" style="left: 580px; top: 320px; width: 450px; height: 350px; position: absolute; z-index: 21; background-color: transparent;" heightold="350" widthold="450" size_to_fit="1" name="graph2"></iframe><span id="panel1" style="left: 20px; top: 130px; width: 950px; height: 120px; position: absolute; z-index: 22; background-color: rgb(0, 62, 128);"><label class="IBIfield IBI_ReportControlLabel" id="label1" style="left: 5px; top: 5px; width: 27px; height: 13px; color: white; position: absolute; z-index: 6; cursor: default;" for="edit1" name="edit1">TERM</label><input tabindex="4" class="IBIfield IBI_ReportControlTarget  IBI_rounded_s IBI_TextBox" id="edit1" style="left: 5px; top: 28px; width: 140px; overflow: visible; position: absolute; z-index: 7; -ms-overflow-y: visible;" spellcheck="false" type="text" hspace="0" value="201630" name="edit1"><label class="IBIfield IBI_ReportControlLabel" id="label2" style="left: 155px; top: 5px; width: 35px; height: 13px; color: white; position: absolute; z-index: 8; cursor: default;" for="listbox1" name="">College </label><select tabindex="5" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox1" style="left: 155px; top: 28px; width: 80px; height: 41px; position: absolute; z-index: 9;" spellcheck="false" size="3" multiple>
</select><label class="IBIfield IBI_ReportControlLabel" id="label3" style="left: 245px; top: 5px; width: 35px; height: 13px; color: white; position: absolute; z-index: 10; cursor: default;" for="listbox2" name="">Degree
</label><select tabindex="6" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox2" style="left: 245px; top: 28px; width: 110px; height: 41px; position: absolute; z-index: 11;" spellcheck="false" size="3" multiple></select><label class="IBIfield IBI_ReportControlLabel" id="label4" style="left: 365px; top: 5px; width: 27px; height: 13px; color: white; position: absolute; z-index: 12; cursor: default;" for="listbox3" name="">Major</label><select tabindex="7" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox3" style="left: 365px; top: 28px; width: 94px; height: 41px; position: absolute; z-index: 13;" spellcheck="false" size="3" multiple></select><label class="IBIfield IBI_ReportControlLabel" id="label5" style="left: 480px; top: 10px; width: 25px; height: 13px; color: white; position: absolute; z-index: 14; cursor: default;" for="listbox4" name="">Level</label><select tabindex="8" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox4" style="left: 480px; top: 30px; width: 80px; height: 41px; position: absolute; z-index: 15;" spellcheck="false" size="3" multiple></select><label class="IBIfield IBI_ReportControlLabel" id="label6" style="left: 590px; top: 10px; width: 35px; height: 13px; color: white; position: absolute; z-index: 16; cursor: default;" for="listbox5" name="">Gender </label><select tabindex="9" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox5" style="left: 590px; top: 30px; width: 80px; height: 41px; position: absolute; z-index: 17;" spellcheck="false" size="3" multiple></select><label class="IBIfield IBI_ReportControlLabel" id="label7" style="left: 690px; top: 10px; width: 62px; height: 13px; color: white; position: absolute; z-index: 18; cursor: default;" for="listbox6" name="">Ethnic Code
</label><select tabindex="10" class="IBIfield IBI_ReportControlTarget IBI_rounded_s" id="listbox6" style="left: 690px; top: 30px; width: 80px; height: 41px; position: absolute; z-index: 19;" spellcheck="false" size="3" multiple>
</select><input tabindex="12" class="IBIfield IBI_button IBI_btn-run" id="button3" language="javascript" style="left: 790px; top: 30px; width: 38px; height: 22px; position: absolute; z-index: 23; background-color: white;" type="button" value=" " name="button3"><img name="image1" tabindex="13" id="image1" style="left: 10px; top: 10px; position: absolute; z-index: 26;" border="0"></span> <iframe title="REC009R-BY-ETHNICITY1.fex" class="IBIfield IBI_Report-iFrame IBI_rounded_m" id="graph3" frameborder="no" style="left: 40px; top: 780px; width: 450px; height: 350px; position: absolute; z-index: 24; background-color: transparent;" heightold="350" widthold="450" size_to_fit="1" name="graph3"></iframe><iframe title="REC009R-BY-ETHNICITY-FALL-ONLY.fex" class="IBIfield IBI_Report-iFrame IBI_rounded_m" id="graph4" frameborder="no" style="left: 580px; top: 780px; width: 450px; height: 350px; position: absolute; z-index: 25; background-color: transparent;" heightold="350" widthold="450" size_to_fit="1" name="graph4">
</iframe><img name="image2" tabindex="14" class="IBIfield" id="image2" style="left: 20px; top: 0px; position: absolute; z-index: 27;" border="0"><span class="IBIfield" id="text1" style="left: 40px; top: 1260px; width: 720px; height: 80px; position: absolute; z-index: 60;"><font style="font-family: Times New Roman; font-size: 12pt;">Department of Institutional Effectiveness & Research<br>Local Banner Data, Not Certified </font></span> 
</body><script type="text/javascript">
//confidential_id=IBI_loader
if(typeof doBeforeLoad === 'function'){doBeforeLoad();}function AdjustChildrenPosition(){
}
</script></html>
<!-- cc rfnnf -->
 


Specifically I would like College, Degree and Major chained so degree will filter based on college selection and major will filter based on Degree selection. There are 4 graphs on this html page that all have the same parameters.


WebFOCUS 8.1.05
Linux, All Outputs
 
Posts: 5 | Registered: July 20, 2015Report This Post
Virtuoso
posted Hide Post
So, you've got code for a graph made within the tool, and tool generated HTML that shows me you have College, Major, and Degree as selection or drop-down list boxes. What I do to populate my controls when needing to chain them using AppStudio is create each list for each control separately with it set to output both the return and display value pairs in XML. Each successive request including the previous level's parameter as a WHERE clause.

So, for example, if your first top-level list is College you don't need any WHERE clauses in that due to it being the top-level in the chain. The next one is Degree so for that request you would have a WHERE clause for College. Likewise, in Major you'd have 2 WHERE clauses for both College and Degree.

After you get your "external requests" created and test that they return what you are wanting, you can then add them in the Requests and Data Sources panel in the HTML Canvas tool of your HTML page. Then, they are available for you to tie to each of your drop-down list boxes. Which you simply click the control you want to tie a request to and under the Settings panel set it up with the correct return and display values from that request. After that, you use the Parameters tab near the bottom to drag each control in the chain to each successive control therein. Shouldn't be much more than that.

Go here for docs on what you are looking to do:
Chaining in the HTML Canvas


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Member
posted Hide Post
I've had issues trying to chain existing controls that already were linked to parameters before. I suggest starting by creating the controls and use the Parameters tab in App Studio to link them. Once you do that you can populate them and link them to parameters.

Is the data source you use to populate the controls the same for all the controls? From my experience chaining works best when the data source for all the controls you want to chain is the same.

If the data you need for the controls you want to chain comes from different tables, you should create a fex that joins those tables and has the data you want to use to populate the controls.

Once you created the fex, add it to the list of requests for the HTML page. From there, you can use it to populate the controls and pass the values as parameters.


Release 8.08
Windows Server 2008
Excel, HTML
 
Posts: 8 | Registered: April 06, 2016Report 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     [CLOSED]Chaining Help

Copyright © 1996-2020 Information Builders