nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Collapse functionality in Crosstab BIRT 2.2.1

philip88 · 2011-06-21T10:35:58+00:00

Hi, Am using BIRT 2.2.1(Not able to upgrade - due to client requirement) Is there any way to use Expand/Collapse functionality in "Crosstab" Please find the attachments explaining the requirement :- 1 (All Collapsed) :- I need to have all the group rows Collapsed. 2…

philip88

Hi, 
 
Am using BIRT 2.2.1(Not able to upgrade - due to client requirement) 
 
Is there any way to use Expand/Collapse functionality in "Crosstab" 
 
Please find the attachments explaining the requirement :- 
 
1 (All Collapsed) :- I need to have all the group rows Collapsed. 
2 (All Group Expandes):- i Should also be able to Expand all Group rows. 
3 (One Group Expand) :- I Should be able to expand one by one. 
 
 
Unable to attach the report (Upload failed) Hence pasting the XML Source 
 
 
 
 
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>XML SOURCE<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 
 
 
 
 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.15" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 2.2.1.r22a_v20071101 Build <2.2.1.v20071101-1439></property> 
<property name="units">in</property> 
<property name="comments">Copyright (c) 2007 <<Your Company Name here>></property> 
<html-property name="description">Creates a blank report with no predefined content.</html-property> 
<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="195"> 
<list-property name="columnHints"> 
<structure> 
<property name="columnName">ORDERNUMBER</property> 
<property name="displayName">ORDERNUMBER</property> 
</structure> 
<structure> 
<property name="columnName">ORDERDATE</property> 
<property name="displayName">ORDERDATE</property> 
</structure> 
<structure> 
<property name="columnName">STATUS</property> 
<property name="displayName">STATUS</property> 
</structure> 
</list-property> 
<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">STATUS</property> 
<property name="dataType">string</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">STATUS</property> 
<property name="nativeName">STATUS</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
</list-property> 
<property name="queryText">select CLASSICMODELS.ORDERS.ORDERNUMBER, 
CLASSICMODELS.ORDERS.ORDERDATE, 
CLASSICMODELS.ORDERS.STATUS 
from CLASSICMODELS.ORDERS</property> 
</oda-data-set> 
</data-sets> 
<cubes> 
<tabular-cube name="Data Cube" id="196"> 
<property name="defaultMeasureGroup">Summary Field</property> 
<property name="dimensions"> 
<tabular-dimension name="Group" id="199"> 
<property name="isTimeType">true</property> 
<property name="defaultHierarchy">NewTabularHierarchy</property> 
<property name="hierarchies"> 
<tabular-hierarchy name="NewTabularHierarchy" id="200"> 
<property name="levels"> 
<tabular-level name="year" id="201"> 
<property name="dataType">integer</property> 
<property name="dateTimeLevelType">year</property> 
<list-property name="attributes"> 
<structure> 
<property name="name">DateTime</property> 
<property name="dataType">date-time</property> 
</structure> 
</list-property> 
<property name="columnName">ORDERDATE</property> 
</tabular-level> 
<tabular-level name="quarter" id="202"> 
<property name="dataType">integer</property> 
<property name="dateTimeLevelType">quarter</property> 
<list-property name="attributes"> 
<structure> 
<property name="name">DateTime</property> 
<property name="dataType">date-time</property> 
</structure> 
</list-property> 
<property name="columnName">ORDERDATE</property> 
</tabular-level> 
</property> 
</tabular-hierarchy> 
</property> 
</tabular-dimension> 
<tabular-dimension name="Group1" id="252"> 
<property name="isTimeType">true</property> 
<property name="defaultHierarchy">NewTabularHierarchy1</property> 
<property name="hierarchies"> 
<tabular-hierarchy name="NewTabularHierarchy1" id="253"> 
<property name="levels"> 
<tabular-level name="month" id="254"> 
<property name="dataType">integer</property> 
<property name="dateTimeLevelType">month</property> 
<list-property name="attributes"> 
<structure> 
<property name="name">DateTime</property> 
<property name="dataType">date-time</property> 
</structure> 
</list-property> 
<property name="columnName">ORDERDATE</property> 
</tabular-level> 
</property> 
</tabular-hierarchy> 
</property> 
</tabular-dimension> 
</property> 
<property name="measureGroups"> 
<tabular-measure-group name="Summary Field" id="197"> 
<property name="measures"> 
<tabular-measure name="ORDERNUMBER" id="198"> 
<property name="function">count</property> 
<property name="dataType">integer</property> 
</tabular-measure> 
</property> 
</tabular-measure-group> 
</property> 
<property name="dataSet">Data Set</property> 
</tabular-cube> 
</cubes> 
<styles> 
<style name="crosstab-cell" 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" 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> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<property name="orientation">landscape</property> 
<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> 
<extended-item extensionName="Crosstab" id="203"> 
<property name="measures"> 
<extended-item extensionName="MeasureView" id="204"> 
<property name="measure">ORDERNUMBER</property> 
<property name="detail"> 
<extended-item extensionName="CrosstabCell" id="205"> 
<property name="content"> 
<data name="ORDERNUMBER" id="207"> 
<property name="fontSize">small</property> 
<property name="resultSetColumn">ORDERNUMBER</property> 
</data> 
</property> 
</extended-item> 
</property> 
<property name="aggregations"> 
<extended-item extensionName="AggregationCell" id="258"> 
<property name="aggregationOnRow">Group/year</property> 
<property name="aggregationOnColumn">Group1/month</property> 
<property name="content"> 
<data id="259"> 
<property name="fontSize">small</property> 
<property name="resultSetColumn">ORDERNUMBER_Group/year_Group1/month</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="260"> 
<property name="aggregationOnColumn">Group1/month</property> 
<property name="content"> 
<data id="261"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="resultSetColumn">ORDERNUMBER_Group1/month</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="264"> 
<property name="aggregationOnRow">Group/year</property> 
<property name="content"> 
<data id="265"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="resultSetColumn">ORDERNUMBER_Group/year</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="266"> 
<property name="aggregationOnRow">Group/quarter</property> 
<property name="content"> 
<data id="267"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="resultSetColumn">ORDERNUMBER_Group/quarter</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="268"> 
<property name="content"> 
<data id="269"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="resultSetColumn">ORDERNUMBER_1</property> 
</data> 
</property> 
</extended-item> 
</property> 
<property name="header"> 
<extended-item extensionName="CrosstabCell" id="206"> 
<property name="content"> 
<label id="208"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="color">#0000A0</property> 
<text-property name="text">Order Number</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
<property name="rows"> 
<extended-item extensionName="CrosstabView" id="217"> 
<property name="grandTotal"> 
<extended-item extensionName="CrosstabCell" id="245"> 
<property name="content"> 
<label id="248"> 
<property name="fontWeight">bold</property> 
<text-property name="text">Grand Total</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
<property name="views"> 
<extended-item extensionName="DimensionView" id="218"> 
<property name="dimension">Group</property> 
<property name="levels"> 
<extended-item extensionName="LevelView" name="NewLevel View" id="219"> 
<property name="level">Group/year</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="220"> 
<property name="content"> 
<data name="year" id="221"> 
<property name="resultSetColumn">year</property> 
</data> 
</property> 
</extended-item> 
</property> 
<property name="aggregationHeader"> 
<extended-item extensionName="CrosstabCell" id="241"> 
<property name="content"> 
<label id="244"> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<text-property name="text">Total</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
</extended-item> 
<extended-item extensionName="LevelView" name="NewLevel View1" id="222"> 
<property name="level">Group/quarter</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="223"> 
<property name="content"> 
<data name="quarter" id="224"> 
<property name="fontWeight">bold</property> 
<property name="color">#0080C0</property> 
<method name="onCreate"><![CDATA[if (quarterLastYear == 0){ 
this.getParent().getStyle().backgroundColor = "gray"; 
quarterLastYear = data["year"]; 
} 
else if (quarterLastYear == data["year"]){ 
if(quarterColor==0){ 
this.getParent().getStyle().backgroundColor = "gray"; 
} 
else{ 
this.getParent().getStyle().backgroundColor = "white"; 
} 
} 
else{ 
quarterLastYear = data["year"]; 
if(quarterColor==0){ 
this.getParent().getStyle().backgroundColor = "white"; 
quarterColor=1; 
} 
else{ 
this.getParent().getStyle().backgroundColor = "gray"; 
quarterColor=0; 
} 
}]]></method> 
<property name="resultSetColumn">quarter</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
<property name="columns"> 
<extended-item extensionName="CrosstabView" id="209"> 
<property name="grandTotal"> 
<extended-item extensionName="CrosstabCell" id="263"> 
<property name="content"> 
<label id="270"> 
<property name="fontWeight">bold</property> 
<text-property name="text">Grand Total</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
<property name="views"> 
<extended-item extensionName="DimensionView" id="255"> 
<property name="dimension">Group1</property> 
<property name="levels"> 
<extended-item extensionName="LevelView" name="NewLevel View2" id="256"> 
<property name="level">Group1/month</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="257"> 
<property name="content"> 
<data name="month" id="262"> 
<property name="fontWeight">bold</property> 
<property name="resultSetColumn">month</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
<property name="cube">Data Cube</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">ORDERNUMBER</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">year</property> 
<expression name="expression">dimension["Group"]["year"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">quarter</property> 
<expression name="expression">dimension["Group"]["quarter"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERNUMBER_Group/year</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
<simple-property-list name="aggregateOn"> 
<value>Group/year</value> 
</simple-property-list> 
<property name="aggregateFunction">count</property> 
</structure> 
<structure> 
<property name="name">ORDERNUMBER_1</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
<property name="aggregateFunction">count</property> 
</structure> 
<structure> 
<property name="name">month</property> 
<expression name="expression">dimension["Group1"]["month"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERNUMBER_Group/year_Group1/month</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
<simple-property-list name="aggregateOn"> 
<value>Group/year</value> 
<value>Group1/month</value> 
</simple-property-list> 
<property name="aggregateFunction">count</property> 
</structure> 
<structure> 
<property name="name">ORDERNUMBER_Group1/month</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
<simple-property-list name="aggregateOn"> 
<value>Group1/month</value> 
</simple-property-list> 
<property name="aggregateFunction">count</property> 
</structure> 
<structure> 
<property name="name">ORDERNUMBER_Group/quarter</property> 
<expression name="expression">measure["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
<simple-property-list name="aggregateOn"> 
<value>Group/quarter</value> 
</simple-property-list> 
<property name="aggregateFunction">count</property> 
</structure> 
</list-property> 
</extended-item> 
</body> 
</report>

Find more posts tagged with

Comments

mwilliams

If you were to zip the file up, it would be able to be attached. This is probably possible. Not sure how easy it will be, but it'll have to be done with a drill through, most likely. Here's an example from the devShare on expanding and collapsing table groups that may be similar.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1242-expandablecollapsible-groups-by-drill-through/

philip88

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="78857" data-time="1308686108" data-date="21 June 2011 - 12:55 PM">
If you were to zip the file up, it would be able to be attached. This is probably possible. Not sure how easy it will be, but it'll have to be done with a drill through, most likely. Here's an example from the devShare on expanding and collapsing table groups that may be similar. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1242-expandablecollapsible-groups-by-drill-through/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1242-expandablecollapsible-groups-by-drill-through/</a> </blockquote>
 
William, 
 
Thanks for the quick response. 
I downloaded the Report but the report us designed using "List" 
I need collpase/expand functionality in "Crosstab" not in "List". 
Is it possible in Crosstab (BIRT Version = 2.2.1)

mwilliams

The report in the link I sent you was just to show the drill through and ideas to get you started. For a crosstab, it would be more difficult for sure. You'd have to drill through to the report passing the parameters of the section to "expand" and allow the data into your crosstab for that section so that it would expand with the data. You'd still have to bring in all the data to the report to be able to get the "total" lines for the collapsed groups. You probably won't be able to display this in the "total" in the same crosstab. I don't know that you'll get the exact look that you showed above, but I do think that this would probably be possible, but it'd take some work.