[Script] Some javascripts in actions

sir_jeroen · 12 Oct 2005 02:33:29 PM

Tnx this will be very usefull!!
Maybe you could rewrite it to vbscript so most of the people can run and try it without having to compile it in Delphi?

But either way... Still very usefull... can't test it although :'(

jolly · 13 Oct 2005 01:22:43 AM

And here are the report specification for the highlited rows in a report. Be sure that you have the package GO Sales and Retailers in your CRN. You will find the javascript behind the "HTML Item".

Have fun

jolly · 17 Oct 2005 05:16:22 AM

Okay, here is another one of my reports. In this report the user can change the row and the collumn. Also he can change the Measure. In the Prompt Page is a little Javascript which changes the first entry to a text of your choice. In the Report Page is another small Javascript which hide or show the Values/Params.

The attached File included four PNG where you can see the Report

sir_jeroen · 17 Oct 2005 06:03:51 AM

That really looks nice.. Now i'll have to try and top you :D
It's starting to look like a competition... :D
Maybe i've got time tonight to build a new one :D

COGNOiSe administrator · 17 Oct 2005 08:02:11 AM

Nice work, jolly. Very nice.

Great topic RA!

sir_jeroen · 17 Oct 2005 08:07:10 AM

Tnx...

sir_jeroen · 17 Oct 2005 03:36:12 PM

Jolly I accepted your challenge and I raise you a:

Listitem with rowhighlighting and dynamic selection

jolly · 18 Oct 2005 12:58:03 AM

Okay, I take a look at the new Tutorial. Thereafter now I am probably again to bild a new Report. ;D

sir_jeroen · 18 Oct 2005 01:10:00 AM

I always like competition.... :D Hopefully I can beat you..

jolly · 24 Oct 2005 03:27:40 AM

Sorry for the delay to bild a new report. Look at the attached file. On the left side there is a simple List with Javascript inside.Ã,Â On the right side is an Iframe which contains a Power Play Cube.

sir_jeroen · 24 Oct 2005 03:04:19 PM

Ok... I take this bet and I raise it this week... I'm still developing :D

jo0001 · 25 Oct 2005 04:40:45 AM

Hi,

I've just come across your site (COGNOiSe). Thanks a lot for all these cool tipps&tricks.

Therefore, I really would like to contribute some of mine.

Here is one of it. I called it TabView. Hope it is of anybody's interest:

Code Select

<report xml:lang="de" xmlns="http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->
	<modelConnection name="/content/package[@name='GO Sales and Retailers']/model[@name='model']"/>
	<querySet xml:lang="de">
		<BIQuery name="Abfrage1">
			<cube><factList><item refItem="Retailer name" aggregate="none"/><item refItem="Order year" aggregate="none"/></factList></cube>
		<tabularModel><dataItem name="Retailer name" aggregate="none"><expression>[gosales_goretailers].[Orders].[Retailer name]</expression></dataItem><dataItem name="Order year" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order year]</expression></dataItem></tabularModel></BIQuery>
	<BIQuery name="Abfrage2"><cube><factList><item refItem="Order year" aggregate="none"/></factList></cube><tabularModel><dataItem name="Order year" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order year]</expression></dataItem></tabularModel></BIQuery><BIQuery name="Abfrage3"><cube><factList><item refItem="Quantity" aggregate="none"/></factList></cube><tabularModel><dataItem name="Quantity" aggregate="total"><expression>[gosales_goretailers].[Orders].[Quantity]</expression></dataItem></tabularModel></BIQuery></querySet>
	<layoutList>
		<layout>
			
		<pageSet>
				
			<page name="Seite1">
					<pageBody>
						
					<HTMLItem>
							<HTML>&lt;table&gt;
     &lt;tr&gt;
          &lt;td class='mytab' onclick="swapTabs( 'tab1')"&gt;Tab 1&lt;/td&gt;
          &lt;td class='mytab' onclick="swapTabs( 'tab2')"&gt;Tab 2&lt;/td&gt;
          &lt;td class='mytab' onclick="swapTabs( 'tab3')"&gt;Tab 3&lt;/td&gt;
     &lt;/tr&gt;
&lt;/table&gt;
&lt;br&gt;
</HTML></HTMLItem>
						<HTMLItem>
								<HTML>&lt;span id='tab1' CLASS="DIV_DETAILS"&gt;</HTML></HTMLItem><block>
							<list maxRows="1000" refQuery="Abfrage1" cellHeightBehavior="stretch">
							<listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="Retailer name"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Order year"/></textItem></listColumnTitle></listColumnTitles>
							<listColumns><listColumn><textItem><queryItemRef refItem="Retailer name"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Order year"/></textItem></listColumn></listColumns>
							<style>
								<CSS value="border-collapse:collapse"/>
							</style>
						<XMLAttribute name="RS_ListGroupInfo" value=""/></list>
							</block>
						<HTMLItem>
								<HTML>&lt;/span&gt;</HTML></HTMLItem><HTMLItem>
								<HTML>&lt;span id='tab2'&gt;
</HTML></HTMLItem><block>
							<list refQuery="Abfrage2">
								<listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="Order year"/></textItem></listColumnTitle></listColumnTitles>
								<listColumns><listColumn><textItem><queryItemRef refItem="Order year"/></textItem></listColumn></listColumns>
								<style>
									<CSS value="border-collapse:collapse"/>
								</style>
							<XMLAttribute name="RS_ListGroupInfo" value=""/></list>
						
						</block>
						<HTMLItem>
								<HTML>&lt;/span&gt;</HTML></HTMLItem><HTMLItem>
								<HTML>&lt;span id='tab3'&gt;
</HTML></HTMLItem><block>
							<list refQuery="Abfrage3">
								<listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="Quantity"/></textItem></listColumnTitle></listColumnTitles>
								<listColumns><listColumn><textItem><queryItemRef refItem="Quantity"/></textItem><style><CSS value="text-align:right"/></style></listColumn></listColumns>
								<style>
									<CSS value="border-collapse:collapse"/>
								</style>
							<XMLAttribute name="RS_ListGroupInfo" value=""/></list>
							
						</block>
					<HTMLItem>
								<HTML>&lt;/span&gt;
&lt;img src="../pat/images/blank.gif" onload="swapTabs( 'tab1')"/&gt;</HTML></HTMLItem></pageBody>
					<pageHeader>
						
						<HTMLItem>
							<HTML>&lt;style&gt;
.mytab{
     font-size:12px;
     font-weight:bold;
     color:black;
     border:1px solid black;
     cursor: hand;
}

&lt;/style&gt;

&lt;script&gt;

function swapTabs( tabId){

	//alert(tabId);

	var tab1 = document.getElementById("tab1");
	var tab2 = document.getElementById("tab2");
	var tab3 = document.getElementById("tab3");
	
     	if (tabId=="tab1"){
     		
		tab1.style.display = "block";
		tab2.style.display = "none";
		tab3.style.display = "none";
	}
	else if(tabId=="tab2"){
		     	
     		tab1.style.display = "none";
		tab2.style.display = "block";
		tab3.style.display = "none";
	}
	else if(tabId=="tab3"){
		
		tab1.style.display = "none";
		tab2.style.display = "none";
		tab3.style.display = "block";
	}
    
}

&lt;/script&gt;
</HTML></HTMLItem><block class="reportTitle">
							<textItem class="reportTitleText">
								<text/>
							</textItem>
						</block>
						<style>
							<CSS value="padding-bottom:10px"/>
						</style>
					</pageHeader>
					<pageFooter>
						<table>
							<tableRow>
								<tableCell>
									<textItem>
										<expression>AsOfDate()</expression>
									</textItem>
									<style>
										<CSS value="vertical-align:top;text-align:left;width:25%"/>
									</style>
								</tableCell>
								<tableCell>
									<textItem>
										<text>- </text>
									</textItem>
									<textItem>
										<expression>PageNumber()</expression>
									</textItem>
									<textItem>
										<text> -</text>
									</textItem>
									<style>
										<CSS value="vertical-align:top;text-align:center;width:50%"/>
									</style>
								</tableCell>
								<tableCell>
									<textItem>
										<expression>AsOfTime()</expression>
									</textItem>
									<style>
										<CSS value="vertical-align:top;text-align:right;width:25%"/>
									</style>
								</tableCell>
							</tableRow>
							<style>
								<CSS value="border-collapse:collapse;width:100%"/>
							</style>
						</table>
						<style>
							<CSS value="padding-top:10px"/>
						</style>
					</pageFooter>
				</page></pageSet></layout>
	</layoutList>
</report>

Cheers, Jochen

sir_jeroen · 25 Oct 2005 04:11:18 PM

Looks great... Are you in for some competition ? :D

2 little remarks:
Next time if possible add a screen dump and could you use the code-tag this because in some cases your code could get unescaped...(e.g. > becomes > )

But still.. looks great!!

jolly · 26 Oct 2005 02:20:54 AM

Hi jo0001, 8) 8)

jolly · 26 Oct 2005 06:01:11 AM

Here is a small Video about another possibility to sort Columns with Javascript.

CoginAustin · 26 Oct 2005 06:50:54 AM

I cant play the file because of a "Unknown Codec" :(

sir_jeroen · 26 Oct 2005 07:20:25 AM

Jolly.... 1 word: AWSOME!!!

jolly · 26 Oct 2005 07:48:22 AM

Okay, CoginAustin try this one. Sorry for the poor Quality.

CoginAustin · 26 Oct 2005 07:55:06 AM

Thanks! That is very cool

COGNOiSe administrator · 02 Nov 2005 08:21:57 AM

I had to restore the forum from backups earlier this week following the corruption of some forum software files and as such as attachments after 21st September will need to be uploaded again.

Apologies! I will try to do these backups more frequently (or if anyone knows how to run a CRON job to backup and save the database please drop me a line).

Cheers

jolly · 21 Nov 2005 05:43:17 AM

It is already a time ago, which I built a report. In the attached File is a Video which shows an Template whith different Javascript Items inside. One of the Javascript Function is from ReportNet Addict. Btw. If you canÃ,Â´t play the file because of an "Unknown Codec", please go to the Techsmith Website and download the Codec. The Link http://www.techsmith.com/download/codecsdefault.asp.

Have fun

Cu Jolly

JoeBass · 21 Nov 2005 06:50:07 AM

That looks great Jolly.

I've looked into your list sorting example and would like to be able to use your approach of clicking columns titles to sort.

I don't expect you to reveal the code in your html item (your movie has a masterful tease that had me thinking you might show the innards) that does the work but, could you describe the method? Thanks.

JoeBass · 21 Nov 2005 10:18:48 AM

Here's a simple list report based on Go Sales.Ã,Â It is sortable by clicking column headers.Ã,Â I pinched the amazing JavaScript table sorting code from Stuart Langridge at http://www.kryogenix.org/code/browser/sorttable/.Ã,Â

--------------------------------------------------------------------------------------------
11/22 - Reworked the sort date function to work with short date formats.

Code Select

<report xml:lang="en-us" xmlns="http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->
	<layoutList>
		<layout>
			
		<pageSet>
				
			<page name="Page1">
					<pageBody><list id="List_ID" class="list" refQuery="Query1">
							<listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="Order number"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Order method"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Retailer name"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Product name"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Unit cost"/></textItem></listColumnTitle></listColumnTitles>
							<listColumns><listColumn><textItem><queryItemRef refItem="Order number"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Order method"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Retailer name"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Product name"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Unit cost"/></textItem><style><CSS value="text-align:right"/></style></listColumn></listColumns>
							<style>
								<CSS value="border-collapse:collapse"/>
							</style>
						</list>
						<HTMLItem>
							<HTML>&lt;script&gt;
// Thank you Stuart Langridge!
// Javascript table sorting code from http://www.kryogenix.org/code/browser/sorttable/

addEvent(window, "load", sortables_init);

var SORT_COLUMN_INDEX;

function sortables_init() {
Ã,Â  Ã,Â  // Find all tables with class sortable and make them sortable
Ã,Â  Ã,Â  if (!document.getElementsByTagName) return;
Ã,Â  Ã,Â  tbls = document.getElementsByTagName("table");
Ã,Â  Ã,Â  for (ti=0;ti&lt;tbls.length;ti++) {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  thisTbl = tbls[ti];
	if (thisTbl.className == "list") {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  ts_makeSortable(thisTbl);
Ã,Â  Ã,Â  Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  }
}

function ts_makeSortable(table) {
Ã,Â  Ã,Â  if (table.rows &amp;&amp; table.rows.length &gt; 0) {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  var firstRow = table.rows[0];
Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  if (!firstRow) return;
Ã,Â  Ã,Â  
Ã,Â  Ã,Â  // We have a first row: assume it's the header, and make its contents clickable links
Ã,Â  Ã,Â  for (var i=0;i&lt;firstRow.cells.length;i++) {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  var cell = firstRow.cells[i];
Ã,Â  Ã,Â  Ã,Â  Ã,Â  var txt = ts_getInnerText(cell);
Ã,Â  Ã,Â  Ã,Â  Ã,Â  cell.innerHTML = '&lt;a href="#" class="sortheader" onclick="ts_resortTable(this);return false;"&gt;'+txt+'&lt;span class="sortarrow"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/a&gt;';
Ã,Â  Ã,Â  }
}

function ts_getInnerText(el) {
	if (typeof el == "string") return el;
	if (typeof el == "undefined") { return el };
	if (el.innerText) return el.innerText;	//Not needed but it is faster
	var str = "";
	
	var cs = el.childNodes;
	var l = cs.length;
	for (var i = 0; i &lt; l; i++) {
		switch (cs[i].nodeType) {
			case 1: //ELEMENT_NODE
				str += ts_getInnerText(cs[i]);
				break;
			case 3:	//TEXT_NODE
				str += cs[i].nodeValue;
				break;
		}
	}
	return str;
}

function ts_resortTable(lnk) {
Ã,Â  Ã,Â  // get the span
Ã,Â  Ã,Â  var span;
Ã,Â  Ã,Â  for (var ci=0;ci&lt;lnk.childNodes.length;ci++) {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  if (lnk.childNodes[ci].tagName &amp;&amp; lnk.childNodes[ci].tagName.toLowerCase() == 'span') span = lnk.childNodes[ci];
Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  var spantext = ts_getInnerText(span);
Ã,Â  Ã,Â  var td = lnk.parentNode;
Ã,Â  Ã,Â  var column = td.cellIndex;
Ã,Â  Ã,Â  var table = getParent(td,'TABLE');
Ã,Â  Ã,Â  
Ã,Â  Ã,Â  // Work out a type for the column
Ã,Â  Ã,Â  if (table.rows.length &lt;= 1) return;
Ã,Â  Ã,Â  var itm = ts_getInnerText(table.rows[1].cells[column]);
Ã,Â  Ã,Â  sortfn = ts_sort_caseinsensitive;
Ã,Â  Ã,Â  if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d\d\d$/)) sortfn = ts_sort_date;
Ã,Â  Ã,Â  if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d$/)) sortfn = ts_sort_date;
Ã,Â  Ã,Â  if (itm.match(/^[Ã,Â£$]/)) sortfn = ts_sort_currency;
Ã,Â  Ã,Â  if (itm.match(/^[\d\.]+$/)) sortfn = ts_sort_numeric;
Ã,Â  Ã,Â  SORT_COLUMN_INDEX = column;
Ã,Â  Ã,Â  var firstRow = new Array();
Ã,Â  Ã,Â  var newRows = new Array();
Ã,Â  Ã,Â  for (i=0;i&lt;table.rows[0].length;i++) { firstRow[i] = table.rows[0][i]; }
Ã,Â  Ã,Â  for (j=1;j&lt;table.rows.length;j++) { newRows[j-1] = table.rows[j]; }

Ã,Â  Ã,Â  newRows.sort(sortfn);

Ã,Â  Ã,Â  if (span.getAttribute("sortdir") == 'down') {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  ARROW = '&amp;nbsp;&amp;nbsp;&amp;uarr;';
Ã,Â  Ã,Â  Ã,Â  Ã,Â  newRows.reverse();
Ã,Â  Ã,Â  Ã,Â  Ã,Â  span.setAttribute('sortdir','up');
Ã,Â  Ã,Â  } else {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  ARROW = '&amp;nbsp;&amp;nbsp;&amp;darr;';
Ã,Â  Ã,Â  Ã,Â  Ã,Â  span.setAttribute('sortdir','down');
Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  
Ã,Â  Ã,Â  // We appendChild rows that already exist to the tbody, so it moves them rather than creating new ones
Ã,Â  Ã,Â  // don't do sortbottom rows
Ã,Â  Ã,Â  for (i=0;i&lt;newRows.length;i++) { if (!newRows[i].className || (newRows[i].className &amp;&amp; (newRows[i].className.indexOf('sortbottom') == -1))) table.tBodies[0].appendChild(newRows[i]);}
Ã,Â  Ã,Â  // do sortbottom rows only
Ã,Â  Ã,Â  for (i=0;i&lt;newRows.length;i++) { if (newRows[i].className &amp;&amp; (newRows[i].className.indexOf('sortbottom') != -1)) table.tBodies[0].appendChild(newRows[i]);}
Ã,Â  Ã,Â  
Ã,Â  Ã,Â  // Delete any other arrows there may be showing
Ã,Â  Ã,Â  var allspans = document.getElementsByTagName("span");
Ã,Â  Ã,Â  for (var ci=0;ci&lt;allspans.length;ci++) {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  if (allspans[ci].className == 'sortarrow') {
Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  if (getParent(allspans[ci],"table") == getParent(lnk,"table")) { // in the same table as us?
Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  allspans[ci].innerHTML = '&amp;nbsp;&amp;nbsp;&amp;nbsp;';
Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  }
Ã,Â  Ã,Â  Ã,Â  Ã,Â  
Ã,Â  Ã,Â  span.innerHTML = ARROW;
}

function getParent(el, pTagName) {
	if (el == null) return null;
	else if (el.nodeType == 1 &amp;&amp; el.tagName.toLowerCase() == pTagName.toLowerCase())	// Gecko bug, supposed to be uppercase
		return el;
	else
		return getParent(el.parentNode, pTagName);
}
function ts_sort_date(a,b) {

Ã,Â  Ã,Â  // y2k notes: two digit years less than 50 are treated as 20XX, greater than 50 are treated as 19XX
Ã,Â  Ã,Â  aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
Ã,Â  Ã,Â  bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);

Ã,Â  Ã,Â  aaDateArray = aa.split("/");
Ã,Â  Ã,Â  bbDateArray = bb.split("/");

Ã,Â  Ã,Â  if (parseInt(aaDateArray[2]) < 50) { yr = '20'+ aaDateArray[2]; } else { yr = '19'+ aaDateArray[2]; }
Ã,Â  Ã,Â  if (parseInt(aaDateArray[0]) < 10) { TheMonth = '0' + aaDateArray[0]; } else { TheMonth = aaDateArray[0]; }
Ã,Â  Ã,Â  if (parseInt(aaDateArray[1]) < 10) { TheDay = '0' + aaDateArray[1]; } else { TheDay = aaDateArray[1]; }
Ã,Â  Ã,Â  dt1 = yr + TheMonth + TheDay;

Ã,Â  Ã,Â  if (parseInt(bbDateArray[2]) < 50) { yr = '20'+ bbDateArray[2]; } else { yr = '19'+ bbDateArray[2]; }
Ã,Â  Ã,Â  if (parseInt(bbDateArray[0]) < 10) { TheMonth = '0' + bbDateArray[0]; } else { TheMonth = bbDateArray[0]; }
Ã,Â  Ã,Â  if (parseInt(bbDateArray[1]) < 10) { TheDay = '0' + bbDateArray[1]; } else { TheDay = bbDateArray[1]; }
Ã,Â  Ã,Â  dt2 = yr + TheMonth + TheDay;

Ã,Â  Ã,Â  if (dt1==dt2) return 0;
Ã,Â  Ã,Â  if (dt1<dt2) return -1;
Ã,Â  Ã,Â  return 1;
}

function ts_sort_currency(a,b) { 
Ã,Â  Ã,Â  aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g,'');
Ã,Â  Ã,Â  bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g,'');
Ã,Â  Ã,Â  return parseFloat(aa) - parseFloat(bb);
}

function ts_sort_numeric(a,b) { 
Ã,Â  Ã,Â  aa = parseFloat(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));
Ã,Â  Ã,Â  if (isNaN(aa)) aa = 0;
Ã,Â  Ã,Â  bb = parseFloat(ts_getInnerText(b.cells[SORT_COLUMN_INDEX])); 
Ã,Â  Ã,Â  if (isNaN(bb)) bb = 0;
Ã,Â  Ã,Â  return aa-bb;
}

function ts_sort_caseinsensitive(a,b) {
Ã,Â  Ã,Â  aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).toLowerCase();
Ã,Â  Ã,Â  bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).toLowerCase();
Ã,Â  Ã,Â  if (aa==bb) return 0;
Ã,Â  Ã,Â  if (aa&lt;bb) return -1;
Ã,Â  Ã,Â  return 1;
}

function ts_sort_default(a,b) {
Ã,Â  Ã,Â  aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
Ã,Â  Ã,Â  bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);
Ã,Â  Ã,Â  if (aa==bb) return 0;
Ã,Â  Ã,Â  if (aa&lt;bb) return -1;
Ã,Â  Ã,Â  return 1;
}


function addEvent(elm, evType, fn, useCapture)
// addEvent and removeEvent
// cross-browser event handling for IE5+,Ã,Â  NS6 and Mozilla
// By Scott Andrew
{
Ã,Â  if (elm.addEventListener){
Ã,Â  Ã,Â  elm.addEventListener(evType, fn, useCapture);
Ã,Â  Ã,Â  return true;
Ã,Â  } else if (elm.attachEvent){
Ã,Â  Ã,Â  var r = elm.attachEvent("on"+evType, fn);
Ã,Â  Ã,Â  return r;
Ã,Â  } else {
Ã,Â  Ã,Â  alert("Handler could not be removed");
Ã,Â  }
}
&lt;/script&gt;</HTML></HTMLItem></pageBody>
				</page></pageSet></layout>
	</layoutList>
<modelConnection name="/content/package[@name='GO Sales and Retailers']/model[@name='model']"/><querySet xml:lang="en-us"><BIQuery name="Query1"><cube><factList><item refItem="Order number" aggregate="none"/><item refItem="Retailer name" aggregate="none"/><item refItem="Order date" aggregate="none"/><item refItem="Order method" aggregate="none"/><item refItem="Product name" aggregate="none"/><item refItem="Unit cost" aggregate="none"/></factList></cube><tabularModel><dataItem name="Order number" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order number]</expression></dataItem><dataItem name="Retailer name" aggregate="none"><expression>[gosales_goretailers].[Orders].[Retailer name]</expression></dataItem><dataItem name="Order date" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order date]</expression></dataItem><dataItem name="Order method" aggregate="none"><expression>[gosales_goretailers].[Orders].[Order method]</expression></dataItem><dataItem name="Product name" aggregate="none"><expression>[gosales_goretailers].[Orders].[Product name]</expression></dataItem><dataItem name="Unit cost" aggregate="average"><expression>[gosales_goretailers].[Orders].[Unit cost]</expression></dataItem></tabularModel></BIQuery></querySet></report>

Ã,Â

sir_jeroen · 21 Nov 2005 01:49:10 PM

Nice... very nice code :D Always usefull...

jolly · 21 Nov 2005 03:47:39 PM

Hi JoeBass,

here you got the Report specification about the sorting for Simple List Reports with Javascript.

Cu

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com

COGNOiSe.com - The IBM Cognos Community

News:

[Script] Some javascripts in actions

sir_jeroen

jolly

jolly

sir_jeroen

COGNOiSe administrator

sir_jeroen

sir_jeroen

jolly

sir_jeroen

jolly

sir_jeroen

jo0001

sir_jeroen

jolly

jolly

CoginAustin

sir_jeroen

jolly

CoginAustin

COGNOiSe administrator

jolly

JoeBass

JoeBass

sir_jeroen

jolly