Level 1 Level 2 Level 3 Level 4 NONE NONE NONE NONE CAR CAR CAR CAR COUNTRY COUNTRY COUNTRY COUNTRY MODEL MODEL MODEL MODEL
Level 1 Level 2 Level 3 Level 4 NONE NONE NONE NONE CAR COUNTRY MODEL COUNTRY MODEL MODEL
SET ASNAMES = ON SET EXPANDBYROW=ON -PROMPT &SORT1.(ALL,CAR,COUNTRY,MODEL,BODYTYPE).First Sort. -PROMPT &SORT2.(ALL,CAR,COUNTRY,MODEL,BODYTYPE).Second Sort. -PROMPT &SORT3.(ALL,CAR,COUNTRY,MODEL,BODYTYPE).Third Sort. -PROMPT &SORT4.(ALL,CAR,COUNTRY,MODEL,BODYTYPE).Fourth Sort. -SET &SORT1 = IF &SORT1 EQ 'ALL' THEN '_FOC_NULL' ELSE &SORT1 ; -SET &SORT2 = IF &SORT2 EQ 'ALL' THEN '_FOC_NULL' ELSE &SORT2 ; -SET &SORT3 = IF &SORT3 EQ 'ALL' THEN '_FOC_NULL' ELSE &SORT3 ; -SET &SORT4 = IF &SORT4 EQ 'ALL' THEN '_FOC_NULL' ELSE &SORT4 ; -SET &BYSORT1= IF &SORT1 EQ ' ' THEN ' ' ELSE 'BY ' | &SORT1; -SET &BYSORT2= IF &SORT2 EQ ' ' THEN ' ' ELSE 'BY ' | &SORT2; -SET &BYSORT3= IF &SORT3 EQ ' ' THEN ' ' ELSE 'BY ' | &SORT3; -SET &BYSORT4= IF &SORT4 EQ ' ' THEN ' ' ELSE 'BY ' | &SORT4; TABLE FILE CAR SUM SALES &BYSORT1 &BYSORT2 &BYSORT3 &BYSORT4 ON TABLE NOTOTAL END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
DEFINE FILE IBISAMP/CAR LEVEL/A10=DECODE COUNTRY ('ENGLAND' 'NONE' 'JAPAN' 'CAR' 'ITALY' 'COUNTRY' ELSE 'MODEL'); LEVELORDER/I1=DECODE LEVEL ('NONE' 1 'CAR' 2 'COUNTRY' 3 ELSE 4); END TABLE FILE IBISAMP/CAR SUM LEVEL BY LEVELORDER NOPRINT ON TABLE PCHOLD END
FILEDEF myfile DISK myfile.mas -RUN -WRITE myfile FILENAME=myfile, SUFFIX=FIX , $ -WRITE myfile SEGMENT=myfile, SEGTYPE=S0, $ -WRITE myfile FIELDNAME=LEVEL, ALIAS=LEVEL, USAGE=A8, ACTUAL=A8, $ -CLOSE myfile FILEDEF myfile DISK myfile.TXT -RUN -WRITE myfile NONE -WRITE myfile CAR -WRITE myfile COUNTRY -WRITE myfile MODEL -CLOSE myfile -RUN TABLE FILE myfile PRINT LEVEL ON TABLE PCHOLD END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
<!-- Generated by Report Layout Painter --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type> <META id=Generation content="Created in release 7703, Generation 3.0"> <SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){ } </SCRIPT> <SCRIPT id=IBI_OptionsScript type=text/javascript> var cgipath = "cgipath"; var ibirls = "ibirls3"; var rltdyncalendar = "rltdyncalendar"; var gmap = "ibigmap"; var olap="olap"; var olappanebase="olappanebase"; var olapdrill="olapdrill"; var ibixmltree="ibixmltree"; var ibiOptions = new Array(cgipath,ibirls); </SCRIPT> <SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT> <SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT> <SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT> <SCRIPT id=IBI_ibigblloadCss type=text/javascript> ibigblloadCss(null); addIntlTranslatedJS("composertrans.js"); </SCRIPT> <TITLE>HtmlPage</TITLE> <SCRIPT id=clientEventHandlersJS type=text/javascript> //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 </SCRIPT> <SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT> </HEAD> <BODY style="OVERFLOW: auto" nextelementuniquenumber="3" thumbnailscale="4" elementtype="21" edaconnectionrequired="true"> <FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 810px; HEIGHT: 440px; TOP: 10px; LEFT: 10px" id=form1 onsubmit="OnExecute(this);return false;" method=post requests_list="0" form_newline_chain="1" default_slider_type="4" form_type="1" form_prompt_location="1" form_number_of_visible_rows="4" form_number_of_columns="4" vert_dist_between_controls="10" form_hor_dist_between_controls="10" form_dist_between_desc_and_input="10" name="form1"> <FORM style="Z-INDEX: 5; POSITION: absolute; WIDTH: 697px; HEIGHT: 120px; TOP: 13px; LEFT: 15px" id=form2 form_newline_chain="1" default_slider_type="4" form_type="1" form_prompt_location="1" form_number_of_visible_rows="4" form_number_of_columns="4" vert_dist_between_controls="10" form_hor_dist_between_controls="10" form_dist_between_desc_and_input="10" name="form2" tempheight="120" tempwidth="697" fexlist_list="form1Submit" method="post"> <LABEL style="Z-INDEX: 8; POSITION: absolute; WIDTH: 212px; HEIGHT: 22px; TOP: 5px; CURSOR: default; LEFT: 5px" id=label1 tabIndex=6 for=combobox1 name="combobox1">Please select sort field(s)</LABEL> <SELECT style="Z-INDEX: 9; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 131px; OVERFLOW: visible; TOP: 37px; LEFT: 5px" id=combobox1 tabIndex=7 size=1 defaultselection="1" defaultlocation="0,0,25,111" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_1" name="combobox1"> <OPTION selected value=CAR.ORIGIN.COUNTRY noinput="0" displaytext="COUNTRY">COUNTRY</OPTION> <OPTION value=CAR.COMP.CAR noinput="0" displaytext="CAR">CAR</OPTION> <OPTION value=CAR.CARREC.MODEL noinput="0" displaytext="MODEL">MODEL</OPTION> <OPTION value=_FOC_NULL noinput="0" displaytext="None">None</OPTION></SELECT> <LABEL style="Z-INDEX: 10; POSITION: absolute; WIDTH: 212px; HEIGHT: 22px; TOP: 5px; CURSOR: default; LEFT: 227px" id=label2 tabIndex=8 for=combobox2 name="combobox2">Please select sort field(s)</LABEL> <SELECT style="Z-INDEX: 11; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 131px; OVERFLOW: visible; TOP: 37px; LEFT: 227px" id=combobox2 tabIndex=9 size=1 defaultselection="1" defaultlocation="0,0,25,111" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_2" name="combobox2"></SELECT> <LABEL style="Z-INDEX: 12; POSITION: absolute; WIDTH: 212px; HEIGHT: 22px; TOP: 5px; CURSOR: default; LEFT: 449px" id=label3 tabIndex=10 for=combobox3 name="combobox3">Please select sort field(s)</LABEL> <SELECT style="Z-INDEX: 13; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 131px; OVERFLOW: visible; TOP: 37px; LEFT: 449px" id=combobox3 tabIndex=11 size=1 defaultselection="1" defaultlocation="0,0,25,111" boundtovariable="1" requiredfield="1" persistentuniqueid="compUid_3" tempatt_lastelement_ofline="1" name="combobox3"></SELECT> <INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/reset.gif); Z-INDEX: 6; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 97px; LEFT: 95px" id=form2Reset tabIndex=4 value=" " type=reset StyleBack_UserSuppliedFullPath="1" name="reset2"> <INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/run16.gif); Z-INDEX: 3; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 38px; BACKGROUND-REPEAT: no-repeat; HEIGHT: 22px; TOP: 90px; LEFT: 14px" id=form1Submit tabIndex=2 value=" " type=submit StyleBack_UserSuppliedFullPath="1" autoExecute="false" name="submit1"></FORM></FORM> <INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden resourcectrlids="form2Reset;form1Submit"> <INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=baseapp type=hidden name="ibiapp_app"> <INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server"> <xml id=focus_xmlelement> <script type="text/xml" nextelementuniquenumber="4"> <rootxmlnode focoption="_FOC_NULL" top="100" left="10" width="150" height="130"> <variables> <variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="Please select sort field(s)" name="RP_FL01B01_Sort1" default="" textvarname="" accept="0" select="0" create="1" top="70" left="30" width="60" height="20" inbinding="1"> <link linktype="default" from="compUid_1"> <condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" displayfield="RP_FL01B01_Sort1" datafield="RP_FL01B01_Sort1" datasource="car.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="CAR.ORIGIN.COUNTRY" sourcetype="typeMaster"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link> <requestid id="0"></requestid></variable> <variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="Please select sort field(s)" name="RP_FL02B02_Sort2" default="" textvarname="" accept="0" select="0" create="1" top="70" left="140" width="60" height="20" inbinding="1"> <link linktype="default" from="compUid_2"> <condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" displayfield="RP_FL02B02_Sort2" datafield="RP_FL02B02_Sort2" datasource="car.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="CAR.ORIGIN.COUNTRY" sourcetype="typeMaster"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link> <requestid id="0"></requestid></variable> <variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="Please select sort field(s)" name="RP_FL03B03_Sort3" default="" textvarname="" accept="0" select="0" create="1" top="70" left="250" width="60" height="20" inbinding="1"> <link linktype="default" from="compUid_3"> <condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" displayfield="RP_FL03B03_Sort3" datafield="RP_FL03B03_Sort3" datasource="car.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="CAR.ORIGIN.COUNTRY" sourcetype="typeMaster"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link> <requestid id="0"></requestid></variable></variables> <input_controls> <input_control bindcontrolid="compUid_1" elementtype="8" name="combobox1" id="combobox1" multiple="0" inbinding="1" top="20" left="30" width="60" height="20" onetimepopulated="1"> <link linktype="default" persistentuniqueid="compUid_1"> <condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" datatype="0" datasource="car.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control> <input_control bindcontrolid="compUid_2" elementtype="8" name="combobox2" id="combobox2" multiple="0" top="20" left="140" width="60" height="20" inbinding="1" onetimepopulated="0"> <link linktype="default" from="compUid_1" persistentuniqueid="compUid_3"> <condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" datatype="0" datasource="car.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control> <input_control bindcontrolid="compUid_3" elementtype="8" name="combobox3" id="combobox3" multiple="0" top="20" left="250" width="60" height="20" inbinding="1" onetimepopulated="0"> <link linktype="default" from="compUid_2" persistentuniqueid="compUid_2"> <condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"> <data_info checkForDuplicateValues="0" datatype="0" datasource="car.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"> <static_values> <static value="CAR.ORIGIN.COUNTRY" display="COUNTRY" selected="1" noinput="0"></static> <static value="CAR.COMP.CAR" display="CAR" selected="0" noinput="0"></static> <static value="CAR.CARREC.MODEL" display="MODEL" selected="0" noinput="0"></static> <static value="_FOC_NULL" display="None" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control></input_controls> <other_bound_objects></other_bound_objects> <requests nextrequestsid="1"> <request requestid="0" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="fpsxschech1.fex" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="baseapp"></request></requests></rootxmlnode></script> </xml></BODY> <SCRIPT id=IBI_loader type=text/javascript> doBeforeLoad(); </SCRIPT> </HTML>
-* File fpsxschech1.fex -SET &ECHO='ALL'; TABLE FILE CAR SUM CAR.BODY.SEATS BY LOWEST &RP_FL01B01_Sort1.(<COUNTRY,CAR.ORIGIN.COUNTRY>,<CAR,CAR.COMP.CAR>,<MODEL,CAR.CARREC.MODEL>,<None,_FOC_NULL>).Please select sort field(s). BY LOWEST &RP_FL02B02_Sort2.(<COUNTRY,CAR.ORIGIN.COUNTRY>,<CAR,CAR.COMP.CAR>,<MODEL,CAR.CARREC.MODEL>,<None,_FOC_NULL>).Please select sort field(s). BY LOWEST &RP_FL03B03_Sort3.(<COUNTRY,CAR.ORIGIN.COUNTRY>,<CAR,CAR.COMP.CAR>,<MODEL,CAR.CARREC.MODEL>,<None,_FOC_NULL>).Please select sort field(s). ON TABLE SET ONFIELD IGNORE ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END
-* File sxschech_combo.fex -SET &ECHO = ALL; -DEFAULT &Level1 = 'FOC_NONE' -DEFAULT &Level2 = 'FOC_NONE' -DEFAULT &Level3 = 'FOC_NONE' FILEDEF myfilemas DISK myfile.mas FILEDEF myfile DISK myfile.TXT -RUN -WRITE myfilemas FILENAME=myfile, SUFFIX=FIX , $ -WRITE myfilemas SEGMENT=myfile, SEGTYPE=S0, $ -WRITE myfilemas FIELDNAME=LEVEL, ALIAS=LEVEL, USAGE=A8, ACTUAL=A8, $ -WRITE myfile NONE -WRITE myfile CAR -WRITE myfile COUNTRY -WRITE myfile MODEL -RUN TABLEF FILE myfile SUM FST.LEVEL BY LEVEL WHERE LEVEL NE '&Level1' WHERE LEVEL NE '&Level2' WHERE LEVEL NE '&Level3' ON TABLE PCHOLD FORMAT XML END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:I'm not going to teach you how to do the rest
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:WHERE LEVEL NE '&Sort1' OR LEVEL EQ 'NONE'
WHERE LEVEL NE '&Sort2' OR LEVEL EQ 'NONE'
WHERE LEVEL NE '&Sort3' OR LEVEL EQ 'NONE'
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |