Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT Output horizontally(BIRT Output horizontally)
BIRT Output horizontally [message #555189] Wed, 25 August 2010 18:27 Go to next message
Veena  is currently offline Veena
Messages: 3
Registered: August 2010
Junior Member
Hi,
Question : I want the data to be in a horizontal format in Eclipse BIRT Report.

Ex: Names
Rai
Jones
Barnes

But I want this data to be in a horizontal manner like below.
Desired output : Rai Jones Barnes

Please Help me out.

Re: BIRT Output horizontally [message #555246 is a reply to message #555189] Thu, 26 August 2010 04:19 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Usually we use a crosstab item for this. Just create a simple cube with
only one group and no measures and drag the group on to the xtab column
header. See attached.

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</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="7">
<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="8">
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<text-property
name="displayName">ORDERNUMBER</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
</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>
</list-property>
<xml-property name="queryText"><![CDATA[select ordernumber
from orders
where ordernumber < 10104]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</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="20">
<property name="dimensions">
<tabular-dimension name="Group" id="30">
<property
name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy"
id="31">
<property name="levels">
<tabular-level name="ORDERNUMBER" id="32">
<property
name="dataType">integer</property>
<property
name="columnName">ORDERNUMBER</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="21"/>
</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>
<style name="NewStyle" id="19">
<property name="display">inline</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property
name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="45">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<text-property
name="displayName">ORDERNUMBER</text-property>
<expression name="expression"
type="javascript">dataSetRow["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
</list-property>
<column id="54"/>
<header>
<row id="46">
<cell id="47">
<label id="48">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="49">
<cell id="50">
<data id="51">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="52">
<cell id="53"/>
</row>
</footer>
</table>
<extended-item extensionName="Crosstab"
extensionVersion="2.5.0" id="33">
<property name="rows">
<extended-item extensionName="CrosstabView" id="35"/>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="40">
<property name="views">
<extended-item extensionName="DimensionView"
id="41">
<property name="dimension">Group</property>
<property name="levels">
<extended-item
extensionName="LevelView" name="NewLevel View" id="42">
<property
name="level">Group/ORDERNUMBER</property>
<property name="member">
<extended-item
extensionName="CrosstabCell" id="43">
<property name="content">
<data
name="ORDERNUMBER" id="44">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</property>
<property
name="width">1.6770833333333333in</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="34">
<property name="width">0.11458333333333333in</property>
</extended-item>
</property>
<property name="cube">Data Cube</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ORDERNUMBER</property>
<expression
name="expression">dimension["Group"]["ORDERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
</list-property>
</extended-item>
</body>
</report>


On 8/25/2010 2:27 PM, Veena wrote:
> Hi,
> Question : I want the data to be in a horizontal format in Eclipse BIRT
> Report.
>
> Ex: Names
> Rai
> Jones
> Barnes
>
> But I want this data to be in a horizontal manner like below.
> Desired output : Rai Jones Barnes
>
> Please Help me out.
>
>
Re: BIRT Output horizontally [message #658819 is a reply to message #555246] Wed, 09 March 2011 22:14 Go to previous messageGo to next message
Raishad is currently offline Raishad
Messages: 77
Registered: July 2009
Member
How can this work for large amounts of data? Can it be made to wrap by
every x columns?

Here is the scenario, we have a header detail report. For an example,
take like a grade report. Is that possible?

Header
Name: ID:

Detail
CLASS CLASS CLASS CLASS
SEMESTER SEMESTER SEMESTER SEMESTER
GRADE GRADE GRADE GRADE

CLASS CLASS CLASS CLASS
SEMESTER SEMESTER SEMESTER SEMESTER
GRADE GRADE GRADE GRADE

CLASS CLASS CLASS CLASS
SEMESTER SEMESTER SEMESTER SEMESTER
GRADE GRADE GRADE GRADE

On 8/25/10 11:19 PM, Jason Weathersby wrote:
> Usually we use a crosstab item for this. Just create a simple cube with
> only one group and no measures and drag the group on to the xtab column
> header. See attached.
>
> Jason
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208
> Build &lt;2.5.2.v20100210-0630></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</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="7">
> <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="8">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">ORDERNUMBER</property>
> <text-property name="displayName">ORDERNUMBER</text-property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </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>
> </list-property>
> <xml-property name="queryText"><![CDATA[select ordernumber
> from orders
> where ordernumber < 10104]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ORDERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>ORDERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ORDERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</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="20">
> <property name="dimensions">
> <tabular-dimension name="Group" id="30">
> <property name="defaultHierarchy">NewTabularHierarchy</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy" id="31">
> <property name="levels">
> <tabular-level name="ORDERNUMBER" id="32">
> <property name="dataType">integer</property>
> <property name="columnName">ORDERNUMBER</property>
> </tabular-level>
> </property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> </property>
> <property name="measureGroups">
> <tabular-measure-group name="Summary Field" id="21"/>
> </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>
> <style name="NewStyle" id="19">
> <property name="display">inline</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="45">
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <text-property name="displayName">ORDERNUMBER</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="54"/>
> <header>
> <row id="46">
> <cell id="47">
> <label id="48">
> <text-property name="text">ORDERNUMBER</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="49">
> <cell id="50">
> <data id="51">
> <property name="resultSetColumn">ORDERNUMBER</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="52">
> <cell id="53"/>
> </row>
> </footer>
> </table>
> <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="33">
> <property name="rows">
> <extended-item extensionName="CrosstabView" id="35"/>
> </property>
> <property name="columns">
> <extended-item extensionName="CrosstabView" id="40">
> <property name="views">
> <extended-item extensionName="DimensionView" id="41">
> <property name="dimension">Group</property>
> <property name="levels">
> <extended-item extensionName="LevelView" name="NewLevel View" id="42">
> <property name="level">Group/ORDERNUMBER</property>
> <property name="member">
> <extended-item extensionName="CrosstabCell" id="43">
> <property name="content">
> <data name="ORDERNUMBER" id="44">
> <property name="resultSetColumn">ORDERNUMBER</property>
> </data>
> </property>
> <property name="width">1.6770833333333333in</property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> <property name="header">
> <extended-item extensionName="CrosstabCell" id="34">
> <property name="width">0.11458333333333333in</property>
> </extended-item>
> </property>
> <property name="cube">Data Cube</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ORDERNUMBER</property>
> <expression
> name="expression">dimension["Group"]["ORDERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </extended-item>
> </body>
> </report>
>
>
> On 8/25/2010 2:27 PM, Veena wrote:
>> Hi,
>> Question : I want the data to be in a horizontal format in Eclipse BIRT
>> Report.
>>
>> Ex: Names
>> Rai
>> Jones
>> Barnes
>>
>> But I want this data to be in a horizontal manner like below.
>> Desired output : Rai Jones Barnes
>>
>> Please Help me out.
>>
>>
>
Re: BIRT Output horizontally [message #658998 is a reply to message #658819] Thu, 10 March 2011 16:09 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

A crosstab can be made to page break every x number of columns, but that
does not sound like what you want. In your case I would add multiple
tables tied to the same dataset and filter on row number. Add a
computed column to the dataset that does a running count to get a row
number you can filter on. To see an example of this look at the
attached report that has a grid with two columns. In each column is a
table. One table is filtered to show odd rownum and the other is
filtered to show even.

In your case I would also add two more details rows for a total of 3 one
for class, one for semester and the last for grade.


Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
id="1">
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company
Name here>></property>
<property name="createdBy">Eclipse BIRT Designer Version
2.6.1.v20100902 Build &lt;2.6.1.v20100915-1750></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-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="Data Set" id="7">
<list-property name="computedColumns">
<structure>
<property name="name">rwc</property>
<expression
name="expression">row["ORDERNUMBER"]</expression>
<property name="dataType">integer</property>
<property
name="aggregateFunction">RUNNINGCOUNT</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">ORDERNUMBER</property>
<text-property
name="displayName">ORDERNUMBER</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTCODE</property>
<text-property
name="displayName">PRODUCTCODE</text-property>
</structure>
<structure>
<property name="columnName">QUANTITYORDERED</property>
<text-property
name="displayName">QUANTITYORDERED</text-property>
</structure>
<structure>
<property name="columnName">PRICEEACH</property>
<text-property
name="displayName">PRICEEACH</text-property>
</structure>
<structure>
<property name="columnName">ORDERLINENUMBER</property>
<text-property
name="displayName">ORDERLINENUMBER</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">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">rwc</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORDERNUMBER</property>
<property name="nativeName">ORDERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">PRODUCTCODE</property>
<property name="nativeName">PRODUCTCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ORDERLINENUMBER</property>
<property name="nativeName">ORDERLINENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from orderdetails]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTCODE</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTCODE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTCODE</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYORDERED</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYORDERED</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYORDERED</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRICEEACH</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRICEEACH</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRICEEACH</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORDERLINENUMBER</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>ORDERLINENUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORDERLINENUMBER</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</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="42">
<property name="width">100%</property>
<column id="43"/>
<column id="44"/>
<row id="45">
<cell id="46">
<table id="8">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property
name="name">ORDERLINENUMBER</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property name="name">Column
Binding</property>
<expression
name="expression">row.__rownum</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">rwc</property>
<expression
name="expression">dataSetRow["rwc"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property name="operator">ne</property>
<expression
name="expr">row["rwc"]%2</expression>
<simple-property-list name="value1">
<value>0</value>
</simple-property-list>
</structure>
</list-property>
<column id="51"/>
<column id="37"/>
<column id="39"/>
<header>
<row id="9">
<cell id="48">
<label id="53">
<text-property
name="text">Computed row count</text-property>
</label>
</cell>
<cell id="10">
<label id="11">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="14">
<label id="15">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="20">
<cell id="49">
<data id="54">
<property
name="resultSetColumn">rwc</property>
</data>
</cell>
<cell id="21">
<data id="22">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
<cell id="25">
<data id="26">
<property
name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="31">
<cell id="50"/>
<cell id="32"/>
<cell id="34"/>
</row>
</footer>
</table>
</cell>
<cell id="47">
<table id="55">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property
name="name">ORDERNUMBER</property>
<expression
name="expression">dataSetRow["ORDERNUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property
name="name">PRODUCTCODE</property>
<expression
name="expression">dataSetRow["PRODUCTCODE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property
name="name">QUANTITYORDERED</property>
<expression
name="expression">dataSetRow["QUANTITYORDERED"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property name="name">PRICEEACH</property>
<expression
name="expression">dataSetRow["PRICEEACH"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property
name="name">ORDERLINENUMBER</property>
<expression
name="expression">dataSetRow["ORDERLINENUMBER"]</expression >
<property
name="dataType">integer</property>
</structure>
<structure>
<property name="name">Column
Binding</property>
<expression
name="expression">row.__rownum</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">rwc</property>
<expression
name="expression">dataSetRow["rwc"]</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<list-property name="filter">
<structure>
<property name="operator">eq</property>
<expression
name="expr">row["rwc"]%2</expression>
<simple-property-list name="value1">
<value>0</value>
</simple-property-list>
</structure>
</list-property>
<column id="74"/>
<column id="75"/>
<column id="76"/>
<header>
<row id="56">
<cell id="57">
<label id="77">
<text-property
name="text">Computed row count</text-property>
</label>
</cell>
<cell id="59">
<label id="60">
<text-property
name="text">ORDERNUMBER</text-property>
</label>
</cell>
<cell id="61">
<label id="62">
<text-property
name="text">QUANTITYORDERED</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="63">
<cell id="64">
<data id="65">
<property
name="resultSetColumn">rwc</property>
</data>
</cell>
<cell id="66">
<data id="67">
<property
name="resultSetColumn">ORDERNUMBER</property>
</data>
</cell>
<cell id="68">
<data id="69">
<property
name="resultSetColumn">QUANTITYORDERED</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="70">
<cell id="71"/>
<cell id="72"/>
<cell id="73"/>
</row>
</footer>
</table>
</cell>
</row>
</grid>
</body>
</report>


On 3/9/2011 5:14 PM, Raishad Maharaj wrote:
> How can this work for large amounts of data? Can it be made to wrap by
> every x columns?
>
> Here is the scenario, we have a header detail report. For an example,
> take like a grade report. Is that possible?
>
> Header
> Name: ID:
>
> Detail
> CLASS CLASS CLASS CLASS
> SEMESTER SEMESTER SEMESTER SEMESTER
> GRADE GRADE GRADE GRADE
>
> CLASS CLASS CLASS CLASS
> SEMESTER SEMESTER SEMESTER SEMESTER
> GRADE GRADE GRADE GRADE
>
> CLASS CLASS CLASS CLASS
> SEMESTER SEMESTER SEMESTER SEMESTER
> GRADE GRADE GRADE GRADE
>
> On 8/25/10 11:19 PM, Jason Weathersby wrote:
>> Usually we use a crosstab item for this. Just create a simple cube with
>> only one group and no measures and drag the group on to the xtab column
>> header. See attached.
>>
>> Jason
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
>> id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208
>> Build &lt;2.5.2.v20100210-0630></property>
>> <property name="units">in</property>
>> <property name="iconFile">/templates/blank_report.gif</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="7">
>> <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="8">
>> <list-property name="columnHints">
>> <structure>
>> <property name="columnName">ORDERNUMBER</property>
>> <text-property name="displayName">ORDERNUMBER</text-property>
>> </structure>
>> </list-property>
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">ORDERNUMBER</property>
>> <property name="dataType">integer</property>
>> </structure>
>> </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>
>> </list-property>
>> <xml-property name="queryText"><![CDATA[select ordernumber
>> from orders
>> where ordernumber < 10104]]></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>1.0</Version>
>> <design:ResultSets derivedMetaData="true">
>> <design:resultSetDefinitions>
>> <design:resultSetColumns>
>> <design:resultColumnDefinitions>
>> <design:attributes>
>> <design:name>ORDERNUMBER</design:name>
>> <design:position>1</design:position>
>> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>> <design:precision>10</design:precision>
>> <design:scale>0</design:scale>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints>
>> <design:displayName>ORDERNUMBER</design:displayName>
>> </design:uiHints>
>> </design:attributes>
>> <design:usageHints>
>> <design:label>ORDERNUMBER</design:label>
>> <design:formattingHints>
>> <design:displaySize>11</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="20">
>> <property name="dimensions">
>> <tabular-dimension name="Group" id="30">
>> <property name="defaultHierarchy">NewTabularHierarchy</property>
>> <property name="hierarchies">
>> <tabular-hierarchy name="NewTabularHierarchy" id="31">
>> <property name="levels">
>> <tabular-level name="ORDERNUMBER" id="32">
>> <property name="dataType">integer</property>
>> <property name="columnName">ORDERNUMBER</property>
>> </tabular-level>
>> </property>
>> </tabular-hierarchy>
>> </property>
>> </tabular-dimension>
>> </property>
>> <property name="measureGroups">
>> <tabular-measure-group name="Summary Field" id="21"/>
>> </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>
>> <style name="NewStyle" id="19">
>> <property name="display">inline</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <page-footer>
>> <text id="3">
>> <property name="contentType">html</property>
>> <text-property name="content"><![CDATA[<value-of>new
>> Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <table id="45">
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">ORDERNUMBER</property>
>> <text-property name="displayName">ORDERNUMBER</text-property>
>> <expression name="expression"
>> type="javascript">dataSetRow["ORDERNUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> <column id="54"/>
>> <header>
>> <row id="46">
>> <cell id="47">
>> <label id="48">
>> <text-property name="text">ORDERNUMBER</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <detail>
>> <row id="49">
>> <cell id="50">
>> <data id="51">
>> <property name="resultSetColumn">ORDERNUMBER</property>
>> </data>
>> </cell>
>> </row>
>> </detail>
>> <footer>
>> <row id="52">
>> <cell id="53"/>
>> </row>
>> </footer>
>> </table>
>> <extended-item extensionName="Crosstab" extensionVersion="2.5.0" id="33">
>> <property name="rows">
>> <extended-item extensionName="CrosstabView" id="35"/>
>> </property>
>> <property name="columns">
>> <extended-item extensionName="CrosstabView" id="40">
>> <property name="views">
>> <extended-item extensionName="DimensionView" id="41">
>> <property name="dimension">Group</property>
>> <property name="levels">
>> <extended-item extensionName="LevelView" name="NewLevel View" id="42">
>> <property name="level">Group/ORDERNUMBER</property>
>> <property name="member">
>> <extended-item extensionName="CrosstabCell" id="43">
>> <property name="content">
>> <data name="ORDERNUMBER" id="44">
>> <property name="resultSetColumn">ORDERNUMBER</property>
>> </data>
>> </property>
>> <property name="width">1.6770833333333333in</property>
>> </extended-item>
>> </property>
>> </extended-item>
>> </property>
>> </extended-item>
>> </property>
>> </extended-item>
>> </property>
>> <property name="header">
>> <extended-item extensionName="CrosstabCell" id="34">
>> <property name="width">0.11458333333333333in</property>
>> </extended-item>
>> </property>
>> <property name="cube">Data Cube</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">ORDERNUMBER</property>
>> <expression
>> name="expression">dimension["Group"]["ORDERNUMBER"]</expression >
>> <property name="dataType">integer</property>
>> </structure>
>> </list-property>
>> </extended-item>
>> </body>
>> </report>
>>
>>
>> On 8/25/2010 2:27 PM, Veena wrote:
>>> Hi,
>>> Question : I want the data to be in a horizontal format in Eclipse BIRT
>>> Report.
>>>
>>> Ex: Names
>>> Rai
>>> Jones
>>> Barnes
>>>
>>> But I want this data to be in a horizontal manner like below.
>>> Desired output : Rai Jones Barnes
>>>
>>> Please Help me out.
>>>
>>>
>>
>
Previous Topic:PDF and image
Next Topic:Removing margin (whitespace) between table cells
Goto Forum:
  


Current Time: Mon Sep 22 12:34:00 GMT 2014

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

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