How to create this page in a report? [message #496130] |
Sun, 08 November 2009 21:45 |
Eclipse User |
|
|
|
Originally posted by: ddd.asd.com
Any ideas on how to create a page like this in a report?
http://img5.imageshack.us/img5/465/69456979.jpg
Each "CLOB" (large text object) are currently stored in a data set parameter
and then added to a table. But how do I make the section, subsection and
bullets?
And is there something better than a table for this? I have looked at list
but its basically just a table.
|
|
|
Re: How to create this page in a report? [message #496338 is a reply to message #496130] |
Mon, 09 November 2009 18:18 |
|
Use dynamic text elements for clob data. For bullets use text element
with content type set to html. For sections can you not just use groups
with labels in the group header section. For clob and bullets take a
look at this example.
Jason
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.5.1.v20090903 Build <2.5.1.v20090917-1447></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="118">
<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>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="119">
<list-property name="columnHints">
<structure>
<property name="columnName">PRODUCTLINE</property>
<text-property
name="displayName">PRODUCTLINE</text-property>
</structure>
<structure>
<property name="columnName">TEXTDESCRIPTION</property>
<text-property
name="displayName">TEXTDESCRIPTION</text-property>
</structure>
<structure>
<property name="columnName">HTMLDESCRIPTION</property>
<text-property
name="displayName">HTMLDESCRIPTION</text-property>
</structure>
<structure>
<property name="columnName">IMAGE</property>
<text-property name="displayName">IMAGE</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">TEXTDESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">HTMLDESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">IMAGE</property>
<property name="dataType">blob</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</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">2</property>
<property name="name">TEXTDESCRIPTION</property>
<property name="nativeName">TEXTDESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">HTMLDESCRIPTION</property>
<property name="nativeName">HTMLDESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">2005</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">IMAGE</property>
<property name="nativeName">IMAGE</property>
<property name="dataType">blob</property>
<property name="nativeDataType">2004</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from productlines]]></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>PRODUCTCODE</design:name>
<design:position>1</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>PRODUCTNAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>70</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTNAME</design:label>
<design:formattingHints>
<design:displaySize>70</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTLINE</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTLINE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTLINE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTSCALE</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTSCALE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTSCALE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTVENDOR</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTVENDOR</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTVENDOR</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRODUCTDESCRIPTION</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32700</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTDESCRIPTION</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTDESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>32700</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QUANTITYINSTOCK</design:name>
<design:position>7</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>QUANTITYINSTOCK</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYINSTOCK</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BUYPRICE</design:name>
<design:position>8</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>BUYPRICE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BUYPRICE</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>MSRP</design:name>
<design:position>9</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>MSRP</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>MSRP</design:label>
<design:formattingHints>
<design:displaySize>22</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="report" id="4">
<property name="fontFamily">"Verdana"</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>
<table id="120">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">PRODUCTLINE</property>
<text-property
name="displayName">PRODUCTLINE</text-property>
<expression
name="expression">dataSetRow["PRODUCTLINE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">TEXTDESCRIPTION</property>
<text-property
name="displayName">TEXTDESCRIPTION</text-property>
<expression
name="expression">dataSetRow["TEXTDESCRIPTION"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">HTMLDESCRIPTION</property>
<text-property
name="displayName">HTMLDESCRIPTION</text-property>
<expression
name="expression">dataSetRow["HTMLDESCRIPTION"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">IMAGE</property>
<text-property name="displayName">IMAGE</text-property>
<expression
name="expression">dataSetRow["IMAGE"]</expression>
<property name="dataType">blob</property>
</structure>
</list-property>
<column id="153"/>
<column id="144"/>
<column id="146"/>
<header>
<row id="121">
<cell id="150"/>
<cell id="122"/>
<cell id="126"/>
</row>
</header>
<group id="155">
<property name="groupName">NewTableGroup1</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr"
type="javascript">row["PRODUCTLINE"]</expression>
<structure name="toc">
<expression name="expressionValue"
type="javascript">row["PRODUCTLINE"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="156">
<cell id="157">
<text id="154">
<property
name="contentType">html</property>
<text-property name="content"><![CDATA[<LI>
<VALUE-OF>row["PRODUCTLINE"]</VALUE-OF>
</LI>]]></text-property>
</text>
</cell>
<cell id="158">
<label id="123">
<text-property
name="text">PRODUCTLINE</text-property>
</label>
</cell>
<cell id="159">
<label id="127">
<text-property
name="text">HTMLDESCRIPTION</text-property>
</label>
</cell>
</row>
</header>
<footer>
<row id="160">
<cell id="161"/>
<cell id="162"/>
<cell id="163"/>
</row>
</footer>
</group>
<detail>
<row id="130">
<cell id="151"/>
<cell id="131">
<data id="132">
<property
name="resultSetColumn">PRODUCTLINE</property>
</data>
</cell>
<cell id="135">
<text-data id="148">
<expression
name="valueExpr">row["HTMLDESCRIPTION"]</expression>
<property name="contentType">html</property>
</text-data>
</cell>
</row>
</detail>
<footer>
<row id="139">
<cell id="152"/>
<cell id="140"/>
<cell id="142"/>
</row>
</footer>
</table>
</body>
</report>
klm wrote:
> Any ideas on how to create a page like this in a report?
>
> http://img5.imageshack.us/img5/465/69456979.jpg
>
> Each "CLOB" (large text object) are currently stored in a data set
> parameter and then added to a table. But how do I make the section,
> subsection and bullets?
>
> And is there something better than a table for this? I have looked at
> list but its basically just a table.
|
|
|
Powered by
FUDForum. Page generated in 0.03717 seconds