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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
{Solved}(FOC261)
 Login/Join
 
Member
posted
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
 
Posts: 5 | Registered: December 09, 2013Report This Post
Master
posted Hide Post
-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
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: December 09, 2013Report This Post
Platinum Member
posted Hide Post
Put -SET &ECHO=ALL; in your fex so that you can see exactly which parameter it is complaining about.


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: December 09, 2013Report This Post
Guru
posted Hide Post
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
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Member
posted Hide Post
Thanks Rifaz,
Your explaination has done my work. It is woring now.

Cheers,
GV


7.6.4
 
Posts: 5 | Registered: December 09, 2013Report This Post
Guru
posted Hide Post
Glad to hear GV,

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

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders