Focal Point
{Solved}(FOC261)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8967095656

January 03, 2014, 06:14 AM
GV
{Solved}(FOC261)
Hi,
I am having an error:
0 ERROR AT OR NEAR LINE 32 IN PROCEDURE _international_ton
(FOC261) EXPRESSION IS INCOMPLETE BECAUSE AN OPERATION IS MISSING

Can anyone assist me to solve the error.


 SET BYDISPLAY=ON
-SET &TODAY = &YYMD;
-SET &YR = EDIT(&TODAY,'9999$$$$$$$$');
-SET &WEEK = HPART(HDTTM(DATECVT(&TODAY, I8YYMD, YYMD), 8, 'HYYMDs'), 'WEEK', 'I2');
-SET &WEEK_OF_YEAR=&WEEK+1;
-SET &WEEK=&WEEK_OF_YEAR;
-SET &WEEKSTART_DT=DATECVT(DATEADD(DATEMOV(DATECVT(&TODAY, 'I8YYMD','YYMD'), 'BOW'), 'D', -1), 'YYMD', 'A8YYMD');
-SET &WEEKEND_DT=DATECVT(DATEADD(DATEMOV(DATECVT(&TODAY, 'I8YYMD','YYMD'), 'EOW'), 'D', 1), 'YYMD', 'A8YYMD');
-SET &START_DATE =  EDIT(&WEEKSTART_DT,'$$$$99$$')|| '/' ||EDIT(&WEEKSTART_DT,'$$$$$$99')|| '/' || EDIT(&WEEKSTART_DT,'9999$$$$$$');
-SET &END_DATE =  EDIT(&WEEKEND_DT,'$$$$99$$')|| '/' ||EDIT(&WEEKEND_DT,'$$$$$$99')|| '/' || EDIT(&WEEKEND_DT,'9999$$$$$$');
-DEFAULT &GRPBY = 'origin';
-DEFAULT &RCASTER = 'NO';
-SET &GRPBYTEXT = IF &GRPBY EQ 'origin' THEN 'Origin Country / City'
-	ELSE IF &GRPBY EQ 'destination' THEN 'Destination Country / City' ELSE 'Origin' ;
-DEFAULT &RPT = 'ALL';
-SET &HOLDFILE = 'ORIGINDESTAGENTRPT';
-SET &RPTNAME = 'Air Export to Destination from Origin Agents';
-SET &REPORTEXT = '.XLS';
-DEFAULT &EMAILID = '';
-SET &HLDFMT = IF &EMAILID = '' THEN 'PCHOLD FORMAT ' ELSE 'HOLD AS &HOLDFILE.EVAL FORMAT ';
-DEFAULT &OUTPUT = 'EXL2K';
-MRNOEDIT -INCLUDE shared/INCCOMDT
-RUN
-SET &PARAMS1='Source Create Date';
-SET &PARAMS2='Start Date: ' | &START_DATE | 'End Date: ' | &END_DATE;
-SET &PARAMS3='Report(s): '  | &RPT;
-SET &SQLPARAMS=&PARAMS1 |&PARAMS3;
-IF &RCASTER EQ 'YES' THEN GOTO NOEMAIL;
-MRNOEDIT -INCLUDE shared/startsql
-RUN
-MRNOEDIT -INCLUDE EMAIL1
-RUN
-NOEMAIL
ENGINE SQLORA SET DEFAULT_CONNECTION DMPROD0
SQL SQLORA PREPARE SQLOUT FOR
SELECT
     hb.origin origin,
	 hb.destination destination,
	 count(hb.hwb_number) HAWBs,
	 count(mb.mwb_number) MAWBs,
	 sum(hb.actual_weight_kg) ACTUAL_WEIGHT,
      sum(hb.chargeable_weight_kg) CHARGE_WT
from gsu_air_hwb hb left outer join gsu_air_mwb mb
ON  mb.ods_mwb_system_id= hb.export_mwb_ods_system_id
WHERE mb.source_create_dt >= to_date('&START_DATE', 'mm,dd,yyyy')
AND mb.source_create_dt <= to_date('&END_DATE', 'mm,dd,yyyy')
AND mb.system_record= 'Y'
-IF &origin EQ 'FOC_NONE' THEN GOTO NOORIGIN1
AND hb.origin= '&ORIGIN'
-NOORIGIN1
-IF &destination EQ 'FOC_NONE' THEN GOTO NODEST1
AND hb.destination= '&DESTINATION'
-NODEST1
-IF &COUNTRY EQ 'FOC_NONE' THEN GOTO NOCNTRY1;
AND G.COUNTRY_CODE = '&COUNTRY'
-NOCNTRY1
GROUP BY hb.origin, hb.destination
END
-RUN
TABLE FILE SQLOUT
PRINT *
END
ON TABLE HOLD AS SQLTABLE
END
TABLE FILE SQLTABLE
ACROSS WEEK AS ' '
ON TABLE SUBHEAD
"Air Agent Activity by &GRPBYTEXT"
"Period <+0>&START_DATE <+0> through <+0>&END_DATE"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
-IF &RCASTER EQ 'NO' THEN GOTO NOTRCASTER2;
ON TABLE PCHOLD FORMAT EXL2K
-NOTRCASTER2
ON TABLE &HLDFMT &OUTPUT
ON TABLE SET STYLE *
SQUEEZE=ON,
GRID=OFF,
ORIENTATION=PORTRAIT, $
TYPE=REPORT, FOCEXEC=NONE, FONT=ARIAL, SIZE=8, COLOR=BLACK, BACKCOLOR=NONE, STYLE=NORMAL, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=12, STYLE=BOLD, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, SIZE=12, STYLE=BOLD, $
TYPE=HEADING, LINE=3, STYLE=BOLD, SIZE=11, $
TYPE=HEADING, LINE=4, SIZE=9, $
TYPE=SUBHEAD, LINE=2, STYLE=BOLD+ITALIC, SIZE=10, $
TYPE=TITLE, STYLE=BOLD, SIZE=10, $
TYPE=FOOTING, OBJECT=TEXT, ITEM=1, STYLE=BOLD, $
TYPE=SUBTOTAL, STYLE=BOLD+ITALIC, $
TYPE=GRANDTOTAL, STYLE=BOLD+ITALIC,  $
ENDSTYLE
END
-IF &RCASTER EQ 'YES' GOTO NOEMAIL2;
-MRNOEDIT -INCLUDE endsqlst
-************************************************
-MRNOEDIT -INCLUDE endrepor
-RUN
-*************************************
-MRNOEDIT -INCLUDE UNIXMAL3
-RUN
-NOEMAIL2
-************************************************
END
 

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


7.6.4
January 03, 2014, 07:45 AM
Dave
-SET &HLDFMT = IF &EMAILID = '' THEN 'PCHOLD FORMAT ' ELSE 'HOLD AS &HOLDFILE.EVAL FORMAT ';

I guess it's this...

should me EQ instead of =

G'luck


_____________________
WF: 8.0.0.9 > going 8.2.0.5
January 10, 2014, 03:10 AM
GV
Thanks Dave to reply.
I have try as you said but it is not working.
I found the issue is coming from HTML page I created for the fex file. I think request parameters is not going to the fex file. I tried after removing the variables from the request tag and passed values manually then I clicked on the button then the roport is coming. Is there any other way to pass the parameters or I am doing anything wrong. please correct me.
Here is my HTML code.
 <!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage</TITLE>
<BASE href="HTTP://fmnowdev.eaglegl.com:80">
<META id=UTF-8 content="text/html; charset=UTF-8" http-equiv=Content-Type>
<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

//Begin function button1_OnClick
function button1_OnClick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)

}
//End function button1_OnClick

//Begin function combobox8_onchange
function combobox8_onchange(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function combobox8_onchange
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META name=GENERATOR content="MSHTML 9.00.8112.16496"></HEAD>
<BODY style="OVERFLOW: auto"  requests_list="0" edaconnectionrequired="true"  autoExecute="True">
<INPUT style="Z-INDEX: 1; POSITION: absolute; BACKGROUND-COLOR: maroon; WIDTH: 100px; HEIGHT: 30px; COLOR: white; TOP: 278px; LEFT: 20px" id=button1 language=javascript tabIndex=1 onclick=button1_OnClick(this) name=button1 value="Run Air Report" size=24 type=button requests_list="0" >       
<SPAN style="Z-INDEX: 6; POSITION: absolute; WIDTH: 470px; HEIGHT: 30px; COLOR: maroon; FONT-SIZE: 18pt; FONT-WEIGHT: bold; TOP: 10px; LEFT: 15px" id=text3 tabIndex=6>Air Export Origin to Destination Agents</SPAN> 
<SPAN style="Z-INDEX: 7; POSITION: absolute; WIDTH: 80px; HEIGHT: 20px; COLOR: maroon; TOP: 60px; LEFT: 230px" id=text4 tabIndex=7>Destination</SPAN> 
<SELECT style="Z-INDEX: 8; POSITION: absolute; WIDTH: 90px; TOP: 80px; LEFT: 230px" id=combobox3 tabIndex=8 size=1 name=DESTINATION dfformat="A65V" ibiformat="A65V" datafield="GSU_AIR_HWB.GSU_AIR_HWB.DESTINATION" ibic_server="EDASERVE" chainnumber="0" inchainindex="2" cacheruntimedata="1" newchainnumber="0" displayfield="DESTINATION" ibiapp_app="#" sourcetype="typeMaster" datatype="1" requiredfield="1505682" boundtovariable="1" datasource="GSU_AIR_HWB.mas" selectedvalue="FOC_NONE" operation="NONE" accept="0" addalloption="1" labelid="text4" dynalldisplayvalue="ALL"></SELECT> 
<SPAN style="Z-INDEX: 10; POSITION: absolute; WIDTH: 135px; HEIGHT: 39px; COLOR: maroon; TOP: 175px; LEFT: 20px" id=radio1 title="" tabIndex=10 contentEditable=false displayfield sourcetype="typeMaster" datatype="0" requiredfield="1505682" boundtovariable="1" datasource selectedvalue=" " operation="NONE" accept="0" addalloption="0" labelid="text5" name="IBIMR_defer" columns="1">
<TABLE style="WIDTH: 100%; HEIGHT: 100%; COLOR: maroon" contentEditable=false cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD>
<INPUT id=radio1_0 name=IBIMR_defer value=Defer CHECKED type=radio displaytext="Send To Email"> 
<LABEL style="CURSOR: default" tabIndex=10 for=radio1_0>Send To Email</LABEL></TD></TR>
<TR>
<TD>
<INPUT id=radio1_1 name=IBIMR_defer value=Value2 type=radio displaytext="Immediate"> 
<LABEL style="CURSOR: default" tabIndex=10 for=radio1_1>Immediate</LABEL></TD></TR></TBODY></TABLE></SPAN>
<SPAN style="Z-INDEX: 11; POSITION: absolute; WIDTH: 335px; HEIGHT: 19px; COLOR: maroon; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TOP: 225px; LEFT: 25px" id=text6 tabIndex=11>Email Address where report will be sent </SPAN>
<INPUT style="Z-INDEX: 12; POSITION: absolute; WIDTH: 290px; HEIGHT: 22px; TOP: 245px; LEFT: 25px" id=edit1 tabIndex=12 name=EMAILID hspace=0 maxLength=5 accept=0 size=5 displayfield sourcetype="typeFex" datatype="1" requiredfield="1505682" boundtovariable="1" datasource="app/t23n5unl.fex" selectedvalue=" " operation="NONE" addalloption="0" labelid="text6" rawvalue="troy.proffitt@cevalogistics.com" IBIMR_folder="#leanb2448r0k" IBIMR_domain="yy4c72he/yy4c72he.htm">   
<SPAN style="Z-INDEX: 15; POSITION: absolute; WIDTH: 82px; HEIGHT: 19px; COLOR: maroon; TOP: 60px; LEFT: 20px" id=text7 tabIndex=15>Dest Country</SPAN> 
<SELECT style="Z-INDEX: 16; POSITION: absolute; WIDTH: 185px; TOP: 80px; LEFT: 20px" id=combobox5 tabIndex=16 size=1 name=COUNTRY dfformat="A65V" ibiformat="A65V" datafield="GSU_AIR_HWB.GSU_AIR_HWB.DESTINATION_COUNTRY" ibic_server="EDASERVE" chainnumber="0" inchainindex="1" cacheruntimedata="1" newchainnumber="0" displayfield="DESTINATION_COUNTRY" ibiapp_app="#" sourcetype="typeMaster" datatype="1" requiredfield="1508186" boundtovariable="1" datasource="GSU_AIR_HWB.mas" selectedvalue="FOC_NONE" operation="NONE" accept="0" addalloption="1" labelid="text7" dynalldisplayvalue="ALL"></SELECT>        
<SPAN style="Z-INDEX: 30; POSITION: absolute; WIDTH: 130px; HEIGHT: 20px; COLOR: maroon; TOP: 120px; LEFT: 20px" id=text2 tabIndex=31>Origin Country</SPAN> 
<SPAN style="Z-INDEX: 31; POSITION: absolute; WIDTH: 90px; HEIGHT: 20px; COLOR: maroon; TOP: 120px; LEFT: 230px" id=text8 tabIndex=31>Origin </SPAN>   
<SELECT style="Z-INDEX: 34; POSITION: absolute; WIDTH: 180px; TOP: 140px; LEFT: 20px" id=combobox2 tabIndex=34 name="ORIGIN COUNTRY" dfformat="A65" ibiformat="A65V" datafield="GSU_AIR_HWB.GSU_AIR_HWB.ORIGIN_COUNTRY" ibic_server="EDASERVE" chainnumber="1" inchainindex="1" cacheruntimedata="1" newchainnumber="1" displayfield="ORIGIN_COUNTRY" ibiapp_app="#" sourcetype="typeMaster" datatype="1" boundtovariable="1" datasource="GSU_AIR_HWB.mas" selectedvalue="FOC_NONE" operation="NONE" accept="0" addalloption="1" dynalldisplayvalue="ALL"></SELECT> 
<SELECT style="Z-INDEX: 36; POSITION: absolute; WIDTH: 90px; TOP: 140px; LEFT: 230px" id=combobox6 tabIndex=36 name=ORIGIN dfformat="A65" ibiformat="A65V" datafield="GSU_AIR_HWB.GSU_AIR_HWB.ORIGIN" ibic_server="EDASERVE" chainnumber="1" inchainindex="2" cacheruntimedata="1" newchainnumber="1" displayfield="ORIGIN" ibiapp_app="#" sourcetype="typeMaster" datatype="1" boundtovariable="1" datasource="GSU_AIR_HWB.mas" selectedvalue="FOC_NONE" operation="NONE" accept="0" addalloption="1" dynalldisplayvalue="ALL"></SELECT>         
<INPUT style="Z-INDEX: 37; POSITION: absolute; WIDTH: 110px; HEIGHT: 20px; TOP: 80px; LEFT: 410px" id=calendar1 disabled tabIndex=37 name=START_DATE maxLength=8 value=01/05/2014 size=8 ibiformat="MDYY" calendardatatype="1" calendardata="0/0/-10;0/0/10" elementtype="14"> 
<INPUT style="Z-INDEX: 38; POSITION: absolute; WIDTH: 100px; HEIGHT: 20px; TOP: 80px; LEFT: 570px" id=calendar2 disabled tabIndex=38 name=END_DATE maxLength=8 value=01/11/2014 size=8 ibiformat="MDYY" calendardatatype="1" calendardata="0/0/-10;0/0/10" elementtype="14"> 
<SPAN style="Z-INDEX: 39; POSITION: absolute; WIDTH: 70px; HEIGHT: 19px; COLOR: maroon; TOP: 60px; LEFT: 410px" id=text1 tabIndex=39>Start Date</SPAN> 
<SPAN style="Z-INDEX: 40; POSITION: absolute; WIDTH: 70px; HEIGHT: 20px; COLOR: maroon; TOP: 60px; LEFT: 570px" id=text5 tabIndex=40>End Date</SPAN> 
<xml id=ibi_requests>
<script>
	
<requests>
		
<request requestid="0" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="app/international_tonnage_by_carrier_by_origin.fex" IBIMR_domain="yy4c72he/yy4c72he.htm" IBIMR_folder="#leanb2448r0k" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" ibiapp_app="">
			
<variables>
				
<variable parametercreatedinreslay="0" displayfield="START_DATE" format="" field="START_DATE" file="sqlout.mas" desc="START_DATE" datatype="0" operation="" default="04/01/2012" name="START_DATE" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="0"></variable>
				
<variable parametercreatedinreslay="0" displayfield="END_DATE" format="" field="END_DATE" file="sqlout.mas" desc="END_DATE" datatype="0" operation="" default="04/30/2012" name="END_DATE" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="0"></variable>
				
<variable parametercreatedinreslay="0" displayfield="COUNTRY" format="" field="COUNTRY" file="sqlout.mas" desc="COUNTRY" datatype="0" operation="" default="FOC_NONE" name="COUNTRY" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="DESTINATION" format="" field="DESTINATION" file="sqlout.mas" desc="DESTINATION" datatype="0" operation="" default="FOC_NONE" name="DESTINATION" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="ORIGIN COUNTRY" format="" field="ORIGIN COUNTRY" file="sqlout.mas" desc="ORIGIN COUNTRY" datatype="0" operation="" default="FOC_NONE" name="ORIGIN COUNTRY" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="ORIGIN" format="" field="ORIGIN" file="sqlout.mas" desc="ORIGIN" datatype="0" operation="" default="FOC_NONE" name="ORIGIN" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
			</variables>
		</request>
	</requests>
</script>
</xml></BODY></HTML>

 


and here is fex file
  SET BYDISPLAY=ON
-SET &TODAY = &YYMD;
-SET &WEEK = HPART(HDTTM(DATECVT(&TODAY, I8YYMD, YYMD), 8, 'HYYMDs'), 'WEEK', 'I2');
-SET &WEEK_OF_YEAR=&WEEK+1;
-SET &WEEK=&WEEK_OF_YEAR;
-SET &WEEKSTART_DT=DATECVT(DATEADD(DATEMOV(DATECVT(&START_DATE, 'I8YYMD','YYMD'), 'BOW'), 'D', -1), 'YYMD', 'A8YYMD');
-SET &WEEKEND_DT=DATECVT(DATEADD(DATEMOV(DATECVT(&END_DATE, 'I8YYMD','YYMD'), 'EOW'), 'D', 1), 'YYMD', 'A8YYMD');
-SET &START_DATE =  EDIT(&WEEKSTART_DT,'$$$$99$$')|| '/' ||EDIT(&WEEKSTART_DT,'$$$$$$99')|| '/' || EDIT(&WEEKSTART_DT,'9999$$$$$$');
-SET &END_DATE =  EDIT(&WEEKEND_DT,'$$$$99$$')|| '/' ||EDIT(&WEEKEND_DT,'$$$$$$99')|| '/' || EDIT(&WEEKEND_DT,'9999$$$$$$');
-MRNOEDIT -INCLUDE shared/INCCOMDT
-RUN
-DEFAULT &GRPBY = 'ORIGIN';
-DEFAULT &RCASTER = 'NO';
-SET &GRPBYTEXT = IF &GRPBY EQ 'ORIGIN' THEN 'Origin' ELSE 'Origin Country / City';
-DEFAULT &RPT = 'ALL';
-SET &HOLDFILE = 'ORIGINDESTAGENTRPT';
-SET &RPTNAME = 'Air Export to Destination from Origin Agents';
-SET &REPORTEXT = '.XLS';
-DEFAULT &EMAILID = ' ';
-SET &HLDFMT = IF &EMAILID EQ '' THEN 'PCHOLD FORMAT ' ELSE 'HOLD AS &HOLDFILE.EVAL FORMAT ';
-DEFAULT &OUTPUT = 'EXL2K';
-SET &PARAMS1='Source Create Date';
-SET &PARAMS2='Start Date: ' | &START_DATE | 'End Date: ' | &END_DATE;
-SET &PARAMS3='Report(s): '  | &RPT;
-SET &SQLPARAMS=&PARAMS1 |&PARAMS3;
-MRNOEDIT -INCLUDE shared/startsql
-RUN
-IF &RCASTER EQ 'YES' THEN GOTO NOEMAIL;
-MRNOEDIT -INCLUDE EMAIL1
-RUN
-NOEMAIL
ENGINE SQLORA SET DEFAULT_CONNECTION DMPROD0
SQL SQLORA PREPARE SQLOUT FOR
SELECT
     hb.origin ORIGIN,
	 hb.destination DESTINATION,
	 count(hb.hwb_number) HAWBs,
	 count(mb.mwb_number) MAWBs,
	 sum(hb.actual_weight_kg) ACTUAL_WEIGHT,
     sum(hb.chargeable_weight_kg) CHARGE_WT
from gsu_air_hwb hb left outer join gsu_air_mwb mb
ON  mb.ods_mwb_system_id= hb.export_mwb_ods_system_id
WHERE mb.source_create_dt >= to_date('&START_DATE','mm,dd,yyyy')
AND mb.source_create_dt <= to_date('&END_DATE', 'mm,dd,yyyy')
AND mb.system_record= 'Y'
-IF &COUNTRY EQ 'FOC_NONE' OR &COUNTRY EQ ' ' THEN GOTO NODESTCNTRY1;
AND hb.destination_country = '&COUNTRY'
-NODESTCNTRY1
-IF &DESTINATION EQ 'FOC_NONE' OR &DESTINATION EQ ' ' THEN GOTO NODEST1;
AND hb.destination = '&DESTINATION'
-NODEST1
-IF &ORIGIN_COUNTRY EQ 'FOC_NONE' OR &ORIGIN_COUNTRY EQ ' ' THEN GOTO NOORIGINCNTRY1;
AND hb.origin_country = '&ORIGIN_COUNTRY'
-NOORIGINCNTRY1
-IF &ORIGIN EQ 'FOC_NONE' OR &ORIGIN EQ ' ' THEN GOTO NOORIGIN1;
AND hb.origin= '&ORIGIN'
-NOORIGIN1
GROUP BY hb.origin, hb.destination
END
-MRNOEDIT -INCLUDE endsqlst
-RUN
TABLE FILE SQLOUT
PRINT *
-*END
-*ON TABLE HOLD AS SQLTABLE
-*END
-*TABLE FILE SQLTABLE
-*ON TABLE SUBHEAD
HEADING
"Air Agent Activity by &GRPBYTEXT"
"Period <+0>&START_DATE <+0> through <+0>&END_DATE"
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
-IF &RCASTER EQ 'NO' THEN GOTO NOTRCASTER2;
ON TABLE PCHOLD FORMAT EXL2K
-NOTRCASTER2
ON TABLE &HLDFMT &OUTPUT
ON TABLE SET STYLE *
SQUEEZE=ON,
GRID=OFF,
ORIENTATION=PORTRAIT, $
TYPE=REPORT, FOCEXEC=NONE, FONT=ARIAL, SIZE=8, COLOR=BLACK, BACKCOLOR=NONE, STYLE=NORMAL, $
TYPE=TITLE,COLOR=WHITE,BACKCOLOR=MAROON,SIZE=9,$
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=12, STYLE=BOLD, COLOR='MAROON', $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, SIZE=12, STYLE=BOLD, COLOR='MAROON',$
TYPE=HEADING, LINE=3, STYLE=BOLD, SIZE=11, $
TYPE=HEADING, LINE=4, SIZE=9, $
TYPE=SUBHEAD, LINE=2, STYLE=BOLD+ITALIC, SIZE=10, $
TYPE=TITLE, STYLE=BOLD, SIZE=10, $
TYPE=FOOTING, OBJECT=TEXT, ITEM=1,STYLE=BOLD, $
TYPE=SUBTOTAL, STYLE=BOLD+ITALIC, $
TYPE=GRANDTOTAL, STYLE=BOLD+ITALIC, $
ENDSTYLE
END
-IF &RCASTER EQ 'YES' GOTO NOEMAIL2;
-MRNOEDIT -INCLUDE endrepor
-RUN
-IF &RECORDS EQ 0 THEN GOTO NODATA;
-GOTO ENDRPT;
-NODATA
-MRNOEDIT -INCLUDE shared/NORECS
-RUN
-ENDRPT
-MRNOEDIT -INCLUDE UNIXMAL3
-RUN
-NOEMAIL2
END



7.6.4
January 10, 2014, 05:43 AM
Ian Dalton
Put -SET &ECHO=ALL; in your fex so that you can see exactly which parameter it is complaining about.


_______________________
*** WebFOCUS 8.1.05M ***
January 10, 2014, 07:08 AM
GV
Thanks Ian,
but until I remove all the variables from html page, it throws the same error in fex file. I am talking about the following variables.

 <variables>
				
<variable parametercreatedinreslay="0" displayfield="START_DATE" format="" field="START_DATE" file="sqlout.mas" desc="START_DATE" datatype="0" operation="" default="04/01/2012" name="START_DATE" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="0"></variable>
				
<variable parametercreatedinreslay="0" displayfield="END_DATE" format="" field="END_DATE" file="sqlout.mas" desc="END_DATE" datatype="0" operation="" default="04/30/2012" name="END_DATE" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="0"></variable>
				
<variable parametercreatedinreslay="0" displayfield="COUNTRY" format="" field="COUNTRY" file="sqlout.mas" desc="COUNTRY" datatype="0" operation="" default="FOC_NONE" name="COUNTRY" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="DESTINATION" format="" field="DESTINATION" file="sqlout.mas" desc="DESTINATION" datatype="0" operation="" default="FOC_NONE" name="DESTINATION" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="ORIGIN COUNTRY" format="" field="ORIGIN COUNTRY" file="sqlout.mas" desc="ORIGIN COUNTRY" datatype="0" operation="" default="FOC_NONE" name="ORIGIN COUNTRY" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
				
<variable parametercreatedinreslay="0" displayfield="ORIGIN" format="" field="ORIGIN" file="sqlout.mas" desc="ORIGIN" datatype="0" operation="" default="FOC_NONE" name="ORIGIN" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1"></variable>
			</variables> 


Is there any problem in these variables or I am missing something there?


7.6.4
January 11, 2014, 07:28 AM
Rifaz
Your parameter representation should be a complete oval in shape without any spaces, once after associating your parameters to the fex. Check it in your “Parameters” tab.


When you create a hyperlink to your procedure, click “Additional Paramterers” button and associate your Parameters to it.

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x
January 14, 2014, 06:35 AM
GV
Thanks Rifaz,
Your explaination has done my work. It is woring now.

Cheers,
GV


7.6.4
January 14, 2014, 08:14 AM
Rifaz
Glad to hear GV,

Now, edit your first post and mark it as SOLVED.

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x
January 14, 2014, 11:04 AM
j.gross
If you suspect the launch page / drilldown / UI is sending a set of the parameters that do not conform to the requirements of the called fex, a standard stratagem is to insert scaffolding, like

[code]
-TYPE ~~~~~~~~~~~~~~~~~~~~~ REMOVE
-? &
-TYPE ~~~~~~~~~~~~~~~~~~~~~ ******
-QUIT

at the top of the called fex, to verify exactly what *are* the incoming parameters.

The QUIT will stop the music, so even if the report would normally produce non-HTML output (precluding use of View Source to reveal the webfocus agent's sysout) you will still (temporarily) be able to see the sysout.