Home
Analytics
CrossTab export excel issue
slap
<p>Hi all,</p><p> </p><p>I made a report with a crossTab inside and i don't know from scratch the number of column because i use a report parameter in the query for load the dataset.</p><p> </p><p>I try using scripting to change the width of the crossTab Column but i find a strange (for me) situation:<br />
if i run the report as XSL the reportContext.getHttpServletRequest().getParameter("__format") is <span class='bbc_underline'>xsl</span><br />
but if i run the report in the report viewer and then i export the document in Excel format the reportContext.getHttpServletRequest().getParameter("__format") is <span class='bbc_underline'>html</span>.</p><p>There is an internal parameter or a condition that i can use in OnCreate of the crossTab for generate different width in different kind of view of the report?<br />
<br />
Anytype of help is usefull. Thanks in advance.</p>
Find more posts tagged with
Comments
kclark
<p>What version of BIRT are you running?</p><p> </p><p>I used</p><pre class="_prettyXprint">reportContext.getOutputFormat()</pre><p>In the onCreate() and onRender() of a label and got the expect results rendering straight to xls and from the webviewer to xls in 4.3</p>
slap
<p>Hi kclark thaks for reply,
i'm trying to use
<span>reportContext</span><span>.</span><span>getOutputFormat</span><span>() but i have the same result of '__format' parameter:
try this report (sorry for xml):</span>
</p><blockquote class="ipsBlockquote">
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="<a data-ipb='nomediaparse' href='
http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design</a>"
; version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build <4.2.1.v20120918-1113></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</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="crosstab" id="6">
<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[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<text id="8">
<method name="onCreate"><![CDATA[this.text = reportContext.getOutputFormat();]]></method>
</text>
</body>
</report><p> </p></blockquote><p>Try this report: view in the web viewer and then export in Excel format..now i have pdf format and not html..
this is a bug or i make any mistake in any part of the configuration?</p><p> </p>
Hans_vd
<p>Hi slap,</p><p> </p><p>The answer is in comment 5 of this forum entry: <a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/forum/index.php?/topic/23575-detecting-web-viewer-in-report/'>http://www.birt-exchange.org/forum/index.php?/topic/23575-detecting-web-viewer-in-report/</a></p><p> </p><p>So
try using the onRender event instead of the onCreate event</p>
slap
<p>thanks<span><a data-ipb='nomediaparse' class="" href='
http://www.birt-exchange.org/forum/index.php?/user/27528-hans-vd/'
title=""><span> Hans_vd</span></a></span>,</p><p>now i can manage the real outputformat.
</p><p>But now my question is: how can i manage the dimension of a crossTab for different output?</p><p> </p><p>For example, if i want to set a different width for different format i have to set this:</p><pre class="_prettyXprint">reportContext.getDesignHandle().getElementByID('elementId').setStringProperty("width","100px");</pre><p>But for have the result i desire i have to put this line of code in the onPrepare of the crossTab.</p><p>In the onRender of the crossTab i can't manage the dimension of the column, but the <span>reportContext</span><span>.</span><span>getOutputFormat</span><span>()</span> have the <span><span>right value. </span></span>
</p><p>
</p>
Hans_vd
<blockquote class="ipsBlockquote">But for have the result i desire i have to put this line of code in the onPrepare of the crossTab.<p> </p></blockquote><p> </p><p>Why? What is the result you desire?</p><p> </p><p> </p><blockquote class="ipsBlockquote">I can't manage the dimension of the column<p> </p></blockquote><p> </p><p>What about the dimension of the column are you trying to manage?</p>
slap
<p>What <span><span>I've tried</span> <span>until now</span> <span>to</span> <span>ask was how to have a report with differnt layout in different export format.
For example if i export the report in pdf i want only one header group of my cross tab for page, but when i export the the report in xls format the cell is to wide and i want to limit them, for example </span></span><span>100px.</span>
</p><blockquote class="ipsBlockquote"><p> </p><p>What about the dimension of the column are you trying to manage?</p></blockquote><p>The dimension of my crossTab column when i export to xls.
</p>
Hans_vd
<p>So by "managing the dimension" you mean hiding/showing it depending on the output type, is that it?</p>
slap
<p>Not..
try this report:
</p><pre class="_prettyXprint _lang-xml"><?xml version="1.0" encoding="UTF-8"?><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1"> <property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build <4.2.1.v20120918-1113></property> <property name="units">in</property> <property name="iconFile">/templates/blank_report.gif</property> <property name="layoutPreference">auto layout</property> <property name="bidiLayoutOrientation">ltr</property> <property name="imageDPI">96</property> <data-sources> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="11"> <list-property name="privateDriverProperties"> <ex-property> <name>contentBidiFormatStr</name> <value>ILYNN</value> </ex-property> <ex-property> <name>metadataBidiFormatStr</name> <value>ILYNN</value> </ex-property> </list-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> </oda-data-source> </data-sources> <data-sets> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="12"> <list-property name="columnHints"> <structure> <property name="columnName">CUSTOMERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <text-property name="heading">CUSTOMERNUMBER</text-property> </structure> <structure> <property name="columnName">CUSTOMERNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CUSTOMERNAME</text-property> <text-property name="heading">CUSTOMERNAME</text-property> </structure> <structure> <property name="columnName">CONTACTLASTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CONTACTLASTNAME</text-property> <text-property name="heading">CONTACTLASTNAME</text-property> </structure> <structure> <property name="columnName">CONTACTFIRSTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CONTACTFIRSTNAME</text-property> <text-property name="heading">CONTACTFIRSTNAME</text-property> </structure> <structure> <property name="columnName">PHONE</property> <property name="analysis">dimension</property> <text-property name="displayName">PHONE</text-property> <text-property name="heading">PHONE</text-property> </structure> <structure> <property name="columnName">ADDRESSLINE1</property> <property name="analysis">dimension</property> <text-property name="displayName">ADDRESSLINE1</text-property> <text-property name="heading">ADDRESSLINE1</text-property> </structure> <structure> <property name="columnName">ADDRESSLINE2</property> <property name="analysis">dimension</property> <text-property name="displayName">ADDRESSLINE2</text-property> <text-property name="heading">ADDRESSLINE2</text-property> </structure> <structure> <property name="columnName">CITY</property> <property name="analysis">dimension</property> <text-property name="displayName">CITY</text-property> <text-property name="heading">CITY</text-property> </structure> <structure> <property name="columnName">STATE</property> <property name="analysis">dimension</property> <text-property name="displayName">STATE</text-property> <text-property name="heading">STATE</text-property> </structure> <structure> <property name="columnName">POSTALCODE</property> <property name="analysis">dimension</property> <text-property name="displayName">POSTALCODE</text-property> <text-property name="heading">POSTALCODE</text-property> </structure> <structure> <property name="columnName">COUNTRY</property> <property name="analysis">dimension</property> <text-property name="displayName">COUNTRY</text-property> <text-property name="heading">COUNTRY</text-property> </structure> <structure> <property name="columnName">SALESREPEMPLOYEENUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property> <text-property name="heading">SALESREPEMPLOYEENUMBER</text-property> </structure> <structure> <property name="columnName">CREDITLIMIT</property> <property name="analysis">measure</property> <text-property name="displayName">CREDITLIMIT</text-property> <text-property name="heading">CREDITLIMIT</text-property> </structure> </list-property> <list-property name="parameters"/> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">CUSTOMERNUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">CUSTOMERNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">3</property> <property name="name">CONTACTLASTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">4</property> <property name="name">CONTACTFIRSTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">5</property> <property name="name">PHONE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">6</property> <property name="name">ADDRESSLINE1</property> <property name="dataType">string</property> </structure> <structure> <property name="position">7</property> <property name="name">ADDRESSLINE2</property> <property name="dataType">string</property> </structure> <structure> <property name="position">8</property> <property name="name">CITY</property> <property name="dataType">string</property> </structure> <structure> <property name="position">9</property> <property name="name">STATE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">10</property> <property name="name">POSTALCODE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">11</property> <property name="name">COUNTRY</property> <property name="dataType">string</property> </structure> <structure> <property name="position">12</property> <property name="name">SALESREPEMPLOYEENUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">13</property> <property name="name">CREDITLIMIT</property> <property name="dataType">float</property> </structure> </list-property> </structure> <property name="dataSource">Data Source</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">CUSTOMERNUMBER</property> <property name="nativeName">CUSTOMERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">CUSTOMERNAME</property> <property name="nativeName">CUSTOMERNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">3</property> <property name="name">CONTACTLASTNAME</property> <property name="nativeName">CONTACTLASTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">4</property> <property name="name">CONTACTFIRSTNAME</property> <property name="nativeName">CONTACTFIRSTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">5</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">6</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">7</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">8</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">9</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">10</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">11</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">12</property> <property name="name">SALESREPEMPLOYEENUMBER</property> <property name="nativeName">SALESREPEMPLOYEENUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">13</property> <property name="name">CREDITLIMIT</property> <property name="nativeName">CREDITLIMIT</property> <property name="dataType">float</property> <property name="nativeDataType">8</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from CLASSICMODELS.CUSTOMERSwhere CLASSICMODELS.CUSTOMERS.COUNTRY = 'USA' or CLASSICMODELS.CUSTOMERS.COUNTRY = 'Italy']]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNAME</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CONTACTLASTNAME</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CONTACTLASTNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CONTACTLASTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CONTACTFIRSTNAME</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CONTACTFIRSTNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CONTACTFIRSTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>PHONE</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>PHONE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>PHONE</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ADDRESSLINE1</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ADDRESSLINE1</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ADDRESSLINE1</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ADDRESSLINE2</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ADDRESSLINE2</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ADDRESSLINE2</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CITY</design:name> <design:position>8</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CITY</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CITY</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>STATE</design:name> <design:position>9</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>STATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>STATE</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>POSTALCODE</design:name> <design:position>10</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>POSTALCODE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>POSTALCODE</design:label> <design:formattingHints> <design:displaySize>15</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>COUNTRY</design:name> <design:position>11</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>COUNTRY</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>COUNTRY</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>SALESREPEMPLOYEENUMBER</design:name> <design:position>12</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>SALESREPEMPLOYEENUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>SALESREPEMPLOYEENUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CREDITLIMIT</design:name> <design:position>13</design:position> </design:identifier> <design:nativeDataTypeCode>8</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CREDITLIMIT</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CREDITLIMIT</design:label> <design:formattingHints> <design:displaySize>22</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> <design:criteria/> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> </data-sets> <cubes> <tabular-cube name="Data Cube" id="13"> <property name="dimensions"> <tabular-dimension name="Group" id="14"> <property name="defaultHierarchy">NewTabularHierarchy</property> <property name="hierarchies"> <tabular-hierarchy name="NewTabularHierarchy" id="15"> <property name="levels"> <tabular-level name="COUNTRY" id="16"> <property name="dataType">string</property> <property name="columnName">COUNTRY</property> </tabular-level> </property> </tabular-hierarchy> </property> </tabular-dimension> <tabular-dimension name="Group1" id="19"> <property name="defaultHierarchy">NewTabularHierarchy1</property> <property name="hierarchies"> <tabular-hierarchy name="NewTabularHierarchy1" id="20"> <property name="levels"> <tabular-level name="STATE" id="21"> <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="25"> <property name="measures"> <tabular-measure name="ADDRESSLINE1" id="26"> <property name="function">count</property> <expression name="measureExpression" type="javascript">dataSetRow["ADDRESSLINE1"]</expression> <property name="dataType">integer</property> </tabular-measure> </property> </tabular-measure-group> </property> <property name="dataSet">Data Set</property> </tabular-cube> </cubes> <styles> <style name="report" id="4"> <property name="fontFamily">sans-serif</property> <property name="fontSize">10pt</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="crosstab" id="6"> <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[<value-of>new Date()</value-of>]]></text-property> </text> </page-footer> </simple-master-page> </page-setup> <body> <text id="8"> <method name="onCreate"><![CDATA[this.text = reportContext.getOutputFormat();]]></method> </text> <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="9"> <property name="cube">Data Cube</property> <property name="measures"> <extended-item extensionName="MeasureView" id="37"> <property name="measure">ADDRESSLINE1</property> <property name="detail"> <extended-item extensionName="AggregationCell" id="38"> <property name="aggregationOnRow">Group/COUNTRY</property> <property name="aggregationOnColumn">Group1/STATE</property> <property name="content"> <data id="39"> <property name="resultSetColumn">ADDRESSLINE1_Group/COUNTRY_Group1/STATE</property> </data> </property> <property name="width">6.75in</property> </extended-item> </property> <property name="header"> <extended-item extensionName="CrosstabCell" id="40"> <property name="content"> <label id="41"> <text-property name="text">ADDRESSLINE1</text-property> </label> </property> </extended-item> </property> </extended-item> </property> <property name="rows"> <extended-item extensionName="CrosstabView" id="27"> <property name="views"> <extended-item extensionName="DimensionView" id="28"> <property name="dimension">Group</property> <property name="levels"> <extended-item extensionName="LevelView" name="NewLevel View" id="29"> <property name="level">Group/COUNTRY</property> <property name="member"> <extended-item extensionName="CrosstabCell" id="30"> <property name="content"> <data name="COUNTRY" id="31"> <property name="resultSetColumn">COUNTRY</property> </data> </property> <property name="width">1.1979166666666667in</property> </extended-item> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> <property name="columns"> <extended-item extensionName="CrosstabView" id="32"> <property name="views"> <extended-item extensionName="DimensionView" id="33"> <property name="dimension">Group1</property> <property name="levels"> <extended-item extensionName="LevelView" name="NewLevel View1" id="34"> <property name="level">Group1/STATE</property> <property name="member"> <extended-item extensionName="CrosstabCell" id="35"> <property name="content"> <data name="STATE" id="36"> <property name="resultSetColumn">STATE</property> </data> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> <property name="header"> <extended-item extensionName="CrosstabCell" id="10"/> </property> <list-property name="boundDataColumns"> <structure> <property name="name">COUNTRY</property> <expression name="expression">dimension["Group"]["COUNTRY"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">STATE</property> <expression name="expression">dimension["Group1"]["STATE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">ADDRESSLINE1_Group/COUNTRY_Group1/STATE</property> <expression name="expression">measure["ADDRESSLINE1"]</expression> <property name="dataType">integer</property> <simple-property-list name="aggregateOn"> <value>Group/COUNTRY</value> <value>Group1/STATE</value> </simple-property-list> <property name="aggregateFunction">SUM</property> </structure> </list-property> </extended-item> <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="42"> <property name="cube">Data Cube</property> <property name="measures"> <extended-item extensionName="MeasureView" id="43"> <property name="measure">ADDRESSLINE1</property> <property name="detail"> <extended-item extensionName="AggregationCell" id="44"> <property name="aggregationOnRow">Group/COUNTRY</property> <property name="aggregationOnColumn">Group1/STATE</property> <property name="content"> <data id="45"> <property name="resultSetColumn">ADDRESSLINE1_Group/COUNTRY_Group1/STATE</property> </data> </property> <property name="width">6.75in</property> </extended-item> </property> <property name="header"> <extended-item extensionName="CrosstabCell" id="46"> <property name="content"> <label id="47"> <text-property name="text">ADDRESSLINE1</text-property> </label> </property> </extended-item> </property> </extended-item> </property> <property name="rows"> <extended-item extensionName="CrosstabView" id="48"> <property name="views"> <extended-item extensionName="DimensionView" id="49"> <property name="dimension">Group</property> <property name="levels"> <extended-item extensionName="LevelView" name="NewLevel View2" id="50"> <property name="level">Group/COUNTRY</property> <property name="member"> <extended-item extensionName="CrosstabCell" id="51"> <property name="content"> <data name="COUNTRY1" id="52"> <property name="resultSetColumn">COUNTRY</property> </data> </property> <property name="width">1.1979166666666667in</property> </extended-item> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> <property name="columns"> <extended-item extensionName="CrosstabView" id="53"> <property name="views"> <extended-item extensionName="DimensionView" id="54"> <property name="dimension">Group1</property> <property name="levels"> <extended-item extensionName="LevelView" name="NewLevel View11" id="55"> <property name="level">Group1/STATE</property> <property name="member"> <extended-item extensionName="CrosstabCell" id="56"> <property name="content"> <data name="STATE1" id="57"> <property name="resultSetColumn">STATE</property> </data> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> </extended-item> </property> <property name="header"> <extended-item extensionName="CrosstabCell" id="58"/> </property> <method name="onPrepare"><![CDATA[/** * Called when crosstab is being prepared. * *
@param
crosstab * ICrosstab *
@param
reportContext * IReportContext */function onPrepareCrosstab( crosstab, reportContext ){ reportContext.getDesignHandle().getElementByID(46).setStringProperty("width","100px"); reportContext.getDesignHandle().getElementByID(44).setStringProperty("width","100px");}]]></method> <list-property name="boundDataColumns"> <structure> <property name="name">COUNTRY</property> <expression name="expression">dimension["Group"]["COUNTRY"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">STATE</property> <expression name="expression">dimension["Group1"]["STATE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">ADDRESSLINE1_Group/COUNTRY_Group1/STATE</property> <expression name="expression">measure["ADDRESSLINE1"]</expression> <property name="dataType">integer</property> <simple-property-list name="aggregateOn"> <value>Group/COUNTRY</value> <value>Group1/STATE</value> </simple-property-list> <property name="aggregateFunction">SUM</property> </structure> </list-property> </extended-item> </body></report></pre><p>
Run in web viewer and then export in xls format. In the xls format the second crossTab is what i want to see in xls format and the first is what to see in other format. Do you any method to rappresent this situation?
(The only workaround i found yesterday is to have two crossTab, that i hide or show only if is the <span><span>the format</span> <span>expected by the </span></span>Visibility Properties of the CrossTab element.)
</p>
Yaytay
<p>You can control what is shown based on the output format by using the Visibility tab in the property editor - so, without writing any script, you can have different outputs for different formats.</p><p> </p><p>However, you may be able to get what you want with a single crosstab if you use the SpudSoft Excel Emitters.</p><p>They can automatically calculate the width of the columns and they don't truncate the table to fit the print size.</p><p> </p><p>Jim</p>
slap
<p>Thanks you<span><a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/forum/index.php?/user/39057-yaytay/'
title=""><span> Yaytay</span></a></span> for the <span><span>two alternatives</span></span>
i never used not standard emitters, and now i'm going to test the <span><span>potentiality of the </span></span>SpudSoft Excel Emitters; if our company can't use or is include in our structure is too tricky i use my workaround and use the visibility tab in the property editor for made different output for different format.
</p>