[CLOSED] Replacing the OR with , values

October 06, 2011, 01:09 PM

Hi All,
I have a mutiple selection drop box which generates the OR code in the HTML composer.

example. WHERE CAR EQ 'TOYOTA' OR 'JAGUAR'.
I want to replace the OR with a ','. to include these values in the report heading.

Can anyone help how to get this.

Regards,
SAMM

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

October 06, 2011, 01:26 PM

njsden

Look for STRREP.

October 06, 2011, 01:26 PM

Francis Mariani

Change the properties for the select box:

Check the box for "Send display value".

This will pass a parameter for COUNTRY called COUNTRY_TEXT with the values separated by comma.

October 06, 2011, 01:40 PM

njsden

But that's too easy ... not fair.

October 06, 2011, 03:21 PM

SAMM

Francis,
As mentioned the changes didnt reflect in my code. Please see the changes that I made using the CAR file.

 <HTML>
<HEAD>
<META id=mycharsetmeta http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META id=Generation content="Created in release 7702, 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 src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>

<SCRIPT id=IBI_nlsVars src="/ibi_html/javaassist/nlsvars.js" type=text/javascript></SCRIPT>

<SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></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
 
//Begin function button1_onclick
function button1_onclick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function button1_onclick
</SCRIPT>

<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" thumbnailscale="4" nextelementuniquenumber="5" elementtype="21">  
<SELECT id=combobox1 style="Z-INDEX: 2; LEFT: 190px; WIDTH: 190px; POSITION: absolute; TOP: 100px" tabIndex=2 multiselect="multiple" defaultselection="1" persistentuniqueid="compUid_4" name="CAR"></SELECT> 
<INPUT language=javascript id=button1 style="Z-INDEX: 3; LEFT: 190px; WIDTH: 190px; POSITION: absolute; TOP: 150px; HEIGHT: 50px" onclick=button1_onclick(this) tabIndex=3 type=button value=Button requests_list="2" autoExecute="true" name="button1">    
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=nyclaw name="ibiapp_app">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="6">
	
<rootxmlnode focoption="_FOC_NULL" top="50" left="10" width="150" height="130">
		
<variables>
			
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="CAR" name="CAR" default="TOYOTA" textvarname="" accept="0" select="0" create="0" top="21" left="1" width="60" height="20" inbinding="0">
				
<link linktype="default">
					
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" displayfield="CAR" ibiformat="A16" datafield="CAR" datasource="car.mas" datatype="0" selectedvalue="TOYOTA" operation="" slider_range_from="" slider_range_to="" previewvalue="TOYOTA" sourcetype="typeMaster">
							
<static_values>
								
<static value="TOYOTA" display="TOYOTA" selected="1" noinput="0"></static></static_values></data_info></condition></link>
				
<requestid id="2"></requestid></variable></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_4" elementtype="8" name="CAR" id="combobox1" multiple="1" inbinding="1" top="20" left="30" width="60" height="20" onetimepopulated="0">
				
<link linktype="default" persistentuniqueid="compUid_4">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datatype="1" modifiedrequest="0" ibiapp_app="nyclaw" datasource="CAR.mas" displayfield="CAR.ORIGIN.COUNTRY" ibiformat="A10" dfformat="A10" datafield="CAR.ORIGIN.COUNTRY" addalloption="1" dynalldisplayvalue="ALL" addnoselectionoption="0" dynnoselectiondisplayvalue="Please Select A Value" dosorting="1" sorttype="0">
							
<![CDATA[TABLE FILE CAR
SUM FST.CAR.ORIGIN.COUNTRY
 BY CAR.ORIGIN.COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests nextrequestsid="2">
			
<request requestid="2" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="t_p.fex" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="nyclaw"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

-SET &ECHO=ALL;
-DEFAULT &CAR='TOYOTA'
TABLE FILE CAR
PRINT
CAR
COUNTRY
MODEL
WHERE COUNTRY EQ '&CAR.EVAL';
END
-EXIT

October 06, 2011, 03:47 PM

njsden

If you follow Francis' steps, you should now have 2 parameters in your .fex:

1. &CAR -> proper filter expression ('JAGUAR' OR 'JENSEN' OR ...). That goes in your WHERE.
2. &CAR_TEXT -> Special variable with a comma-separated list of cars (JAGUAR, JENSEN, ..) and no internal quotes. That goes in your HEADING.