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; } } }

Alignment problem with crosstab while exporting data in to xls

SrinivasaRao

Hi,

I have designed the crosstab report.While exporting the report in to xls file we were unable to find proper alignment(Not displaying the value properly under the same column header ).PFA XLS Sheet.

Please provide some help resolve this issue.

Thanks in advance

Find more posts tagged with

Comments

mwilliams

Hi rishwanth,

This is just the row dimension headers, correct?

SrinivasaRao

Hi,

Thanks alot for your help.

Yes, This just Row Dimension headers. While Exporting in to the PDF Its giving alignment properly.

But, when i export in to xls its not aligning proprly.

Please Give the solution to resolve this issue.

Thanks in Advance.

mwilliams

rishwanth,

And you are sizing the grid that you use for the headers the same as the row dimension columns, correct? What version of BIRT are you using?

SrinivasaRao

Hi,

I am using Birt 2.5.1 version and And Correct, i am sizing the grid that i use for the headers the same as the row dimension columns.

mwilliams

I'll try it in 2.5.2 and 2.6.0M6 and let you know if anything has changed.

SrinivasaRao

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="64143" data-time="1273170736" data-date="06 May 2010 - 11:32 AM">
I'll try it in 2.5.2 and 2.6.0M6 and let you know if anything has changed. </blockquote>
Hi Mwilliams, 
 
Any luck with new versions If yes please provide suggest me that version. If not can you please guide me or suggest me how we can resolve that issue. 
 
Waiting for your response. 
 
Actually i got strucked up with this issue. Plzzzzzzzzzzzz help me to come out from this issue. 
 
Thanks, 
Srinivas

KSENGUPTA

Hi there, me too is facing some problem regarding PDF export. The format is not very poor,but the some issues have been raised regarding that report....Plz refer to attachme

mwilliams

Have you checked the padding on the cells and elements? You might try setting them all to 0. Can you attach the report design? Or better yet, recreate the same issue with a report with the sample database so I can look at it running? Or does this happen in all crosstabs in PDF? In that case, what is your BIRT version?

Happy_20

I am having similar formatting issue. I have two different format in HTML and PDF, the one in PDF is correct. I have attched the PDF and HTML version (png file), I have highlighted the changes (major change is the header grid in the crosstab). I have also attached the rptdesign.

It would be great to get a work around.

Thanks a lot in advance.

mwilliams

Can you reproduce this in a report I can run?

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108923" data-time="1346212630" data-date="28 August 2012 - 08:57 PM">
Can you reproduce this in a report I can run? </blockquote>
 
Hi mwilliams, 
 
I have generated sample report so that you can run (This example is same as the earlier one I mentioned about). I have also attached its pdf and HTML version. The Layout is not proper in HTML and PDF. I have set Layout as "Auto Layout", I also tried setting "fixed layout", still no luck. Also I have set padding to zero for the header label of the crosstab. 
Can you please help me to set the proper and consistent layout in PDF and HTML too. 
 
I am unable to attch rptdesign, so I am copy-pasting the code here: 
 
<?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.22" id="1"> 
<property name="comments">Copyright (c) 2007 <<Your Company Name here>></property> 
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property> 
<html-property name="description">Creates a blank report with no predefined content.</html-property> 
<list-property name="userProperties"> 
<structure> 
<property name="name">Customer Cube.dsOrders.x</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.dsOrders.y</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group1.NewTabularHierarchy1.x</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group1.NewTabularHierarchy1.y</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.dsOrders.width</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.dsOrders.height</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group1.NewTabularHierarchy1.width</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group1.NewTabularHierarchy1.height</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group2.NewTabularHierarchy2.x</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.Group2.NewTabularHierarchy2.y</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.product.NewTabularHierarchy1.x</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.dsSales.x</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.dsSales.y</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.product.NewTabularHierarchy1.y</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.product.NewTabularHierarchy1.width</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
<structure> 
<property name="name">Customer Cube.product.NewTabularHierarchy1.height</property> 
<property name="type">integer</property> 
<property name="isVisible">false</property> 
</structure> 
</list-property> 
<property name="Customer Cube.dsOrders.x">216</property> 
<property name="Customer Cube.dsOrders.y">87</property> 
<property name="Customer Cube.Group1.NewTabularHierarchy1.x">426</property> 
<property name="Customer Cube.Group1.NewTabularHierarchy1.y">42</property> 
<property name="Customer Cube.dsOrders.width">150</property> 
<property name="Customer Cube.dsOrders.height">200</property> 
<property name="Customer Cube.Group1.NewTabularHierarchy1.width">150</property> 
<property name="Customer Cube.Group1.NewTabularHierarchy1.height">200</property> 
<property name="Customer Cube.Group2.NewTabularHierarchy2.x">27</property> 
<property name="Customer Cube.Group2.NewTabularHierarchy2.y">10</property> 
<property name="Customer Cube.product.NewTabularHierarchy1.x">416</property> 
<property name="Customer Cube.dsSales.x">135</property> 
<property name="Customer Cube.dsSales.y">80</property> 
<property name="Customer Cube.product.NewTabularHierarchy1.y">45</property> 
<property name="Customer Cube.product.NewTabularHierarchy1.width">150</property> 
<property name="Customer Cube.product.NewTabularHierarchy1.height">200</property> 
<property name="units">in</property> 
<text-property name="displayName">Blank Report</text-property> 
<property name="iconFile">/templates/blank_report.gif</property> 
<property name="layoutPreference">auto layout</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="dsSales" id="247"> 
<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> 
<structure> 
<property name="position">6</property> 
<property name="name">ORDERTOTAL</property> 
<property name="dataType">float</property> 
</structure> 
<structure> 
<property name="position">7</property> 
<property name="name">ORDERDATE</property> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="position">8</property> 
<property name="name">STATUS</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">9</property> 
<property name="name">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">10</property> 
<property name="name">COUNTRY</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">11</property> 
<property name="name">STATE</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">12</property> 
<property name="name">CITY</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">13</property> 
<property name="name">CUSTOMERNUMBER_13</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">14</property> 
<property name="name">PRODUCTNAME</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">15</property> 
<property name="name">PRODUCTLINE</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">16</property> 
<property name="name">PRODUCTCODE_16</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">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> 
<structure> 
<property name="position">6</property> 
<property name="name">ORDERTOTAL</property> 
<property name="nativeName">ORDERTOTAL</property> 
<property name="dataType">float</property> 
<property name="nativeDataType">8</property> 
</structure> 
<structure> 
<property name="position">7</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">8</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">9</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">10</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">11</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">12</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">13</property> 
<property name="name">CUSTOMERNUMBER_13</property> 
<property name="nativeName">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
<structure> 
<property name="position">14</property> 
<property name="name">PRODUCTNAME</property> 
<property name="nativeName">PRODUCTNAME</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">15</property> 
<property name="name">PRODUCTLINE</property> 
<property name="nativeName">PRODUCTLINE</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">16</property> 
<property name="name">PRODUCTCODE_16</property> 
<property name="nativeName">PRODUCTCODE</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
</list-property> 
<xml-property name="queryText"><![CDATA[select CLASSICMODELS.ORDERDETAILS.ORDERNUMBER, 
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE, 
CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED, 
CLASSICMODELS.ORDERDETAILS.PRICEEACH, 
CLASSICMODELS.ORDERDETAILS.ORDERLINENUMBER, 
CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH as orderTotal, 
CLASSICMODELS.ORDERS.ORDERDATE, 
CLASSICMODELS.ORDERS.STATUS, 
CLASSICMODELS.ORDERS.CUSTOMERNUMBER, 
CLASSICMODELS.CUSTOMERS.COUNTRY, 
CLASSICMODELS.CUSTOMERS.STATE, 
CLASSICMODELS.CUSTOMERS.CITY, 
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, 
CLASSICMODELS.PRODUCTS.PRODUCTNAME, 
CLASSICMODELS.PRODUCTS.PRODUCTLINE, 
CLASSICMODELS.PRODUCTS.PRODUCTCODE 
 
from 
CLASSICMODELS.CUSTOMERS, 
CLASSICMODELS.ORDERS, 
CLASSICMODELS.ORDERDETAILS, 
CLASSICMODELS.PRODUCTS 
where 
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS.CUSTOMERNUMBER 
and 
CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS.ORDERNUMBER 
and 
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCTS.PRODUCTCODE]]></xml-property> 
</oda-data-set> 
</data-sets> 
<cubes> 
<tabular-cube name="salesCube" id="248"> 
<property name="dimensions"> 
<tabular-dimension name="customerRegion" id="249"> 
<property name="defaultHierarchy">NewTabularHierarchy</property> 
<property name="hierarchies"> 
<tabular-hierarchy name="NewTabularHierarchy" id="250"> 
<property name="levels"> 
<tabular-level name="COUNTRY" id="251"> 
<property name="dataType">string</property> 
<property name="levelType">dynamic</property> 
<property name="columnName">COUNTRY</property> 
</tabular-level> 
<tabular-level name="STATE" id="252"> 
<property name="dataType">string</property> 
<property name="levelType">dynamic</property> 
<property name="columnName">STATE</property> 
</tabular-level> 
<tabular-level name="CITY" id="253"> 
<property name="dataType">string</property> 
<property name="levelType">dynamic</property> 
<property name="columnName">CITY</property> 
</tabular-level> 
</property> 
<property name="dataSet">dsSales</property> 
</tabular-hierarchy> 
</property> 
</tabular-dimension> 
<tabular-dimension name="product" id="254"> 
<property name="defaultHierarchy">NewTabularHierarchy1</property> 
<property name="hierarchies"> 
<tabular-hierarchy name="NewTabularHierarchy1" id="255"> 
<property name="levels"> 
<tabular-level name="PRODUCTLINE" id="256"> 
<property name="dataType">string</property> 
<property name="levelType">dynamic</property> 
<property name="columnName">PRODUCTLINE</property> 
</tabular-level> 
<tabular-level name="PRODUCTNAME" id="257"> 
<property name="dataType">string</property> 
<property name="levelType">dynamic</property> 
<property name="columnName">PRODUCTNAME</property> 
</tabular-level> 
</property> 
<property name="dataSet">dsSales</property> 
</tabular-hierarchy> 
</property> 
</tabular-dimension> 
</property> 
<property name="measureGroups"> 
<tabular-measure-group name="Summary Field" id="259"> 
<property name="measures"> 
<tabular-measure name="ORDERTOTAL" id="260"> 
<property name="function">sum</property> 
<expression name="measureExpression">dataSetRow["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
</tabular-measure> 
</property> 
</tabular-measure-group> 
</property> 
<property name="dataSet">dsSales</property> 
</tabular-cube> 
</cubes> 
<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="crosstab-detail" id="219"> 
<property name="backgroundColor">#EDEEF3</property> 
<structure name="numberFormat"> 
<property name="category">Unformatted</property> 
</structure> 
</style> 
<style name="crosstab-header" id="218"> 
<property name="backgroundColor">#4E5A7A</property> 
<property name="fontWeight">bold</property> 
<property name="color">#FFFFFF</property> 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<property name="topMargin">1in</property> 
<property name="leftMargin">1.25in</property> 
<property name="bottomMargin">1in</property> 
<property name="rightMargin">1.25in</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> 
<grid id="111"> 
<property name="width">100%</property> 
<column id="112"> 
<property name="width">1.625in</property> 
</column> 
<column id="113"> 
<property name="width">3.2in</property> 
</column> 
<row id="114"> 
<property name="style">BackgroundLightGray</property> 
<cell id="115"> 
<property name="style">BackgroundLightGray</property> 
<image id="124"> 
<property name="source">file</property> 
<expression name="uri">"images/classicModels.PNG"</expression> 
</image> 
</cell> 
<cell id="117"> 
<property name="style">BackgroundLightGray</property> 
<property name="verticalAlign">middle</property> 
<label id="118"> 
<property name="fontFamily">sans-serif</property> 
<property name="fontSize">20pt</property> 
<property name="fontWeight">bold</property> 
<property name="color">#000000</property> 
<text-property name="text">Classic Models, Inc.</text-property> 
</label> 
<text id="119"> 
<property name="fontFamily">sans-serif</property> 
<property name="contentType">html</property> 
<text-property name="content"><![CDATA[701 Gateway Boulevard, 
San Francisco, CA 94107 
 ]]></text-property> 
</text> 
<label id="120"> 
<property name="fontFamily">sans-serif</property> 
<property name="fontSize">18pt</property> 
<property name="fontWeight">bold</property> 
<text-property name="text">Products Sales Across Regions</text-property> 
</label> 
</cell> 
</row> 
<row id="121"> 
<property name="height">0.25in</property> 
<cell id="122"/> 
<cell id="123"/> 
</row> 
</grid> 
<extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="258"> 
<property name="cube">salesCube</property> 
<property name="measures"> 
<extended-item extensionName="MeasureView" id="271"> 
<property name="measure">ORDERTOTAL</property> 
<property name="detail"> 
<extended-item extensionName="AggregationCell" id="299"> 
<property name="aggregationOnRow">customerRegion/CITY</property> 
<property name="aggregationOnColumn">product/PRODUCTLINE</property> 
<property name="content"> 
<data name="ORDERTOTAL" id="274"> 
<property name="resultSetColumn">ORDERTOTAL</property> 
</data> 
</property> 
</extended-item> 
</property> 
<property name="aggregations"> 
<extended-item extensionName="AggregationCell" id="283"> 
<property name="aggregationOnColumn">product/PRODUCTLINE</property> 
<property name="content"> 
<data id="284"> 
<property name="resultSetColumn">ORDERTOTAL_product/PRODUCTLINE</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="287"> 
<property name="aggregationOnRow">customerRegion/CITY</property> 
<property name="content"> 
<data id="288"> 
<property name="resultSetColumn">ORDERTOTAL_customerRegion/CITY</property> 
</data> 
</property> 
</extended-item> 
<extended-item extensionName="AggregationCell" id="289"> 
<property name="content"> 
<data id="290"> 
<property name="resultSetColumn">ORDERTOTAL_1</property> 
</data> 
</property> 
</extended-item> 
</property> 
<property name="header"> 
<extended-item extensionName="CrosstabCell" id="273"/> 
<extended-item extensionName="CrosstabCell" id="300"/> 
</property> 
</extended-item> 
</property> 
<property name="rows"> 
<extended-item extensionName="CrosstabView" id="261"> 
<property name="grandTotal"> 
<extended-item extensionName="CrosstabCell" id="282"> 
<property name="content"> 
<label id="285"> 
<text-property name="text">Grand Total</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
<property name="views"> 
<extended-item extensionName="DimensionView" id="262"> 
<property name="dimension">customerRegion</property> 
<property name="levels"> 
<extended-item extensionName="LevelView" name="NewLevel View" id="263"> 
<property name="level">customerRegion/COUNTRY</property> 
<property name="sort"> 
<sort-element> 
<expression name="key">data["COUNTRY"]</expression> 
<property name="direction">desc</property> 
</sort-element> 
</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="264"> 
<property name="content"> 
<data name="COUNTRY" id="265"> 
<property name="resultSetColumn">COUNTRY</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
<extended-item extensionName="LevelView" name="NewLevel View2" id="276"> 
<property name="level">customerRegion/STATE</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="277"> 
<property name="content"> 
<data name="STATE" id="278"> 
<property name="resultSetColumn">STATE</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
<extended-item extensionName="LevelView" name="NewLevel View3" id="279"> 
<property name="level">customerRegion/CITY</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="280"> 
<property name="content"> 
<data name="CITY" id="281"> 
<property name="resultSetColumn">CITY</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
<property name="columns"> 
<extended-item extensionName="CrosstabView" id="266"> 
<property name="grandTotal"> 
<extended-item extensionName="CrosstabCell" id="286"> 
<property name="content"> 
<label id="291"> 
<text-property name="text">Grand Total</text-property> 
</label> 
</property> 
</extended-item> 
</property> 
<property name="views"> 
<extended-item extensionName="DimensionView" id="267"> 
<property name="dimension">product</property> 
<property name="levels"> 
<extended-item extensionName="LevelView" name="NewLevel View1" id="268"> 
<property name="level">product/PRODUCTLINE</property> 
<property name="filter"> 
<filter-condition-element> 
<expression name="expr">data["PRODUCTLINE"]</expression> 
<property name="operator">ne</property> 
<simple-property-list name="value1"> 
<value>"Classic Cars"</value> 
</simple-property-list> 
</filter-condition-element> 
</property> 
<property name="member"> 
<extended-item extensionName="CrosstabCell" id="269"> 
<property name="content"> 
<data name="PRODUCTLINE" id="270"> 
<property name="resultSetColumn">PRODUCTLINE</property> 
</data> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
</extended-item> 
</property> 
<property name="header"> 
<extended-item extensionName="CrosstabCell" id="298"> 
<property name="content"> 
<grid id="301"> 
<property name="height">0.46875in</property> 
<column id="302"> 
<property name="width">1.03125in</property> 
</column> 
<column id="303"> 
<property name="width">1.1770833333333333in</property> 
</column> 
<column id="304"> 
<property name="width">1.3229166666666667in</property> 
</column> 
<row id="305"> 
<property name="height">0.46875in</property> 
<property name="verticalAlign">bottom</property> 
<cell id="306"> 
<property name="borderRightColor">#FFFFFF</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">thin</property> 
<property name="paddingTop">0pt</property> 
<property name="paddingLeft">0pt</property> 
<property name="paddingBottom">0pt</property> 
<property name="paddingRight">0pt</property> 
<label id="309"> 
<text-property name="text">Country</text-property> 
</label> 
</cell> 
<cell id="307"> 
<property name="borderRightColor">#FFFFFF</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">thin</property> 
<property name="paddingTop">0pt</property> 
<property name="paddingLeft">0pt</property> 
<property name="paddingBottom">0pt</property> 
<property name="paddingRight">0pt</property> 
<label id="310"> 
<text-property name="text">State</text-property> 
</label> 
</cell> 
<cell id="308"> 
<property name="paddingTop">0pt</property> 
<property name="paddingLeft">0pt</property> 
<property name="paddingBottom">0pt</property> 
<property name="paddingRight">0pt</property> 
<label id="311"> 
<text-property name="text">City</text-property> 
</label> 
</cell> 
</row> 
</grid> 
</property> 
<property name="paddingTop">0pt</property> 
<property name="paddingLeft">0pt</property> 
<property name="paddingBottom">0pt</property> 
<property name="paddingRight">0pt</property> 
</extended-item> 
</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">COUNTRY</property> 
<expression name="expression">dimension["customerRegion"]["COUNTRY"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">PRODUCTLINE</property> 
<expression name="expression">dimension["product"]["PRODUCTLINE"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
</structure> 
<structure> 
<property name="name">STATE</property> 
<expression name="expression">dimension["customerRegion"]["STATE"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">CITY</property> 
<expression name="expression">dimension["customerRegion"]["CITY"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL_product/PRODUCTLINE</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
<simple-property-list name="aggregateOn"> 
<value>product/PRODUCTLINE</value> 
</simple-property-list> 
<property name="aggregateFunction">sum</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL_customerRegion/CITY</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
<simple-property-list name="aggregateOn"> 
<value>customerRegion/CITY</value> 
</simple-property-list> 
<property name="aggregateFunction">sum</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL_1</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
<property name="aggregateFunction">sum</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL_customerRegion/COUNTRY_product/PRODUCTLINE</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
<simple-property-list name="aggregateOn"> 
<value>customerRegion/COUNTRY</value> 
<value>product/PRODUCTLINE</value> 
</simple-property-list> 
<property name="aggregateFunction">sum</property> 
</structure> 
<structure> 
<property name="name">ORDERTOTAL_customerRegion/COUNTRY</property> 
<expression name="expression">measure["ORDERTOTAL"]</expression> 
<property name="dataType">float</property> 
<simple-property-list name="aggregateOn"> 
<value>customerRegion/COUNTRY</value> 
</simple-property-list> 
<property name="aggregateFunction">sum</property> 
</structure> 
</list-property> 
</extended-item> 
</body> 
</report>

mwilliams

Take a look at this. I made a few changes with the height and width settings of different elements. Part of the issue, with the PDF layout, was the Trucks and Buses label pushing down the header row, since a height was not set. Also, in the general tab of the property editor, you can choose to hide the measure header, which will also help.

Happy_20

Hi mwilliams,

Thanks a lot for helping. But, even I tried to get in PDF format correctly (if you see my first post in this thread), the main problem is HTML. I used your rptdesign to generate report in HTML and pdf. It looks fine in PDF , still not in HTML. I am facing this issue from a long time, tried many work around, no luck, finally dropped here.

It will be great if I get help for HTML.

Thanks a lot in advance

mwilliams

Here's what my HTML output, with the report I attached looks like:

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109007" data-time="1346428943" data-date="31 August 2012 - 09:02 AM">
Here's what my HTML output, with the report I attached looks like:

Happy_20

<blockquote class='ipsBlockquote' data-author="'Happy_20'" data-cid="109010" data-time="1346435627" data-date="31 August 2012 - 10:53 AM">
So , by any chance do you why different html outputs are generated? I am using firefox 14. Do you think it is because of browser? </blockquote>

mwilliams

What browser are you using? My screenshot was using Chrome. IE and Firefox look the same, for me.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109012" data-time="1346439232" data-date="31 August 2012 - 11:53 AM">
What browser are you using? My screenshot was using Chrome. IE and Firefox look the same, for me. </blockquote>
 
Firefox 14 in ubuntu

mwilliams

What happens if you select the row of the grid, in the header cell, and increase the row height to .75in or something?

Happy_20

Hey mwilliams,

Thank you so much. The problem was, in the HTML web page we were calling the HTML report, for this particular case, it set the margin to 1.2 (which was added dynamically during run-time). I had to put a condition saying that when a report is generated, remove the margin. It worked.

Thanks a lot for your help and guidance.

mwilliams

Great! Glad it's working, now!