Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Set visibilty of crosstab cell?(Can hide data but cell outline still shows)
icon14.gif  Set visibilty of crosstab cell? [message #518890] Fri, 05 March 2010 11:39 Go to next message
Missing name Missing name is currently offline Missing name Missing nameFriend
Messages: 94
Registered: November 2009
Member
hi,
I'm trying to completely hide a row area cell in a crosstab. I use the data from this cell to create a hyperlink when the user clicks a row, but I dont actually want them to be able to see the cell data itself.
I have set the visibility to the data within the cell to be false so the data is hidden, but I cant seem to hide the outline of the cell, so I have a small empty space in the row. Is there any visibility setting for the cell itself?

Here is a report showing the issue, using the sample database

thanks
Trevor

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_v20090521 Build &lt;2.3.2.v20090601-0700></property>
<property name="units">in</property>
<text-property name="title">Give your title Here - fineos_UserProperties Template</text-property>
<html-property name="description">Holds definition for various fineos user defined properties</html-property>
<list-property name="userProperties">
<structure>
<property name="name">FINEOS_SecuredAction</property>
<property name="type">string</property>
<property name="isVisible">true</property>
</structure>
<structure>
<property name="name">FINEOS_JSPPage</property>
<property name="type">string</property>
<property name="isVisible">true</property>
</structure>
<structure>
<property name="name">FINEOS_WorkType</property>
<property name="type">string</property>
<property name="isVisible">true</property>
</structure>
<structure>
<property name="name">FINEOS_BackgroundRunOnly</property>
<property name="type">boolean</property>
<property name="isVisible">true</property>
</structure>
<structure>
<property name="name">FINEOS_NumDisplayColumns</property>
<property name="type">integer</property>
<property name="isVisible">true</property>
</structure>
</list-property>
<text-property name="displayName">Fineos User Properties</text-property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="124">
<text-property name="displayName"></text-property>
<property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
<property name="OdaConnProfileName"></property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set" id="125">
<list-property name="computedColumns">
<structure>
<property name="name">shortname</property>
<expression name="expression">row["ADDRESSLINE1"].substring(7)</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">OFFICECODE</property>
<property name="displayName">OFFICECODE</property>
</structure>
<structure>
<property name="columnName">CITY</property>
<property name="displayName">CITY</property>
</structure>
<structure>
<property name="columnName">PHONE</property>
<property name="displayName">PHONE</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE1</property>
<property name="displayName">ADDRESSLINE1</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE2</property>
<property name="displayName">ADDRESSLINE2</property>
</structure>
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<property name="displayName">COUNTRY</property>
</structure>
<structure>
<property name="columnName">POSTALCODE</property>
<property name="displayName">POSTALCODE</property>
</structure>
<structure>
<property name="columnName">TERRITORY</property>
<property name="displayName">TERRITORY</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICECODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">TERRITORY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">shortname</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">OFFICECODE</property>
<property name="nativeName">OFFICECODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">TERRITORY</property>
<property name="nativeName">TERRITORY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select *
from
offices
</property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="Data Cube - Data Set" id="128">
<property name="dimensions">
<tabular-dimension name="Group" id="129">
<property name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy" id="130">
<property name="levels">
<tabular-level name="CITY" id="131">
<property name="dataType">string</property>
<property name="columnName">CITY</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group1" id="132">
<property name="defaultHierarchy">NewTabularHierarchy1</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy1" id="133">
<property name="levels">
<tabular-level name="ADDRESSLINE1" id="134">
<property name="dataType">string</property>
<property name="columnName">ADDRESSLINE1</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group2" id="178">
<property name="defaultHierarchy">NewTabularHierarchy2</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy2" id="179">
<property name="levels">
<tabular-level name="shortname" id="180">
<property name="dataType">string</property>
<property name="columnName">shortname</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group3" id="185">
<property name="defaultHierarchy">NewTabularHierarchy3</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy3" id="186">
<property name="levels">
<tabular-level name="STATE" id="187">
<property name="dataType">string</property>
<property name="columnName">STATE</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="135">
<property name="measures">
<tabular-measure name="OFFICECODE" id="155">
<expression name="measureExpression">dataSetRow["OFFICECODE"]</expression >
<property name="dataType">string</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Data Set</property>
</tabular-cube>
</cubes>
<styles>
<style name="page" id="65">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="marginTop">10px</property>
<property name="marginLeft">10px</property>
<property name="marginBottom">10px</property>
<property name="marginRight">10px</property>
<property name="paddingTop">0px</property>
<property name="paddingLeft">0px</property>
<property name="paddingBottom">0px</property>
<property name="paddingRight">0px</property>
</style>
<style name="grid" id="66"/>
<style name="label" id="67"/>
<style name="list" id="68"/>
<style name="list-detail" id="69"/>
<style name="list-footer" id="70"/>
<style name="list-header" id="71"/>
<style name="report" id="72"/>
<style name="table" id="73">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1px</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1px</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1px</property>
</style>
<style name="table-detail" id="74">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">8pt</property>
</style>
<style name="table-footer" id="75">
<property name="backgroundColor">#FBF2F2</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
</style>
<style name="table-header" id="76">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="text" id="77"/>
<style name="data" id="78"/>
<style name="image" id="79"/>
<style name="list-group-footer-1" id="80"/>
<style name="list-group-footer-2" id="81"/>
<style name="list-group-footer-3" id="82"/>
<style name="list-group-footer-4" id="83"/>
<style name="list-group-footer-5" id="84"/>
<style name="list-group-footer-6" id="85"/>
<style name="list-group-footer-7" id="86"/>
<style name="list-group-footer-8" id="87"/>
<style name="list-group-footer-9" id="88"/>
<style name="list-group-header-1" id="89"/>
<style name="list-group-header-2" id="90"/>
<style name="list-group-header-3" id="91"/>
<style name="list-group-header-4" id="92"/>
<style name="list-group-header-5" id="93"/>
<style name="list-group-header-6" id="94"/>
<style name="list-group-header-7" id="95"/>
<style name="list-group-header-8" id="96"/>
<style name="list-group-header-9" id="97"/>
<style name="table-group-footer-1" id="98"/>
<style name="table-group-footer-2" id="99"/>
<style name="table-group-footer-3" id="100"/>
<style name="table-group-footer-4" id="101"/>
<style name="table-group-footer-5" id="102"/>
<style name="table-group-footer-6" id="103"/>
<style name="table-group-footer-7" id="104"/>
<style name="table-group-footer-8" id="105"/>
<style name="table-group-footer-9" id="106"/>
<style name="table-group-header-1" id="107">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-2" id="108">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-3" id="109">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-4" id="110">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-5" id="111">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-6" id="112">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-7" id="113">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-8" id="114">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="table-group-header-9" id="115">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0px</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1px</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0px</property>
</style>
<style name="text-data" id="116"/>
<style name="crosstab-cell" id="117">
<property name="backgroundColor">#FFFFFF</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">normal</property>
<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-column-title" id="118">
<property name="backgroundColor">#E7E7E7</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0pt</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
<property name="textAlign">center</property>
</style>
<style name="crosstab-row-title" id="119">
<property name="textAlign">left</property>
</style>
<style name="crosstab-row-title-totals" id="120">
<property name="backgroundColor">#FBF2F2</property>
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
</style>
<style name="crosstab-detail" id="121">
<property name="textAlign">right</property>
</style>
<style name="crosstab-detail-totals" id="122">
<property name="backgroundColor">#FBF2F2</property>
<property name="fontWeight">bold</property>
</style>
<style name="crosstab" id="123">
<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">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Report Generated <value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="58">
<property name="width">100%</property>
<column id="59"/>
<row id="60">
<cell id="61">
<text id="64">
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[Enter your report title]]></text-property>
</text>
</cell>
</row>
<row id="62">
<cell id="63">
<extended-item extensionName="Crosstab" extensionVersion="2.3.0" id="161">
<property name="emptyCellValue">0</property>
<property name="measures">
<extended-item extensionName="MeasureView" id="163">
<property name="measure">OFFICECODE</property>
<property name="detail">
<extended-item extensionName="AggregationCell" id="164">
<property name="aggregationOnRow">Group3/STATE</property>
<property name="aggregationOnColumn">Group/CITY</property>
<property name="content">
<data id="165">
<property name="resultSetColumn">OFFICECODE_Group3/STATE_Group/CITY</property >
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="166">
<property name="content">
<label id="167">
<text-property name="text">OFFICECODE</text-property>
</label>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="173">
<property name="views">
<extended-item extensionName="DimensionView" id="181">
<property name="dimension">Group2</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View1" id="182">
<property name="level">Group2/shortname</property>
<property name="sort">
<sort-element>
<expression name="key">data["shortname"]</expression>
<property name="direction">desc</property>
</sort-element>
</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="183">
<property name="content">
<data name="shortname" id="184">
<property name="resultSetColumn">shortname</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
<extended-item extensionName="DimensionView" id="188">
<property name="dimension">Group3</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View2" id="189">
<property name="level">Group3/STATE</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="190">
<property name="content">
<data name="STATE" id="191">
<list-property name="visibility">
<structure>
<property name="format">all</property>
<expression name="valueExpr">true</expression>
</structure>
</list-property>
<property name="resultSetColumn">STATE</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="168">
<property name="views">
<extended-item extensionName="DimensionView" id="169">
<property name="dimension">Group</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View" id="170">
<property name="level">Group/CITY</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="171">
<property name="content">
<data name="CITY" id="172">
<property name="resultSetColumn">CITY</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="162"/>
</property>
<property name="cube">Data Cube - Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">OFFICECODE</property>
<expression name="expression">measure["OFFICECODE"]</expression>
<property name="dataType">string</property>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression name="expression">dimension["Group"]["CITY"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">OFFICECODE_Group/CITY</property>
<expression name="expression">measure["OFFICECODE"]</expression>
<property name="dataType">string</property>
<simple-property-list name="aggregateOn">
<value>Group/CITY</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">shortname</property>
<expression name="expression">dimension["Group2"]["shortname"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">OFFICECODE_Group2/shortname_Group/CITY</property >
<expression name="expression">measure["OFFICECODE"]</expression>
<property name="dataType">string</property>
<simple-property-list name="aggregateOn">
<value>Group2/shortname</value>
<value>Group/CITY</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression name="expression">dimension["Group3"]["STATE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">OFFICECODE_Group3/STATE_Group/CITY</property>
<expression name="expression">measure["OFFICECODE"]</expression>
<property name="dataType">string</property>
<simple-property-list name="aggregateOn">
<value>Group3/STATE</value>
<value>Group/CITY</value>
</simple-property-list>
<property name="

[Updated on: Fri, 05 March 2010 12:12]

Report message to a moderator

icon14.gif  Re: Set visibilty of crosstab cell? [message #518906 is a reply to message #518890] Fri, 05 March 2010 12:11 Go to previous messageGo to next message
Missing name Missing name is currently offline Missing name Missing nameFriend
Messages: 94
Registered: November 2009
Member
Never mind, found the answer myself. I created a script for the crosstab that hides the right border for the cell I want to see and hides the left border of the cell I dont want to see


/**
 * Called when crosstab cell is being prepared.
 *
 * @param cellInst
 *            ICrosstabCell
 * @param reportContext
 *            IReportContext
 */

function onPrepareCell(cellInst, reportContext) {	
        // Cell Id is that of the "shortname" cell
	if(cellInst.getCellID() == 209) {	
		cellInst.getStyle().setBorderRightWidth("0px");
	}

        // Cell Id is that of the "state" cell
	if(cellInst.getCellID() == 213) {
		cellInst.getStyle().setBorderLeftWidth("0px");
	}
}

Re: Set visibilty of crosstab cell? [message #519062 is a reply to message #518906] Fri, 05 March 2010 18:26 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Trevor,

Nice script.

Jason

TREVOR.HIGGINS@FINEOS.COM wrote:
> Never mind, found the answer myself. I created a script for the crosstab
> that hides the right border for the cell I want to see and hides the
> left border of the cell I dont want to see
>
>
>
> /**
> * Called when crosstab cell is being prepared.
> *
> * @param cellInst
> * ICrosstabCell
> * @param reportContext
> * IReportContext
> */
>
> function onPrepareCell(cellInst, reportContext) {
> // Cell Id is that of the "shortname" cell
> if(cellInst.getCellID() == 209) {
> cellInst.getStyle().setBorderRightWidth("0px");
> }
>
> // Cell Id is that of the "state" cell
> if(cellInst.getCellID() == 213) {
> cellInst.getStyle().setBorderLeftWidth("0px");
> }
> }
>
>
Previous Topic:How to use a global var?
Next Topic:Modifications of Birt Viewer and eclipse license
Goto Forum:
  


Current Time: Fri Apr 26 11:15:16 GMT 2024

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

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

Back to the top