Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Expand and Collapse Report Group
Expand and Collapse Report Group [message #368740] Tue, 23 June 2009 06:12 Go to next message
TY is currently offline TYFriend
Messages: 1
Registered: July 2009
Junior Member
Hello,
I tried the script below sent by Jason Weathersby. It works in birt
designer, but it doesn't work with Internet Explorer 8. IE shows following
error:

document.getElementById(...)' is null or not an object.
frameset
Code:0

i am using birt 2.3.2.2

how can i fix this problem? Anyone can help me..


Jason


<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design"; version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name
here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<method
name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
"");]]></method>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="7">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
</list-property>
<property name="queryText">select *
from orderdetails
</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set1" id="59">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="nativeName">REQUIREDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="nativeName">COMMENTS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<property name="queryText">select *
from orders</property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="detail" id="56">
<property name="backgroundColor">#BACAE2</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="headerfooter" id="57">
<property name="backgroundColor">#004080</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
</style>
<style name="groupheader" id="58">
<property name="backgroundColor">#0080FF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new
Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="8">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<expression name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRODUCTCODE</property>
<expression name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDERLINENUMBER</property>
<expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Column Binding</property>
<expression name="expression">importPackage(Packages.java.lang);
reportContext.setPersistentGlobalVariable("rorder", new
Integer(row["ORDERNUMBER"]));
row["ORDERNUMBER"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Aggregation</property>
<property name="displayName">grpcnt</property>
<expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">any</property>
<simple-property-list name="aggregateOn">
<value>Order</value>
</simple-property-list>
<property name="aggregateFunction">count</property>
</structure>
</list-property>
<list-property name="sort">
<structure>
<expression name="key">row["ORDERLINENUMBER"]</expression>
<property name="direction">asc</property>
</structure>
</list-property>
<column id="37">
<property name="width">1.0520833333in</property>
</column>
<column id="38">
<property name="width">1.1145833333in</property>
</column>
<column id="39"/>
<column id="40"/>
<column id="41"/>
<header>
<row id="9">
<property name="style">headerfooter</property>
<cell id="10">
<label id="11">
<text-property name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="12">
<label id="13">
<text-property name="text">PRODUCTCODE</text-property>
</label>
</cell>
<cell id="14">
<label id="15">
<text-property name="text">QUANTITYORDERED</text-property>
</label>
</cell>
<cell id="16">
<label id="17">
<text-property name="text">PRICEEACH</text-property>
</label>
</cell>
<cell id="18">
<label id="19">
<text-property name="text">ORDERLINENUMBER</text-property>
</label>
</cell>
</row>
</header>
<group id="42">
<property name="groupName">Order</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ORDERNUMBER"]</expression>
<structure name="toc">
<expression name="expressionValue">"Order Number
"+row["ORDERNUMBER"]</expression>
<property name="TOCStyle">groupheader</property>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="43">
<expression name="bookmark">row["ORDERNUMBER"]</expression>
<property name="style">groupheader</property>
<cell id="44"/>
<cell id="45"/>
<cell id="46"/>
<cell id="47"/>
<cell id="48"/>
</row>
<row id="120">
<property name="height">0.438in</property>
<expression name="bookmark">row["ORDERNUMBER"]</expression>
<property name="style">groupheader</property>
<cell id="121">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<text id="80">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<form>
<script>
function hidetable(form, ord, rwcnt){

//alert( document.getElementById(ord).style.display );



var hide = false;
var btnstr = "mybutton"+ord;


if( document.getElementById(ord).style.display == 'block' ||
document.getElementById(ord).style.display == ""){
document.getElementById(ord).style.display = 'none';
document.getElementById(btnstr).value = "+";
//form.btnstr.value = "+";
hide = true;
}else{
document.getElementById(ord).style.display = 'block';
document.getElementById(btnstr).value = "-";
//form.btnstr.value = "-";
hide = false;
}
for( i=1; i<= rwcnt; i++ ){
var drow = ord+""+i;
if( document.getElementById(drow)){
if( hide ){
document.getElementById(drow).style.display = 'none';
}else{
document.getElementById(drow).style.display = 'block';
}
}
}



}


</script>


<INPUT Type="BUTTON"
name=<VALUE-OF>"mybutton"+row["ORDERNUMBER"]</VALUE-OF > Value="-"
onClick='hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
<VALUE-OF>row["Aggregation"]</VALUE-OF> )'></INPUT>
<VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>
<script>
hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
<VALUE-OF>row["Aggregation"]</VALUE-OF> );
</script>

</form>]]></text-property>
</text>
</cell>
<cell id="123">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
</cell>
</row>
</header>
<footer>
<row id="126">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr">true</expression>
</structure>
</list-property>
<cell id="127">
<label id="132">
<text-property name="text">This row is hidden</text-property>
</label>
</cell>
<cell id="128"/>
<cell id="129"/>
<cell id="130"/>
<cell id="131">
<data id="113">
<property name="resultSetColumn">Aggregation</property>
</data>
</cell>
</row>
</footer>
</group>
<detail>
<row id="100">
<expression name="bookmark">row["ORDERNUMBER"]+ ""
+row["ORDERLINENUMBER"];</expression>
<property name="style">detail</property>
<cell id="101">
<data id="81">
<property name="resultSetColumn">Column Binding</property>
</data>
</cell>
<cell id="102">
<data id="24">
<property name="textAlign">center</property>
<property name="resultSetColumn">PRODUCTCODE</property>
</data>
</cell>
<cell id="103">
<data id="26">
<property name="textAlign">center</property>
<property name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
<cell id="104">
<data id="28">
<property name="textAlign">center</property>
<property name="resultSetColumn">PRICEEACH</property>
</data>
</cell>
<cell id="105">
<data id="30">
<property name="textAlign">center</property>
<expression name="bookmark">row["ORDERLINENUMBER"]</expression>
<property name="resultSetColumn">ORDERLINENUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="31">
<property name="style">headerfooter</property>
<cell id="32"/>
<cell id="33"/>
<cell id="34"/>
<cell id="35"/>
<cell id="36"/>
</row>
</footer>
</table>
</body>
</report>
Re: Expand and Collapse Report Group [message #368765 is a reply to message #368740] Wed, 24 June 2009 15:41 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Can you try this one?

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<method
name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
"");]]></method>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="7">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
</list-property>
<property name="queryText">select *
from orderdetails
</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set1" id="59">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORDERDATE</property>
<property name="nativeName">ORDERDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">REQUIREDDATE</property>
<property name="nativeName">REQUIREDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SHIPPEDDATE</property>
<property name="nativeName">SHIPPEDDATE</property>
<property name="dataType">date</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">COMMENTS</property>
<property name="nativeName">COMMENTS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<property name="queryText">select *
from orders</property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="detail" id="56">
<property name="backgroundColor">#BACAE2</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="headerfooter" id="57">
<property name="backgroundColor">#004080</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
</style>
<style name="groupheader" id="58">
<property name="backgroundColor">#0080FF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="8">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDERLINENUMBER</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Column Binding</property>
<expression
name="expression">importPackage(Packages.java.lang);
reportContext.setPersistentGlobalVariable("rorder", new
Integer(row["ORDERNUMBER"]));
row["ORDERNUMBER"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Aggregation</property>
<property name="displayName">grpcnt</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property name="dataType">any</property>
<simple-property-list name="aggregateOn">
<value>Order</value>
</simple-property-list>
<property name="aggregateFunction">count</property>
</structure>
</list-property>
<list-property name="sort">
<structure>
<expression
name="key">row["ORDERLINENUMBER"]</expression>
<property name="direction">asc</property>
</structure>
</list-property>
<column id="37">
<property name="width">1.0520833333in</property>
</column>
<column id="38">
<property name="width">1.1145833333in</property>
</column>
<column id="39"/>
<column id="40"/>
<column id="41"/>
<header>
<row id="9">
<property name="style">headerfooter</property>
<cell id="10">
<label id="11">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="12">
<label id="13">
<text-property
name="text">PRODUCTCODE</text-property>
</label>
</cell>
<cell id="14">
<label id="15">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
<cell id="16">
<label id="17">
<text-property
name="text">PRICEEACH</text-property>
</label>
</cell>
<cell id="18">
<label id="19">
<text-property
name="text">ORDERLINENUMBER</text-property>
</label>
</cell>
</row>
</header>
<group id="42">
<property name="groupName">Order</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ORDERNUMBER"]</expression>
<structure name="toc">
<expression name="expressionValue">"Order Number
"+row["ORDERNUMBER"]</expression>
<property name="TOCStyle">groupheader</property>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="43">
<expression
name="bookmark">row["ORDERNUMBER"]</expression>
<property name="style">groupheader</property>
<cell id="44"/>
<cell id="45"/>
<cell id="46"/>
<cell id="47"/>
<cell id="48"/>
</row>
<row id="120">
<property name="height">0.438in</property>
<expression
name="bookmark">row["ORDERNUMBER"]</expression>
<property name="style">groupheader</property>
<cell id="121">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<text id="80">
<property
name="contentType">html</property>
<text-property
name="content"><![CDATA[<form>
<script>
function hidetable(form, ord, rwcnt){

//alert( document.getElementById(ord).style.display );


var hide = false;
var btnstr = "mybutton"+ord;

if( document.getElementById(ord).style.display == 'block' ||
document.getElementById(ord).style.display == ""){
document.getElementById(ord).style.display = 'none';
document.getElementById(btnstr).value = "+";
//form.btnstr.value = "+";
hide = true;
}else{
document.getElementById(ord).style.display = 'block';
document.getElementById(btnstr).value = "-";
//form.btnstr.value = "-";
hide = false;
}
for( i=1; i<= rwcnt; i++ ){
var drow = ord+""+i;
if( document.getElementById(drow)){
if( hide ){
document.getElementById(drow).style.display = 'none';
}else{
document.getElementById(drow).style.display = 'block';
}
}
}



}

</script>

<INPUT Type="BUTTON"
name=<VALUE-OF>"mybutton"+row["ORDERNUMBER"]</VALUE-OF > Value="-"
onClick='hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
<VALUE-OF>row["Aggregation"]</VALUE-OF> )'></INPUT>
<VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>
<script>
hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
<VALUE-OF>row["Aggregation"]</VALUE-OF> );
</script>

</form>]]></text-property>
</text>
</cell>
<cell id="123">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
</cell>
</row>
</header>
<footer>
<row id="126">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression
name="valueExpr">true</expression>
</structure>
</list-property>
<cell id="127">
<label id="132">
<text-property name="text">This row is
hidden</text-property>
</label>
</cell>
<cell id="128"/>
<cell id="129"/>
<cell id="130"/>
<cell id="131">
<data id="113">
<property
name="resultSetColumn">Aggregation</property>
</data>
</cell>
</row>
</footer>
</group>
<detail>
<row id="100">
<expression name="bookmark">row["ORDERNUMBER"]+ ""
+row["ORDERLINENUMBER"];</expression>
<property name="style">detail</property>
<cell id="101">
<data id="81">
<property name="resultSetColumn">Column
Binding</property>
</data>
</cell>
<cell id="102">
<data id="24">
<property name="textAlign">center</property>
<property
name="resultSetColumn">PRODUCTCODE</property>
</data>
</cell>
<cell id="103">
<data id="26">
<property name="textAlign">center</property>
<property
name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
<cell id="104">
<data id="28">
<property name="textAlign">center</property>
<property
name="resultSetColumn">PRICEEACH</property>
</data>
</cell>
<cell id="105">
<data id="30">
<property name="textAlign">center</property>
<expression
name="bookmark">row["ORDERLINENUMBER"]</expression>
<property
name="resultSetColumn">ORDERLINENUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="31">
<property name="style">headerfooter</property>
<cell id="32"/>
<cell id="33"/>
<cell id="34"/>
<cell id="35"/>
<cell id="36"/>
</row>
</footer>
</table>
</body>
</report>


TY wrote:
> Hello,
> I tried the script below sent by Jason Weathersby. It works in birt
> designer, but it doesn't work with Internet Explorer 8. IE shows
> following error:
>
> document.getElementById(...)' is null or not an object.
> frameset
> Code:0
>
> i am using birt 2.3.2.2
>
> how can i fix this problem? Anyone can help me..
>
>
> Jason
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design";
> version="3.2.15" id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name
> here>></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <method
> name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
> "");]]></method>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="6">
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="7">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="nativeName">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="nativeName">PRICEEACH</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="nativeName">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">5</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from orderdetails
> </property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set1" id="59">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="nativeName">ORDERDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="nativeName">REQUIREDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="nativeName">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="nativeName">COMMENTS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from orders</property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="detail" id="56">
> <property name="backgroundColor">#BACAE2</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="headerfooter" id="57">
> <property name="backgroundColor">#004080</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> </style>
> <style name="groupheader" id="58">
> <property name="backgroundColor">#0080FF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="8">
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <expression name="expression">dataSetRow["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRODUCTCODE</property>
> <expression name="expression">dataSetRow["PRODUCTCODE"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">QUANTITYORDERED</property>
> <expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRICEEACH</property>
> <expression name="expression">dataSetRow["PRICEEACH"]</expression>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="name">ORDERLINENUMBER</property>
> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">Column Binding</property>
> <expression name="expression">importPackage(Packages.java.lang);
> reportContext.setPersistentGlobalVariable("rorder", new
> Integer(row["ORDERNUMBER"]));
> row["ORDERNUMBER"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">Aggregation</property>
> <property name="displayName">grpcnt</property>
> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
> <property name="dataType">any</property>
> <simple-property-list name="aggregateOn">
> <value>Order</value>
> </simple-property-list>
> <property name="aggregateFunction">count</property>
> </structure>
> </list-property>
> <list-property name="sort">
> <structure>
> <expression name="key">row["ORDERLINENUMBER"]</expression>
> <property name="direction">asc</property>
> </structure>
> </list-property>
> <column id="37">
> <property name="width">1.0520833333in</property>
> </column>
> <column id="38">
> <property name="width">1.1145833333in</property>
> </column>
> <column id="39"/>
> <column id="40"/>
> <column id="41"/>
> <header>
> <row id="9">
> <property name="style">headerfooter</property>
> <cell id="10">
> <label id="11">
> <text-property name="text">ORDERNUMBER</text-property>
> </label>
> </cell>
> <cell id="12">
> <label id="13">
> <text-property name="text">PRODUCTCODE</text-property>
> </label>
> </cell>
> <cell id="14">
> <label id="15">
> <text-property name="text">QUANTITYORDERED</text-property>
> </label>
> </cell>
> <cell id="16">
> <label id="17">
> <text-property name="text">PRICEEACH</text-property>
> </label>
> </cell>
> <cell id="18">
> <label id="19">
> <text-property name="text">ORDERLINENUMBER</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="42">
> <property name="groupName">Order</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["ORDERNUMBER"]</expression>
> <structure name="toc">
> <expression name="expressionValue">"Order Number
> "+row["ORDERNUMBER"]</expression>
> <property name="TOCStyle">groupheader</property>
> </structure>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <property name="pageBreakInside">auto</property>
> <header>
> <row id="43">
> <expression name="bookmark">row["ORDERNUMBER"]</expression>
> <property name="style">groupheader</property>
> <cell id="44"/>
> <cell id="45"/>
> <cell id="46"/>
> <cell id="47"/>
> <cell id="48"/>
> </row>
> <row id="120">
> <property name="height">0.438in</property>
> <expression name="bookmark">row["ORDERNUMBER"]</expression>
> <property name="style">groupheader</property>
> <cell id="121">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <text id="80">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<form>
> <script>
> function hidetable(form, ord, rwcnt){
>
> //alert( document.getElementById(ord).style.display );
>
>
>
> var hide = false;
> var btnstr = "mybutton"+ord;
>
>
> if( document.getElementById(ord).style.display == 'block' ||
> document.getElementById(ord).style.display == ""){
> document.getElementById(ord).style.display = 'none';
> document.getElementById(btnstr).value = "+";
> //form.btnstr.value = "+";
> hide = true;
> }else{
> document.getElementById(ord).style.display = 'block';
> document.getElementById(btnstr).value = "-";
> //form.btnstr.value = "-";
> hide = false;
> }
> for( i=1; i<= rwcnt; i++ ){
> var drow = ord+""+i;
> if( document.getElementById(drow)){
> if( hide ){
> document.getElementById(drow).style.display = 'none';
> }else{
> document.getElementById(drow).style.display = 'block';
> }
> }
> }
>
>
>
> }
>
>
> </script>
>
>
> <INPUT Type="BUTTON"
> name=<VALUE-OF>"mybutton"+row["ORDERNUMBER"]</VALUE-OF > Value="-"
> onClick='hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
> <VALUE-OF>row["Aggregation"]</VALUE-OF> )'></INPUT>
> <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>
> <script>
> hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
> <VALUE-OF>row["Aggregation"]</VALUE-OF> );
> </script>
>
> </form>]]></text-property>
> </text>
> </cell>
> <cell id="123">
> <property name="colSpan">3</property>
> <property name="rowSpan">1</property>
> </cell>
> </row>
> </header>
> <footer>
> <row id="126">
> <list-property name="visibility">
> <structure>
> <property name="format">all</property>
> <expression name="valueExpr">true</expression>
> </structure>
> </list-property>
> <cell id="127">
> <label id="132">
> <text-property name="text">This row is hidden</text-property>
> </label>
> </cell>
> <cell id="128"/>
> <cell id="129"/>
> <cell id="130"/>
> <cell id="131">
> <data id="113">
> <property name="resu
Re: Expand and Collapse Report Group [message #368766 is a reply to message #368765] Wed, 24 June 2009 15:46 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

I know this one works in IE 7

Jason

Jason Weathersby wrote:
> Can you try this one?
>
> Jason
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
> Name here>></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <method
> name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
> "");]]></method>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="6">
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="7">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="nativeName">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="nativeName">PRICEEACH</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="nativeName">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">5</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from orderdetails
> </property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set1" id="59">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">ORDERDATE</property>
> <property name="nativeName">ORDERDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">REQUIREDDATE</property>
> <property name="nativeName">REQUIREDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SHIPPEDDATE</property>
> <property name="nativeName">SHIPPEDDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">COMMENTS</property>
> <property name="nativeName">COMMENTS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from orders</property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="detail" id="56">
> <property name="backgroundColor">#BACAE2</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="paddingTop">0px</property>
> <property name="paddingLeft">0px</property>
> <property name="paddingBottom">0px</property>
> <property name="paddingRight">0px</property>
> </style>
> <style name="headerfooter" id="57">
> <property name="backgroundColor">#004080</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> </style>
> <style name="groupheader" id="58">
> <property name="backgroundColor">#0080FF</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="8">
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRODUCTCODE</property>
> <expression
> name="expression">dataSetRow["PRODUCTCODE"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">QUANTITYORDERED</property>
> <expression
> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">PRICEEACH</property>
> <expression
> name="expression">dataSetRow["PRICEEACH"]</expression>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="name">ORDERLINENUMBER</property>
> <expression
> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="name">Column Binding</property>
> <expression
> name="expression">importPackage(Packages.java.lang);
> reportContext.setPersistentGlobalVariable("rorder", new
> Integer(row["ORDERNUMBER"]));
> row["ORDERNUMBER"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">Aggregation</property>
> <property name="displayName">grpcnt</property>
> <expression
> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
> <property name="dataType">any</property>
> <simple-property-list name="aggregateOn">
> <value>Order</value>
> </simple-property-list>
> <property name="aggregateFunction">count</property>
> </structure>
> </list-property>
> <list-property name="sort">
> <structure>
> <expression
> name="key">row["ORDERLINENUMBER"]</expression>
> <property name="direction">asc</property>
> </structure>
> </list-property>
> <column id="37">
> <property name="width">1.0520833333in</property>
> </column>
> <column id="38">
> <property name="width">1.1145833333in</property>
> </column>
> <column id="39"/>
> <column id="40"/>
> <column id="41"/>
> <header>
> <row id="9">
> <property name="style">headerfooter</property>
> <cell id="10">
> <label id="11">
> <text-property
> name="text">ORDERNUMBER</text-property>
> </label>
> </cell>
> <cell id="12">
> <label id="13">
> <text-property
> name="text">PRODUCTCODE</text-property>
> </label>
> </cell>
> <cell id="14">
> <label id="15">
> <text-property
> name="text">QUANTITYORDERED</text-property>
> </label>
> </cell>
> <cell id="16">
> <label id="17">
> <text-property
> name="text">PRICEEACH</text-property>
> </label>
> </cell>
> <cell id="18">
> <label id="19">
> <text-property
> name="text">ORDERLINENUMBER</text-property>
> </label>
> </cell>
> </row>
> </header>
> <group id="42">
> <property name="groupName">Order</property>
> <property name="interval">none</property>
> <property name="sortDirection">asc</property>
> <expression name="keyExpr">row["ORDERNUMBER"]</expression>
> <structure name="toc">
> <expression name="expressionValue">"Order Number
> "+row["ORDERNUMBER"]</expression>
> <property name="TOCStyle">groupheader</property>
> </structure>
> <property name="repeatHeader">true</property>
> <property name="hideDetail">false</property>
> <property name="pageBreakAfter">auto</property>
> <property name="pageBreakBefore">auto</property>
> <property name="pageBreakInside">auto</property>
> <header>
> <row id="43">
> <expression
> name="bookmark">row["ORDERNUMBER"]</expression>
> <property name="style">groupheader</property>
> <cell id="44"/>
> <cell id="45"/>
> <cell id="46"/>
> <cell id="47"/>
> <cell id="48"/>
> </row>
> <row id="120">
> <property name="height">0.438in</property>
> <expression
> name="bookmark">row["ORDERNUMBER"]</expression>
> <property name="style">groupheader</property>
> <cell id="121">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <text id="80">
> <property
> name="contentType">html</property>
> <text-property
> name="content"><![CDATA[<form>
> <script>
> function hidetable(form, ord, rwcnt){
>
> //alert( document.getElementById(ord).style.display );
>
>
> var hide = false;
> var btnstr = "mybutton"+ord;
>
> if( document.getElementById(ord).style.display == 'block' ||
> document.getElementById(ord).style.display == ""){
> document.getElementById(ord).style.display = 'none';
> document.getElementById(btnstr).value = "+";
> //form.btnstr.value = "+";
> hide = true;
> }else{
> document.getElementById(ord).style.display = 'block';
> document.getElementById(btnstr).value = "-";
> //form.btnstr.value = "-";
> hide = false;
> }
> for( i=1; i<= rwcnt; i++ ){
> var drow = ord+""+i;
> if( document.getElementById(drow)){
> if( hide ){
> document.getElementById(drow).style.display = 'none';
> }else{
> document.getElementById(drow).style.display = 'block';
> }
> }
> }
>
>
>
> }
>
> </script>
>
> <INPUT Type="BUTTON"
> name=<VALUE-OF>"mybutton"+row["ORDERNUMBER"]</VALUE-OF > Value="-"
> onClick='hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
> <VALUE-OF>row["Aggregation"]</VALUE-OF> )'></INPUT>
> <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>
> <script>
> hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
> <VALUE-OF>row["Aggregation"]</VALUE-OF> );
> </script>
>
> </form>]]></text-property>
> </text>
> </cell>
> <cell id="123">
> <property name="colSpan">3</property>
> <property name="rowSpan">1</property>
> </cell>
> </row>
> </header>
> <footer>
> <row id="126">
> <list-property name="visibility">
> <structure>
> <property name="format">all</property>
> <expression
> name="valueExpr">true</expression>
> </structure>
> </list-property>
> <cell id="127">
> <label id="132">
> <text-property name="text">This row is
> hidden</text-property>
> </label>
> </cell>
> <cell id="128"/>
> <cell id="129"/>
> <cell id="130"/>
> <cell id="131">
> <data id="113">
> <property
> name="resultSetColumn">Aggregation</property>
> </data>
> </cell>
> </row>
> </footer>
> </group>
> <detail>
> <row id="100">
> <expression name="bookmark">row["ORDERNUMBER"]+ ""
> +row["ORDERLINENUMBER"];</expression>
> <property name="style">detail</property>
> <cell id="101">
> <data id="81">
> <property name="resultSetColumn">Column
> Binding</property>
> </data>
> </cell>
> <cell id="102">
> <data id="24">
> <property name="textAlign">center</property>
> <property
> name="resultSetColumn">PRODUCTCODE</property>
> </data>
> </cell>
> <cell id="103">
> <data id="26">
> <property name="textAlign">center</property>
> <property
> name="resultSetColumn">QUANTITYORDERED</property>
> </data>
> </cell>
> <cell id="104">
> <data id="28">
> <property name="textAlign">center</property>
> <property
> name="resultSetColumn">PRICEEACH</property>
> </data>
> </cell>
> <cell id="105">
> <data id="30">
> <property name="textAlign">center</property>
> <expression
> name="bookmark">row["ORDERLINENUMBER"]</expression>
> <property
> name="resultSetColumn">ORDERLINENUMBER</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="31">
> <property name="style">headerfooter</property>
> <cell id="32"/>
> <cell id="33"/>
> <cell id="34"/>
> <cell id="35"/>
> <cell id="36"/>
> </row>
> </footer>
> </table>
> </body>
> </report>
>
>
> TY wrote:
>> Hello,
>> I tried the script below sent by Jason Weathersby. It works in birt
>> designer, but it doesn't work with Internet Explorer 8. IE shows
>> following error:
>>
>> document.getElementById(...)' is null or not an object.
>> frameset
>> Code:0
>>
>> i am using birt 2.3.2.2
>>
>> how can i fix this problem? Anyone can help me..
>>
>>
>> Jason
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design";
>> version="3.2.15" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>> <property name="units">in</property>
>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name
>> here>></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <method
>> name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
>> "");]]></method>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <data-sources>
>> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
>> name="Data Source" id="6">
>> <property
>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>
>> <property name="odaURL">jdbc:classicmodels:sampledb</property>
>> <property name="odaUser">ClassicModels</property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="7">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="nativeName">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property name="nativeName">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="nativeName">PRICEEACH</property>
>> <property name="dataType">float</property>
>> <property name="nativeDataType">8</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</property>
>> <property name="nativeName">ORDERLINENUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">5</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from orderdetails
>> </property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set1" id="59">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="nativeName">ORDERDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="nativeName">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="nativeName">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="nativeName">STATUS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="nativeName">COMMENTS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="nativeName">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from orders</property>
>> </oda-data-set>
>> </data-sets>
>> <styles>
>> <style name="crosstab" id="4">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="detail" id="56">
>> <property name="backgroundColor">#BACAE2</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="paddingTop">0px</property>
>> <property name="paddingLeft">0px</property>
>> <property name="paddingBottom">0px</property>
>> <property name="paddingRight">0px</property>
>> </style>
>> <style name="headerfooter" id="57">
>> <property name="backgroundColor">#004080</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFFF</property>
>> </style>
>> <style name="groupheader" id="58">
>> <property name="backgroundColor">#0080FF</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFFF</property>
>> <property name="borderBottomColor">#FFFFFF</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderTopColor">#FFFFFF</property>
>> <property name="borderTopStyle">solid</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="8">
>> <property name="width">100%</property>
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">ORDERNUMBER</property>
>> <expression name="expression">dataSetRow["ORDERNUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRODUCTCODE</property>
>> <expression name="expression">dataSetRow["PRODUCTCODE"]</expression >
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="name">QUANTITYORDERED</property>
>> <expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRICEEACH</property>
>> <expression name="expression">dataSetRow["PRICEEACH"]</expression>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="name">ORDERLINENUMBER</property>
>> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">Column Binding</property>
>> <expression name="expression">importPackage(Packages.java.lang);
>> reportContext.setPersistentGlobalVariable("rorder", new
>> Integer(row["ORDERNUMBER"]));
>> row["ORDERNUMBER"]</expression>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="name">Aggregation</property>
>> <property name="displayName">grpcnt</property>
>> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>> <property name="dataType">any</property>
>> <simple-property-list name="aggregateOn">
>> <value>Order</value>
>> </simple-property-list>
>> <property name="aggregateFunction">count</property>
>> </structure>
>> </list-property>
>> <list-property name="sort">
>> <structure>
>> <expression name="key">row["ORDERLINENUMBER"]</expression>
>> <property name="direction">asc</property>
>> </structure>
>> </list-property>
>> <column id="37">
>> <property name="width">1.0520833333in</property>
>> </column>
>> <column id="38">
>> <property name="width">1.1145833333in</property>
>> </column>
>> <column id="39"/>
>> <column id="40"/>
>> <column id="41"/>
>> <header>
>> <row id="9">
>> <property name="style">headerfooter</property>
>> <cell id="10">
>> <label id="11">
>> <text-property name="text">ORDERNUMBER</text-property>
>> </label>
>> </cell>
>> <cell id="12">
>> <label id="13">
>> <text-property name="text">PRODUCTCODE</text-property>
>> </label>
>> </cell>
>> <cell id="14">
>> <label id="15">
>> <text-property name="text">QUANTITYORDERED</text-property>
>> </label>
>> </cell>
>> <cell id="16">
>> <label id="17">
>> <text-property name="text">PRICEEACH</text-property>
>> </label>
>> </cell>
>> <cell id="18">
>> <label id="19">
>> <text-property name="text">ORDERLINENUMBER</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <group id="42">
>> <property name="groupName">Order</property>
>> <property name="interval">none</property>
>> <property name="sortDirection">asc</property>
>> <expression name="keyExpr">row["ORDERNUMBER"]</expression>
>> <structure name="toc">
>> <expression name="expressionValue">"Order Number
>> "+row["ORDERNUMBER"]</expression>
>> <property name="TOCStyle">groupheader</property>
>> </structure>
>> <property name="repeatHeader">true</property>
>> <property name="hideDetail">false</property>
>> <property name="pageBreakAfter">auto</property>
>> <property name="pageBreakBefore">auto</property>
>> <property name="pageBreakInside">auto</property>
>> <header>
>> <row id="43">
>> <expression name="bookmark">row["ORDERNUMBER"]</expression>
>> <property name="style">groupheader</property>
>> <cell id="44"/>
>> <cell id="45"/>
>> <cell id="46"/>
>> <cell id="47"/>
Re: Expand and Collapse Report Group [message #368772 is a reply to message #368766] Wed, 24 June 2009 16:41 Go to previous message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

I just tried on IE 8 and it worked.

Jason Weathersby wrote:
> I know this one works in IE 7
>
> Jason
>
> Jason Weathersby wrote:
>> Can you try this one?
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.15" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>> <property name="units">in</property>
>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
>> Name here>></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <method
>> name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
>> "");]]></method>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
>> id="6">
>> <property
>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>
>> <property
>> name="odaURL">jdbc:classicmodels:sampledb</property>
>> <property name="odaUser">ClassicModels</property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="7">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">PRODUCTCODE</property>
>> <property name="nativeName">PRODUCTCODE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">QUANTITYORDERED</property>
>> <property
>> name="nativeName">QUANTITYORDERED</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">PRICEEACH</property>
>> <property name="nativeName">PRICEEACH</property>
>> <property name="dataType">float</property>
>> <property name="nativeDataType">8</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">ORDERLINENUMBER</property>
>> <property
>> name="nativeName">ORDERLINENUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">5</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from orderdetails
>> </property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set1" id="59">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Data Source</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="nativeName">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">ORDERDATE</property>
>> <property name="nativeName">ORDERDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">REQUIREDDATE</property>
>> <property name="nativeName">REQUIREDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">SHIPPEDDATE</property>
>> <property name="nativeName">SHIPPEDDATE</property>
>> <property name="dataType">date</property>
>> <property name="nativeDataType">91</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">STATUS</property>
>> <property name="nativeName">STATUS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">COMMENTS</property>
>> <property name="nativeName">COMMENTS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">CUSTOMERNUMBER</property>
>> <property name="nativeName">CUSTOMERNUMBER</property>
>> <property name="dataType">integer</property>
>> <property name="nativeDataType">4</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from orders</property>
>> </oda-data-set>
>> </data-sets>
>> <styles>
>> <style name="crosstab" id="4">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="detail" id="56">
>> <property name="backgroundColor">#BACAE2</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="paddingTop">0px</property>
>> <property name="paddingLeft">0px</property>
>> <property name="paddingBottom">0px</property>
>> <property name="paddingRight">0px</property>
>> </style>
>> <style name="headerfooter" id="57">
>> <property name="backgroundColor">#004080</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFFF</property>
>> </style>
>> <style name="groupheader" id="58">
>> <property name="backgroundColor">#0080FF</property>
>> <property name="fontFamily">"Arial"</property>
>> <property name="fontSize">small</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#FFFFFF</property>
>> <property name="borderBottomColor">#FFFFFF</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderTopColor">#FFFFFF</property>
>> <property name="borderTopStyle">solid</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property
>> name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="8">
>> <property name="width">100%</property>
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">ORDERNUMBER</property>
>> <expression
>> name="expression">dataSetRow["ORDERNUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRODUCTCODE</property>
>> <expression
>> name="expression">dataSetRow["PRODUCTCODE"]</expression >
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="name">QUANTITYORDERED</property>
>> <expression
>> name="expression">dataSetRow["QUANTITYORDERED"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">PRICEEACH</property>
>> <expression
>> name="expression">dataSetRow["PRICEEACH"]</expression>
>> <property name="dataType">float</property>
>> </structure>
>> <structure>
>> <property name="name">ORDERLINENUMBER</property>
>> <expression
>> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> <structure>
>> <property name="name">Column Binding</property>
>> <expression
>> name="expression">importPackage(Packages.java.lang);
>> reportContext.setPersistentGlobalVariable("rorder", new
>> Integer(row["ORDERNUMBER"]));
>> row["ORDERNUMBER"]</expression>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="name">Aggregation</property>
>> <property name="displayName">grpcnt</property>
>> <expression
>> name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>> <property name="dataType">any</property>
>> <simple-property-list name="aggregateOn">
>> <value>Order</value>
>> </simple-property-list>
>> <property name="aggregateFunction">count</property>
>> </structure>
>> </list-property>
>> <list-property name="sort">
>> <structure>
>> <expression
>> name="key">row["ORDERLINENUMBER"]</expression>
>> <property name="direction">asc</property>
>> </structure>
>> </list-property>
>> <column id="37">
>> <property name="width">1.0520833333in</property>
>> </column>
>> <column id="38">
>> <property name="width">1.1145833333in</property>
>> </column>
>> <column id="39"/>
>> <column id="40"/>
>> <column id="41"/>
>> <header>
>> <row id="9">
>> <property name="style">headerfooter</property>
>> <cell id="10">
>> <label id="11">
>> <text-property
>> name="text">ORDERNUMBER</text-property>
>> </label>
>> </cell>
>> <cell id="12">
>> <label id="13">
>> <text-property
>> name="text">PRODUCTCODE</text-property>
>> </label>
>> </cell>
>> <cell id="14">
>> <label id="15">
>> <text-property
>> name="text">QUANTITYORDERED</text-property>
>> </label>
>> </cell>
>> <cell id="16">
>> <label id="17">
>> <text-property
>> name="text">PRICEEACH</text-property>
>> </label>
>> </cell>
>> <cell id="18">
>> <label id="19">
>> <text-property
>> name="text">ORDERLINENUMBER</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <group id="42">
>> <property name="groupName">Order</property>
>> <property name="interval">none</property>
>> <property name="sortDirection">asc</property>
>> <expression
>> name="keyExpr">row["ORDERNUMBER"]</expression>
>> <structure name="toc">
>> <expression name="expressionValue">"Order Number
>> "+row["ORDERNUMBER"]</expression>
>> <property name="TOCStyle">groupheader</property>
>> </structure>
>> <property name="repeatHeader">true</property>
>> <property name="hideDetail">false</property>
>> <property name="pageBreakAfter">auto</property>
>> <property name="pageBreakBefore">auto</property>
>> <property name="pageBreakInside">auto</property>
>> <header>
>> <row id="43">
>> <expression
>> name="bookmark">row["ORDERNUMBER"]</expression>
>> <property name="style">groupheader</property>
>> <cell id="44"/>
>> <cell id="45"/>
>> <cell id="46"/>
>> <cell id="47"/>
>> <cell id="48"/>
>> </row>
>> <row id="120">
>> <property name="height">0.438in</property>
>> <expression
>> name="bookmark">row["ORDERNUMBER"]</expression>
>> <property name="style">groupheader</property>
>> <cell id="121">
>> <property name="colSpan">2</property>
>> <property name="rowSpan">1</property>
>> <text id="80">
>> <property
>> name="contentType">html</property>
>> <text-property
>> name="content"><![CDATA[<form>
>> <script>
>> function hidetable(form, ord, rwcnt){
>>
>> //alert( document.getElementById(ord).style.display );
>>
>>
>> var hide = false;
>> var btnstr = "mybutton"+ord;
>>
>> if( document.getElementById(ord).style.display == 'block' ||
>> document.getElementById(ord).style.display == ""){
>> document.getElementById(ord).style.display = 'none';
>> document.getElementById(btnstr).value = "+";
>> //form.btnstr.value = "+";
>> hide = true;
>> }else{
>> document.getElementById(ord).style.display = 'block';
>> document.getElementById(btnstr).value = "-";
>> //form.btnstr.value = "-";
>> hide = false;
>> }
>> for( i=1; i<= rwcnt; i++ ){
>> var drow = ord+""+i;
>> if( document.getElementById(drow)){
>> if( hide ){
>> document.getElementById(drow).style.display = 'none';
>> }else{
>> document.getElementById(drow).style.display = 'block';
>> }
>> }
>> }
>>
>>
>>
>> }
>>
>> </script>
>>
>> <INPUT Type="BUTTON"
>> name=<VALUE-OF>"mybutton"+row["ORDERNUMBER"]</VALUE-OF > Value="-"
>> onClick='hidetable( this.form,
>> <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
>> <VALUE-OF>row["Aggregation"]</VALUE-OF> )'></INPUT>
>> <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>
>> <script>
>> hidetable( this.form, <VALUE-OF>row["ORDERNUMBER"]</VALUE-OF>,
>> <VALUE-OF>row["Aggregation"]</VALUE-OF> );
>> </script>
>>
>> </form>]]></text-property>
>> </text>
>> </cell>
>> <cell id="123">
>> <property name="colSpan">3</property>
>> <property name="rowSpan">1</property>
>> </cell>
>> </row>
>> </header>
>> <footer>
>> <row id="126">
>> <list-property name="visibility">
>> <structure>
>> <property name="format">all</property>
>> <expression
>> name="valueExpr">true</expression>
>> </structure>
>> </list-property>
>> <cell id="127">
>> <label id="132">
>> <text-property name="text">This row is
>> hidden</text-property>
>> </label>
>> </cell>
>> <cell id="128"/>
>> <cell id="129"/>
>> <cell id="130"/>
>> <cell id="131">
>> <data id="113">
>> <property
>> name="resultSetColumn">Aggregation</property>
>> </data>
>> </cell>
>> </row>
>> </footer>
>> </group>
>> <detail>
>> <row id="100">
>> <expression name="bookmark">row["ORDERNUMBER"]+ ""
>> +row["ORDERLINENUMBER"];</expression>
>> <property name="style">detail</property>
>> <cell id="101">
>> <data id="81">
>> <property name="resultSetColumn">Column
>> Binding</property>
>> </data>
>> </cell>
>> <cell id="102">
>> <data id="24">
>> <property name="textAlign">center</property>
>> <property
>> name="resultSetColumn">PRODUCTCODE</property>
>> </data>
>> </cell>
>> <cell id="103">
>> <data id="26">
>> <property name="textAlign">center</property>
>> <property
>> name="resultSetColumn">QUANTITYORDERED</property>
>> </data>
>> </cell>
>> <cell id="104">
>> <data id="28">
>> <property name="textAlign">center</property>
>> <property
>> name="resultSetColumn">PRICEEACH</property>
>> </data>
>> </cell>
>> <cell id="105">
>> <data id="30">
>> <property name="textAlign">center</property>
>> <expression
>> name="bookmark">row["ORDERLINENUMBER"]</expression>
>> <property
>> name="resultSetColumn">ORDERLINENUMBER</property>
>> </data>
>> </cell>
>> </row>
>> </detail>
>> <footer>
>> <row id="31">
>> <property name="style">headerfooter</property>
>> <cell id="32"/>
>> <cell id="33"/>
>> <cell id="34"/>
>> <cell id="35"/>
>> <cell id="36"/>
>> </row>
>> </footer>
>> </table>
>> </body>
>> </report>
>>
>>
>> TY wrote:
>>> Hello,
>>> I tried the script below sent by Jason Weathersby. It works in birt
>>> designer, but it doesn't work with Internet Explorer 8. IE shows
>>> following error:
>>>
>>> document.getElementById(...)' is null or not an object.
>>> frameset
>>> Code:0
>>>
>>> i am using birt 2.3.2.2
>>>
>>> how can i fix this problem? Anyone can help me..
>>>
>>>
>>> Jason
>>>
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <report xmlns="http://www.eclipse.org/birt/2005/design";
>>> version="3.2.15" id="1">
>>> <property name="createdBy">Eclipse BIRT Designer Version
>>> 2.2.1.r221_v20070924 Build &lt;2.2.0.v20070924-1550></property>
>>> <property name="units">in</property>
>>> <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
>>> Name here>></property>
>>> <html-property name="description">Creates a blank report with no
>>> predefined content.</html-property>
>>> <method
>>> name="beforeFactory"><![CDATA[reportContext.setPersistentGlobalVariable( "rorder",
>>> "");]]></method>
>>> <text-property name="displayName">Blank Report</text-property>
>>> <property name="iconFile">/templates/blank_report.gif</property>
>>> <data-sources>
>>> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
>>> name="Data Source" id="6">
>>> <property
>>> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>>>
>>> <property name="odaURL">jdbc:classicmodels:sampledb</property>
>>> <property name="odaUser">ClassicModels</property>
>>> </oda-data-source>
>>> </data-sources>
>>> <data-sets>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="7">
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">PRODUCTCODE</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">QUANTITYORDERED</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">PRICEEACH</property>
>>> <property name="dataType">float</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">ORDERLINENUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> </structure>
>>> <property name="dataSource">Data Source</property>
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="nativeName">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">PRODUCTCODE</property>
>>> <property name="nativeName">PRODUCTCODE</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">QUANTITYORDERED</property>
>>> <property name="nativeName">QUANTITYORDERED</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">PRICEEACH</property>
>>> <property name="nativeName">PRICEEACH</property>
>>> <property name="dataType">float</property>
>>> <property name="nativeDataType">8</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">ORDERLINENUMBER</property>
>>> <property name="nativeName">ORDERLINENUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">5</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select *
>>> from orderdetails
>>> </property>
>>> </oda-data-set>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set1" id="59">
>>> <structure name="cachedMetaData">
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">ORDERDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">REQUIREDDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">SHIPPEDDATE</property>
>>> <property name="dataType">date</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">STATUS</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">6</property>
>>> <property name="name">COMMENTS</property>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="position">7</property>
>>> <property name="name">CUSTOMERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> </structure>
>>> </list-property>
>>> </structure>
>>> <property name="dataSource">Data Source</property>
>>> <list-property name="resultSet">
>>> <structure>
>>> <property name="position">1</property>
>>> <property name="name">ORDERNUMBER</property>
>>> <property name="nativeName">ORDERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> <structure>
>>> <property name="position">2</property>
>>> <property name="name">ORDERDATE</property>
>>> <property name="nativeName">ORDERDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">3</property>
>>> <property name="name">REQUIREDDATE</property>
>>> <property name="nativeName">REQUIREDDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">4</property>
>>> <property name="name">SHIPPEDDATE</property>
>>> <property name="nativeName">SHIPPEDDATE</property>
>>> <property name="dataType">date</property>
>>> <property name="nativeDataType">91</property>
>>> </structure>
>>> <structure>
>>> <property name="position">5</property>
>>> <property name="name">STATUS</property>
>>> <property name="nativeName">STATUS</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">6</property>
>>> <property name="name">COMMENTS</property>
>>> <property name="nativeName">COMMENTS</property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">12</property>
>>> </structure>
>>> <structure>
>>> <property name="position">7</property>
>>> <property name="name">CUSTOMERNUMBER</property>
>>> <property name="nativeName">CUSTOMERNUMBER</property>
>>> <property name="dataType">integer</property>
>>> <property name="nativeDataType">4</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select *
>>> from orders</property>
>>> </oda-data-set>
>>> </data-sets>
>>> <styles>
>>> <style name="crosstab" id="4">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="crosstab-cell" id="5">
>>> <property name="borderBottomColor">#CCCCCC</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderBottomWidth">1pt</property>
>>> <property name="borderLeftColor">#CCCCCC</property>
>>> <property name="borderLeftStyle">solid</property>
>>> <property name="borderLeftWidth">1pt</property>
>>> <property name="borderRightColor">#CCCCCC</property>
>>> <property name="borderRightStyle">solid</property>
>>> <property name="borderRightWidth">1pt</property>
>>> <property name="borderTopColor">#CCCCCC</property>
>>> <property name="borderTopStyle">solid</property>
>>> <property name="borderTopWidth">1pt</property>
>>> </style>
>>> <style name="detail" id="56">
>>> <property name="backgroundColor">#BACAE2</property>
>>> <property name="fontFamily">"Arial"</property>
>>> <property name="fontSize">small</property>
>>> <property name="paddingTop">0px</property>
>>> <property name="paddingLeft">0px</property>
>>> <property name="paddingBottom">0px</property>
>>> <property name="paddingRight">0px</property>
>>> </style>
>>> <style name="headerfooter" id="57">
>>> <property name="backgroundColor">#004080</property>
>>> <property name="fontFamily">"Arial"</property>
>>> <property name="fontSize">small</property>
>>> <property name="fontWeight">bold</property>
>>> <property name="color">#FFFFFF</property>
>>> </style>
>>> <style name="groupheader" id="58">
>>> <property name="backgroundColor">#0080FF</property>
>>> <property name="fontFamily">"Arial"</property>
>>> <property name="fontSize">small</property>
>>> <property name="fontWeight">bold</property>
>>> <property name="color">#FFFFFF</property>
>>> <property name="borderBottomColor">#FFFFFF</property>
>>> <property name="borderBottomStyle">solid</property>
>>> <property name="borderTopColor">#FFFFFF</property>
>>> <property name="borderTopStyle">solid</property>
>>> </style>
>>> </styles>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <page-footer>
>>> <text id="3">
>>> <property name="contentType">html</property>
>>> <text-property name="content"><![CDATA[<value-of>new
>>> Date()</value-of>]]></text-property>
>>> </text>
>>> </page-footer>
>>> </simple-master-page>
>>> </page-setup>
>>> <body>
>>> <table id="8">
>>> <property name="width">100%</property>
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property name="name">ORDERNUMBER</property>
>>> <expression name="expression">dataSetRow["ORDERNUMBER"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">PRODUCTCODE</property>
>>> <expression name="expression">dataSetRow["PRODUCTCODE"]</expression >
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="name">QUANTITYORDERED</property>
>>> <expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">PRICEEACH</property>
>>> <expression name="expression">dataSetRow["PRICEEACH"]</expression>
>>> <property name="dataType">float</property>
>>> </structure>
>>> <structure>
>>> <property name="name">ORDERLINENUMBER</property>
>>> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>>> <property name="dataType">integer</property>
>>> </structure>
>>> <structure>
>>> <property name="name">Column Binding</property>
>>> <expression name="expression">importPackage(Packages.java.lang);
>>> reportContext.setPersistentGlobalVariable("rorder", new
>>> Integer(row["ORDERNUMBER"]));
>>> row["ORDERNUMBER"]</expression>
>>> <property name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property name="name">Aggregation</property>
>>> <property name="displayName">grpcnt</property>
>>> <expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
>>> <property name="dataType">any</property>
>>> <simple-property-list name="aggregateOn">
>>> <value>Order</value>
>>> </simple-property-list>
>>> <property name="aggregateFunction">count</property>
>>> </structure>
>>> </list-property>
>>> <list-property name="sort">
>>> <structure>
>>> <expression name="key">row["ORDERLIN
Previous Topic:Draw line, rectangle etc..
Next Topic:BIRT 2.3.2 Source Code Available?
Goto Forum:
  


Current Time: Fri Mar 29 10:46:09 GMT 2024

Powered by FUDForum. Page generated in 0.03759 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top