Hi,

I need to keep a dynamic date range in calendar control starting from three year back start date till current day minus seven days.
I have done this by a dynamic procedure from calendar properties with calendardatatype="2" calendardata="cal_sted.fex". But when i run the launch page the text box alone is appearing while calendar control is not showing up on the run.

--cal_sted.fex--

 DEFINE FILE CAR
DATE1/YYMD='&YYMD';
DATE2/YYMD=DATEADD(DATE1,'D',-7);
DATE3/YYMD=DATEADD(DATE1,'Y',-3);
DATE4/YYMD=DATEMOV(DATE3,'BOY');
END
TABLE FILE CAR
PRINT
DATE4 AND DATE2
COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1;
ON TABLE PCHOLD FORMAT XML
END

When i ran the same with relative setting calendardata="0/-7/-3;0/-7/0" calendardatatype="1" it is working fine.I have the calendar parameters assigned correctly to the fex parameters.Currently working on 7.6.9 version.

Please provide suggestions.

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

Please add the following line to your code:

ON TABLE SET HOLDLIST PRINTONLY

The XML file can only have two fields in it, c0 and c1. Run the program independently and check out the XML before you run your launch page.

Thanks Ginny for your suggestion , I tried that even then with the above code i am not able to see the calendar control on the run.
In XML i have

  
  <td colnum="c0" rawvalue="20060101">20060101</td> 
  <td colnum="c1" rawvalue="20091103">20091103</td> 

In my launch page i have three list box selections also.
Please provide other suggestions.

Make sure that the ID attribute of the HTML form controls are unique.

For one of IBs calendar controls there are other items to consider. Explain how you are using the XML output within the javascript and also post the control line from your HTML (NOT the whole HTML. Remember to enclose the HTML line using [ code] and [/code] tags in your posting.

T

The calendar id i have used is unique. I am having two calendar date selection as from and to dates.The control line which i have used in HTML page is as

  
<INPUT id=RDFRM_DT onblur="DateFormat(this,this.value,event,true,'2')" onkeyup="DateFormat(this,this.value,event,false,'2')"
style="Z-INDEX: 136; LEFT: 70px; WIDTH: 130px; POSITION: absolute; TOP: 480px; HEIGHT: 27px; BACKGROUND-COLOR: #ffffcc" 
tabIndex=154 maxLength=10 accept=0 size=8 name=RDFRM_DT elementtype="14" addalloption="0" operation datatype="0" 
datasource sourcetype="typeMaster" ibic_server ibiformat="YYMD" selectedvalue="ALL" boundtovariable="1" 
calendardatatype="2" calendardata="cal_sted.fex">

<INPUT id=RDTO_DT onblur="DateFormat(this,this.value,event,true,'2')" onkeyup="DateFormat(this,this.value,event,false,'2')" 
style="Z-INDEX: 140; LEFT: 290px; WIDTH: 130px; POSITION: absolute; TOP: 480px; HEIGHT: 27px; BACKGROUND-COLOR: #ffffcc" 
tabIndex=157 maxLength=10 accept=0 size=7 name=RDTO_DT elementtype="14" addalloption="0" operation datatype="0" 
datasource sourcetype="typeMaster" ibiformat="YYMD" selectedvalue="ALL" boundtovariable="1" calendardatatype="2" calendardata="cal_sted.fex">

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

The first thing I spot is that your sourcetype attribute is set to typeMaster which intimates that you want population achieved using the .mas.

Internally IBIRLS.JS (also IBIRLS2 and 3 but I need to check 3 for the latest calendar control script) will use an adhoc fex to achieve the XML return is the format -

TABLE FILE [datasource attribute value]
SUM FST.[displayfield attribute value]
BY [datafield attribute value]
ON TABLE PCHOLD FORMAT XML
END

but you have no attributes set for datafield or displayfield, there isn't even a datasource attribute value!

I will have to read through the IBIRLS2 (I think that is the version you use? check at the top of your HTML) to see how this particular calendar control is populated using the attributes that you have in your code. I will check when I get time.

In the meantime it could be a simple case of changing the sourcetype attribute values to typeFex (case specific). Give it a try - it can't hurt?

The code that you have posted also has the "selectedvalue" attribute which is what Attilla was asking about.

T

Thanks tony for your suggestions i tried replacing typeMaster with typeFex in sourcetype and adding the datafield,displayfield and datasource value. This still does'nt work

I have the following code in my HTML page :

  <SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "764";
var cgipath = "cgipath";
var ibirls = "ibirls2";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls,rltdyncalendar);
</SCRIPT>

<SCRIPT id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>

<SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>

--------------*and towards the end of my code i have the script as:*---------------------

 <SCRIPT id=IBI_loadcalendar type=text/javascript>
if(ibigblInitInfo.testOptions(rltdyncalendar)){
     setDateRange();
     setupDocCalendars();
}</SCRIPT>

<SCRIPT id=IBI_loader type=text/javascript>
getActiveReportJscript();
setUserInfo();
</SCRIPT>
 

This is how the script is generated in my HTML code. Please provide any suggestions to fix this.

Thanks a lot Tony for your suggestions ,found an alternative method to satisfy my requirement.

In the calendar onload function i called a function which will calculate a string as per my requirement. So i am no longer populating from dynamic procedure, doing it with relative property of calendar only.

Could'nt make out why the calendar control did'nt turn up while using dynamic procedure.

--*Calling function fill_calendar*--

 <SCRIPT id=IBI_loadcalendar type=text/javascript>
fill_calendar();
if(ibigblInitInfo.testOptions(rltdyncalendar)){
     setDateRange();
     setupDocCalendars();
}</SCRIPT>

<SCRIPT id=IBI_loader type=text/javascript>
getActiveReportJscript();
setUserInfo();
</SCRIPT>
 

--*fill_calendar function*--

  
function fill_calendar() {
var d=new Date();
var a=d.getMonth();
var c=d.getDate();
var e=-a;
var g=-(c-1);
var f=e+"/"+g+"/"+-3+";"+"0/-7/0";
document.getElementById('RDFRM_DT').calendardata = f;
}

The above function will return the date in format "Month/Day/Year;Month/Day/Year" in Var f, which is set for calendardata property on load.