quote:

Originally posted by Francis Mariani:
Common problem.

Here is a possible workaround: Procedure forgets its a fex

 -* File nps_field_tech_dashboard.fex
-* 
-* Summarize TNPS by Region and Date.
-*
TABLE FILE NPS_FIELD_TECH
SUM 
 LTR_COUNT/D12c
 LTR_PROMOTER_COUNT/D12c
 LTR_PASSIVE_COUNT/D12c
 LTR_DETRACTOR_COUNT/D12c
 TNPS/D12.2
BY C_REGION
BY PERIOD
ON TABLE HOLD AS FIELDTECH
END

-RUN
-*
-* Create Sales Report with Sparkline Trend.   
-*
DEFINE FILE FIELDTECH
 NPS_D/D12.2 = TNPS;
 NPS_A/A15  = FTOA(NPS_D,'(D12.2)','A15'); 
 SAMEROW_YN/A1  = IF LAST C_REGION EQ C_REGION THEN 'Y' ELSE 'N';
 NPS_OUT/A4096V = IF SAMEROW_YN EQ 'N' THEN NPS_A ELSE NPS_OUT || ',' || NPS_A;
END
-*
TABLE FILE FIELDTECH
SUM 
     FIELDTECH.FIELDTEC.LTR_PROMOTER_COUNT/I10c AS 'Promoter'
     FIELDTECH.FIELDTEC.LTR_PASSIVE_COUNT/I10c AS 'Passive'
     FIELDTECH.FIELDTEC.LTR_DETRACTOR_COUNT/I10c AS 'Detractor'
     COMPUTE NPS_SCORE1/D12.2c = ( ( LTR_PROMOTER_COUNT - LTR_DETRACTOR_COUNT ) / LTR_COUNT ) ; AS 'TNPS'
     COMPUTE SPARK2FLAME/A4096V = '<span class="inlinesparkline">' || NPS_OUT || '</span>'; AS 'Monthly TNPS'
BY  HIGHEST COMPUTE NPS_SCORE1/D12.2c = ( ( LTR_PROMOTER_COUNT - LTR_DETRACTOR_COUNT ) / LTR_COUNT ) ; NOPRINT
BY  FIELDTECH.FIELDTEC.C_REGION AS 'Region'
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET PAGE NOLEAD
ON TABLE COLUMN-TOTAL/I10C SUMMARIZE
ON TABLE HOLD AS HLDREPT FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENGreen_Light1.sty,
$
TYPE=DATA, COLUMN=C_REGION, JAVASCRIPT=drillto('nps_field_tech_graph' C_REGION C_REGION), $
TYPE=TITLE,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     COLOR='WHITE',
     BACKCOLOR=RGB(79 129 189),
$
ENDSTYLE
END
-RUN

-* Graph Begin
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+DQo8Um9vdCB2ZXJzaW9uPSIxLjAiPg0KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkNoYXJ0XzEiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICA8L09iamVjdD4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPmZhbHNlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj41MDA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZmllbGREaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+bGFiZWw8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkFjdGl2ZV9TdHlsZV9Vc2VyX3R5cGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnBvd2VyPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFZhbHVlc1BhZ2luZyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJGb2NleGVjUHJlZmVyZW5jZXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RWRpdE1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUhvbWVUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlRdWlja0FjY2Vzc1Rvb2xiYXJTYXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlSZXNvdXJjZXNGaWVsZFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUluc2VydFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJFZGl0SW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2VyaWVzVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJpbmZvQXNzaXN0TW9kZUFsbG93ZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXRfbGF5b3V0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jb21wb3NlX2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UERGPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnRlcmFjdGl2ZU1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlwZT0iTWFwIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCI+DQogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TlBTX0ZJRUxEX1RFQ0g8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0ibWV0YWRhdGFWaWV3QXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50
*-INTERNAL_COMMENT LINE#1$cnkga2V5PSJOUFNfU1VSVkVZIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Ik5QU19GSUVMRF9URUNIIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkNoYXJ0QXV0b2ZpdFNpemUiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj5mYWxzZTwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTbGljZXJHdWlJc2xhbmQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmV5SmlRWFYwYjFCeVpYWnBaWGNpT21aaGJITmxMQ0ppVDNCMGFXOXVjMGR5YjNWd1ZtbHphV0pzWlNJNmRISjFaU3dpWWxKbFkweHBiV2wwUjNKdmRYQldhWE5wWW14bElqcDBjblZsTENKaVVISmxkbWxsZDBOdmJuUnliMnhXYVhOcFlteGxJanAwY25WbExDSmlVblZ1ZEdsdFpVTnZiblJ5YjJ4V2FYTnBZbXhsSWpwMGNuVmxmUT09PC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNMSUNFUl9JTkZPUk1BVElPTiIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UEQ5NGJXd2dkbVZ5YzJsdmJqMGlNUzR3SWlCbGJtTnZaR2x1WnowaVZWUkdMVGdpSUhOMFlXNWtZV3h2Ym1VOUltNXZJajgrUENFdExVTlBUVkJNUlZSRlgxTk1TVU5GVWw5SFVrOVZVQzB0UGp4VFRFbERSVkpmUjFKUFZWQStQRWRTVDFWUUlHZHliM1Z3VG5WdFltVnlQU0l3SWlCemJHbGpaWEpIY205MWNFeGhZbVZzUFNKSGNtOTFjQ0F4SWlCemJHbGpaWEpIY205MWNFOXlaR1Z5UFNJd0lpQnpiR2xqWlhKSGNtOTFjRk5wZW1VOUlqQWlJSE5zYVdObGNrZHliM1Z3YUdsa1pUMGlabUZzYzJVaUx6NDhMMU5NU1VORlVsOUhVazlWVUQ0PTwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+DQogICAgPC9PYmplY3Q+DQo8L1Jvb3Q+DQo=
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
GRAPH FILE NPS_FIELD_TECH
-* Created by Info Assist for Graph
SUM NPS_FIELD_TECH.SEG01.LTR_DETRACTOR_COUNT AS '% of Detractor'
NPS_FIELD_TECH.SEG01.LTR_PASSIVE_COUNT AS '% of Passive'
NPS_FIELD_TECH.SEG01.LTR_PROMOTER_COUNT AS '% of Promoter'
BY NPS_FIELD_TECH.SEG01.PERIOD AS 'MONTHS'
ON GRAPH HOLD AS FIELDGRAPH FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET EMPTYREPORT ANSI
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 500.0
ON GRAPH SET VAXIS 400.0
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH HBRSTKPC
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='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setFillColor(getSeries(0),new Color(255,0,0));
setTextString(getO1Title(),"PERIOD");
setDisplay(getO1Title(),true);
setFillColor(getSeries(2),new Color(0,255,0));
setFillColor(getSeries(1),new Color(255,255,0));
setDataTextPosition(4);
setDisplay(getDataText(0), true);
setDisplay(getDataText(1), true);
setDisplay(getDataText(2), true);
setTextFormatPreset(getDataText(),30);
setLegendPosition(2);
*END
ENDSTYLE
END
-*IA_GRAPH_FINISH
-* Graph End


-*
-* Present the report page to the user.  
-*
-HTMLFORM BEGIN
<!DOCTYPE html>
<html>
-*
<head>
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
 <title>NPS Reporting</title>
 <style>
  .block_wrapper{
    width: 820px;
	}
  .innerblock {
    float: left;
    padding: 10px;   
 	}

 .div_style{    
    color:grey;
	margin-left : 25%;
	text-align:center; 	 
	font-size: 26px;
	width: 50%;
	text-decoration : underline;
	font-weight: bold;
	}

  #tabs, #tabs-1, #tabs-2{
  	height : 500px !important;
	}

  #tabs-1 iframe, #tabs-2 iframe{
  	border:none;
	}

  #tblMain table{
	margin-top:5px;
	margin-left:10px;
	}

  #dialog{ 
	overflow:hidden; 
	}

  td.color{
    box-shadow:inset 0 0 10px 0 #222;
    border: 1px solid #000;
    display: block;
	padding : 0px 0px 0px 0px !important;
	}

</style>
<link class="ui-theme" rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/cupertino/jquery-ui.css" />

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script type="text/javascript" src="http://omnipotent.net/jquery.sparkline/2.0/jquery.sparkline.js"></script>
<script>
   var GRV = $.noConflict(true);
   GRV(function() {
   GRV.fn.sparkline.defaults.common.width  = '100px';
   GRV.fn.sparkline.defaults.common.height = '020px';
   GRV('.inlinesparkline').sparkline('html',{spotColor: '#e5e5e5',minSpotColor: '#ff0000',maxSpotColor: '#2cd323'});   });
 </script>

<!-- Within WF8, these JS and CSS Libraries are installed as standard -->
<script src="/ibi_apps/ibi_html/javaassist/jquery/jquery_min.js"></script>
<script src="/ibi_apps/jquery/jquery-ui.min.js" type="text/javascript"></script>
<!--
      This is thejQuery that is executed on drildown click
      All it does is to remove the drilldown div (in case it already exists)
      and then create an outer div containing 3 inner divs, 2 for the heading
      and 1 for the drill down report content.
      The 2 heading divs contain the title plus the image for closing the pop-up.
-->

<script type="text/javascript">
$(document).ready(function(){
	  $("#tabs").hide();
});

function drillto(fex, c_region, title) {

// Now set attributes on the drill down div to define it as a modal dialog
 $("#divdrill").dialog( {
         autoOpen      : false
        ,closeOnEscape : true       
        ,width         : 800
        ,height        : 650
        ,position      : ""
        ,show          : {effect: "fold", duration: 1000}
        ,hide          : {effect: "fold", duration: 1000}
        ,stack         : true
        ,modal         : true
    });
$( "#tabs" ).tabs({      
		event: "click"
		    });
// Build the URL required to execute the drill down report
  
  var _iframeurl = "http://wfprod.corp.intranet/ibi_apps/WFServlet?IBIF_ex=ops_and_reg/"+fex+".fex&|C_REGION="+c_region;
  var _iframeurl1 = "http://wfprod.corp.intranet/ibi_apps/WFServlet?IBIF_ex=ops_and_reg/nps_field_tech_tab.fex&|C_REGION="+c_region;

  var _url  = "";
      _url += "<iframe style='width:99%; height:80%;'  src='"+_iframeurl+"'>";
      _url += "</iframe>";
  var _url1  = "";
      _url1 += "<iframe style='width:99%; height:80%;' src='"+_iframeurl1+"'>";
      _url1 += "</iframe>";
      $("#tabs-1").html(_url);
	  $("#tabs-2").html(_url1);
	  $("#tabs").show();
      $("#divdrill").dialog("open", "");
      $("#divdrill").dialog("option", "title", title);
}

// Remove the div collection
</script>


</head>
-*
<body>
<div class="div_style" align="center">
  <p> NPS Field Tech Results </p>
</div>
<div id='divdrill'>
  <div id="tabs">  
     <ul>    
		<li><a href="#tabs-1">Field Tech Monthly Graph</a></li>    
		<li><a href="#tabs-2">Field Tech Monthly Details</a></li>    
	</ul>    
  	<div id="tabs-1">    
  		
     </div>  
  
  	<div id="tabs-2">    
  		
    </div>  
  </div>
</div>
 <table width="100%"><tr width="94%">
 <td width="3%"></td>
<td class="color" width = "44%" height = "500px" style="background-color:#ccffcc;width:46%" align="center" >   
   <p width="100%" style="text-align:center; color: white; font-size: 24px; background-color: green; margin-top: 0px; padding-top:1px; padding-bottom:1px;"><b><u>Regional TNPS</b></u></p>

       !IBI.FIL.HLDREPT;

  </td>
 <td width="3%"></td>
 <td class="color" width = "44%" height = "500px" style="background-color:#ccffcc;" align="center">   
   <p width="100%"  style="text-align:center; color: white; font-size: 24px; background-color: green; margin-top: 0px;"><b><u>Bucket Analysis</b></u></p>
	   !IBI.FIL.FIELDGRAPH;
 </td>
 <td width="6%"></td>
  </tr>
  </table>
</body>
</html>
-HTMLFORM END