Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » PDF Export truncated from right
icon10.gif  PDF Export truncated from right [message #495313] Wed, 04 November 2009 14:58 Go to next message
Mehrab is currently offline Mehrab Friend
Messages: 2
Registered: July 2009
Junior Member
Hi All
I am using BIRT 2.5. I have a report with 14 columns. So all the columns are narrow. When I want to pdf export and column contain a big word then it truncated the word. But I want to view the whole word. Is their any solution?

Thanks in advance.

Here is my rptdesign

<?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.0.v20090603 Build &lt;2.5.0.v20090617-0630></property>
<property name="layoutPreference">auto layout</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="103">
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
<property name="odaURL">jdbc:oracle:thin:@192.168.174.25:1521:BDEV</property >
<property name="odaUser">mferdous</property>
<encrypted-property name="odaPassword" encryptionID="base64">YW5hYmFzZQ==</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Main_Data_Set" id="104">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COMM_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CREATOR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CV_LAST_UPDATED</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">FDA_OUTCOME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">FIRST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">LAST_MODIFIED</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">LAST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MIDDLE_INITIAL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MIDDLE_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MODIFIER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PERSON_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">TRIALS_FDA</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">TRIALS_INDUSTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">RID</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COMM_ID</property>
<property name="nativeName">COMM_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CREATOR</property>
<property name="nativeName">CREATOR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CV_LAST_UPDATED</property>
<property name="nativeName">CV_LAST_UPDATED</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">FDA_OUTCOME</property>
<property name="nativeName">FDA_OUTCOME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">FIRST_NAME</property>
<property name="nativeName">FIRST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">LAST_MODIFIED</property>
<property name="nativeName">LAST_MODIFIED</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">LAST_NAME</property>
<property name="nativeName">LAST_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MIDDLE_INITIAL</property>
<property name="nativeName">MIDDLE_INITIAL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MIDDLE_NAME</property>
<property name="nativeName">MIDDLE_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MODIFIER</property>
<property name="nativeName">MODIFIER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PERSON_ID</property>
<property name="nativeName">PERSON_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">TRIALS_FDA</property>
<property name="nativeName">TRIALS_FDA</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">TRIALS_INDUSTRY</property>
<property name="nativeName">TRIALS_INDUSTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">RID</property>
<property name="nativeName">RID</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[ SELECT SIMS.PERSON."COMM_ID" AS "COMM_ID",SIMS.PERSON."CREATOR" AS "CREATOR",SIMS.PERSON."CV_LAST_UPDATED" AS "CV_LAST_UPDATED",SIMS.PERSON."FDA_OUTCOME" AS "FDA_OUTCOME",SIMS.PERSON."FIRST_NAME" AS "FIRST_NAME",SIMS.PERSON."LAST_MODIFIED" AS "LAST_MODIFIED",SIMS.PERSON."LAST_NAME" AS "LAST_NAME",SIMS.PERSON."MIDDLE_INITIAL" AS "MIDDLE_INITIAL",SIMS.PERSON."MIDDLE_NAME" AS "MIDDLE_NAME",SIMS.PERSON."MODIFIER" AS "MODIFIER",SIMS.PERSON."PERSON_ID" AS "PERSON_ID",SIMS.PERSON."TRIALS_FDA" AS "TRIALS_FDA",SIMS.PERSON."TRIALS_INDUSTRY" AS "TRIALS_INDUSTRY",SIMS.PERSON."RID" AS "RID" FROM SIMS.PERSON WHERE ( SIMS.PERSON."CREATOR" = 'WWOOD' ) ]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab-cell" id="2">
<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="3">
<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="Report_Title_Style" id="4">
<property name="backgroundColor">#A9B2FD</property>
<property name="fontFamily">"Arial"</property>
<property name="fontSize">12px</property>
<property name="fontWeight">bold</property>
</style>
<style name="Tpo_Label" id="5">
<property name="fontFamily">"Verdana"</property>
<property name="fontWeight">bold</property>
<property name="color">#FF0000</property>
</style>
<style name="App_Name" id="6">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="color">#4F687A</property>
</style>
<style name="Parameters" id="7">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
</style>
<style name="Date" id="8">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
</style>
<style name="TH_Lebel" id="9">
<property name="fontSize">12px</property>
<property name="fontWeight">bold</property>
<property name="color">#F7F7F7</property>
<property name="borderBottomColor">#F7F7F7</property>
<property name="borderRightColor">#D1D0D0</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0px</property>
</style>
<style name="Table_Data" id="10">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">12px</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="paddingTop">2pt</property>
<property name="paddingLeft">2pt</property>
<property name="paddingBottom">2pt</property>
<property name="paddingRight">2pt</property>
</style>
<style name="Statistical_Data" id="11">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
<property name="borderBottomColor">#4F687A</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopColor">#4F687A</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="paddingTop">1pt</property>
<property name="paddingLeft">1pt</property>
<property name="paddingBottom">1pt</property>
<property name="paddingRight">1pt</property>
<property name="textAlign">left</property>
</style>
<style name="GroupBy" id="12">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
</style>
<style name="sub_table" id="13">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">smaller</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="textAlign">center</property>
</style>
<style name="Master_table" id="14">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="SubReport_TH_Lebel" id="15">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">12px</property>
<property name="fontWeight">bold</property>
</style>
<style name="SubReport_Title_Lebel" id="16">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">12px</property>
<property name="fontWeight">bold</property>
</style>
<style name="Confidential" id="17">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
<property name="color">#FF0000</property>
<property name="textAlign">right</property>
</style>
<style name="copyright" id="18">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
</style>
<style name="footerGridStyle" id="19">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="pageNo" id="20">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">11pt</property>
<property name="textAlign">right</property>
</style>
<style name="background_color" id="21">
<property name="backgroundColor">#CFD3FF</property>
</style>
<style name="table_header" id="22">
<property name="backgroundColor">#4F687A</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">x-small</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="textAlign">left</property>
</style>
<style name="title_and_logo" id="23">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">14px</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#4F687A</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopColor">#4F687A</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="border_bottom" id="24">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
</style>
<style name="border_top" id="25">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="border_bottom_right" id="26">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</style>
<style name="border_right" id="27">
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</style>
<style name="fcount_table" id="28">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">x-small</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="row_background_color" id="29">
<property name="backgroundColor">#FF8040</property>
</style>
<style name="report_title" id="30">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">14px</property>
<property name="fontWeight">bold</property>
</style>
<style name="border_left_right" id="31">
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
</style>
<style name="First_Column_Table_Data" id="32">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">12px</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="paddingTop">2pt</property>
<property name="paddingLeft">2pt</property>
<property name="paddingBottom">2pt</property>
<property name="paddingRight">2pt</property>
</style>
<style name="groupby_header_cell" id="33">
<property name="backgroundColor">#D4D0C8</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Master Page" id="34">
<property name="type">a4</property>
<property name="orientation">landscape</property>
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.5in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.5in</property>
</simple-master-page>
</page-setup>
<body>
<table name="MasterTable" id="109">
<property name="style">Master_table</property>
<property name="width">100%</property>
<property name="dataSet">Main_Data_Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">COMM_ID</property>
<expression name="expression">dataSetRow["COMM_ID"]</expression>
</structure>
<structure>
<property name="name">CREATOR</property>
<expression name="expression">dataSetRow["CREATOR"]</expression>
</structure>
<structure>
<property name="name">CV_LAST_UPDATED</property>
<expression name="expression">dataSetRow["CV_LAST_UPDATED"]</expression >
</structure>
<structure>
<property name="name">FDA_OUTCOME</property>
<expression name="expression">dataSetRow["FDA_OUTCOME"]</expression >
</structure>
<structure>
<property name="name">FIRST_NAME</property>
<expression name="expression">dataSetRow["FIRST_NAME"]</expression>
</structure>
<structure>
<property name="name">LAST_MODIFIED</property>
<expression name="expression">dataSetRow["LAST_MODIFIED"]</expression >
</structure>
<structure>
<property name="name">LAST_NAME</property>
<expression name="expression">dataSetRow["LAST_NAME"]</expression>
</structure>
<structure>
<property name="name">MIDDLE_INITIAL</property>
<expression name="expression">dataSetRow["MIDDLE_INITIAL"]</expression >
</structure>
<structure>
<property name="name">MIDDLE_NAME</property>
<expression name="expression">dataSetRow["MIDDLE_NAME"]</expression >
</structure>
<structure>
<property name="name">MODIFIER</property>
<expression name="expression">dataSetRow["MODIFIER"]</expression>
</structure>
<structure>
<property name="name">PERSON_ID</property>
<expression name="expression">dataSetRow["PERSON_ID"]</expression>
</structure>
<structure>
<property name="name">TRIALS_FDA</property>
<expression name="expression">dataSetRow["TRIALS_FDA"]</expression>
</structure>
<structure>
<property name="name">TRIALS_INDUSTRY</property>
<expression name="expression">dataSetRow["TRIALS_INDUSTRY"]</expression >
</structure>
<structure>
<property name="name">RID</property>
<expression name="expression">dataSetRow["RID"]</expression>
</structure>
</list-property>
<property name="repeatHeader">true</property>
<column id="140"/>
<column id="141"/>
<column id="142"/>
<column id="143"/>
<column id="144"/>
<column id="145"/>
<column id="146"/>
<column id="147"/>
<column id="148"/>
<column id="149"/>
<column id="150"/>
<column id="151"/>
<column id="152"/>
<column id="153"/>
<header>
<row id="110">
<property name="height">22px</property>
<property name="style">table_header</property>
<cell id="111">
<property name="style">border_left_right</property>
<label id="154">
<property name="style">TH_Lebel</property>
<text-property name="text">COMM_ID</text-property>
</label>
</cell>
<cell id="112">
<property name="style">border_right</property>
<label id="155">
<property name="style">TH_Lebel</property>
<text-property name="text">CREATOR</text-property>
</label>
</cell>
<cell id="113">
<property name="style">border_right</property>
<label id="156">
<property name="style">TH_Lebel</property>
<text-property name="text">CV_LAST_UPDATED</text-property>
</label>
</cell>
<cell id="114">
<property name="style">border_right</property>
<label id="157">
<property name="style">TH_Lebel</property>
<text-property name="text">FDA_OUTCOME</text-property>
</label>
</cell>
<cell id="115">
<property name="style">border_right</property>
<label id="158">
<property name="style">TH_Lebel</property>
<text-property name="text">FIRST_NAME</text-property>
</label>
</cell>
<cell id="116">
<property name="style">border_right</property>
<label id="159">
<property name="style">TH_Lebel</property>
<text-property name="text">LAST_MODIFIED</text-property>
</label>
</cell>
<cell id="117">
<property name="style">border_right</property>
<label id="160">
<property name="style">TH_Lebel</property>
<text-property name="text">LAST_NAME</text-property>
</label>
</cell>
<cell id="118">
<property name="style">border_right</property>
<label id="161">
<property name="style">TH_Lebel</property>
<text-property name="text">MIDDLE_INITIAL</text-property>
</label>
</cell>
<cell id="119">
<property name="style">border_right</property>
<label id="162">
<property name="style">TH_Lebel</property>
<text-property name="text">MIDDLE_NAME</text-property>
</label>
</cell>
<cell id="120">
<property name="style">border_right</property>
<label id="163">
<property name="style">TH_Lebel</property>
<text-property name="text">MODIFIER</text-property>
</label>
</cell>
<cell id="121">
<property name="style">border_right</property>
<label id="164">
<property name="style">TH_Lebel</property>
<text-property name="text">PERSON_ID</text-property>
</label>
</cell>
<cell id="122">
<property name="style">border_right</property>
<label id="165">
<property name="style">TH_Lebel</property>
<text-property name="text">TRIALS_FDA</text-property>
</label>
</cell>
<cell id="123">
<property name="style">border_right</property>
<label id="166">
<property name="style">TH_Lebel</property>
<text-property name="text">TRIALS_INDUSTRY</text-property>
</label>
</cell>
<cell id="124">
<property name="style">border_right</property>
<label id="167">
<property name="style">TH_Lebel</property>
<text-property name="text">RID</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="125">
<list-property name="highlightRules">
<structure>
<property name="operator">eq</property>
<property name="backgroundColor">#DBE4EE</property>
<expression name="testExpr">row[0] % 2</expression>
<simple-property-list name="value1">
<value>0</value>
</simple-property-list>
</structure>
</list-property>
<cell id="126">
<property name="style">First_Column_Table_Data</property>
<data id="168">
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["COMM_ID"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">COMM_ID</property>
</data>
</cell>
<cell id="127">
<property name="style">Table_Data</property>
<data id="169">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["CREATOR"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">CREATOR</property>
</data>
</cell>
<cell id="128">
<property name="style">Table_Data</property>
<data id="170">
<structure name="dateTimeFormat">
<property name="category">Medium Date</property>
<property name="pattern">Medium Date</property>
</structure>
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["CV_LAST_UPDATED"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">CV_LAST_UPDATED</property>
</data>
</cell>
<cell id="129">
<property name="style">Table_Data</property>
<data id="171">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["FDA_OUTCOME"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">FDA_OUTCOME</property>
</data>
</cell>
<cell id="130">
<property name="style">Table_Data</property>
<data id="172">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["FIRST_NAME"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">FIRST_NAME</property>
</data>
</cell>
<cell id="131">
<property name="style">Table_Data</property>
<data id="173">
<structure name="dateTimeFormat">
<property name="category">Medium Date</property>
<property name="pattern">Medium Date</property>
</structure>
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["LAST_MODIFIED"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">LAST_MODIFIED</property>
</data>
</cell>
<cell id="132">
<property name="style">Table_Data</property>
<data id="174">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["LAST_NAME"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">LAST_NAME</property>
</data>
</cell>
<cell id="133">
<property name="style">Table_Data</property>
<data id="175">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["MIDDLE_INITIAL"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">MIDDLE_INITIAL</property>
</data>
</cell>
<cell id="134">
<property name="style">Table_Data</property>
<data id="176">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["MIDDLE_NAME"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">MIDDLE_NAME</property>
</data>
</cell>
<cell id="135">
<property name="style">Table_Data</property>
<data id="177">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["MODIFIER"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">MODIFIER</property>
</data>
</cell>
<cell id="136">
<property name="style">Table_Data</property>
<data id="178">
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["PERSON_ID"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">PERSON_ID</property>
</data>
</cell>
<cell id="137">
<property name="style">Table_Data</property>
<data id="179">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["TRIALS_FDA"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">TRIALS_FDA</property>
</data>
</cell>
<cell id="138">
<property name="style">Table_Data</property>
<data id="180">
<property name="textAlign">left</property>
<list-property name="mapRules">
<structure>
<expression name="testExpr">row["TRIALS_INDUSTRY"]</expression>
<property name="operator">is-null</property>
<text-property name="display">--</text-property>
</structure>
</list-property>
<property name="resultSetColumn">TRIALS_INDUSTRY</property>
</data>
</cell>
<cell id="139">
<property name="style">Table_Data</property>
<data id="181">
<list-property name="mapRules">

Report message to a moderator

Re: PDF Export truncated from right [message #495350 is a reply to message #495313] Wed, 04 November 2009 16:00 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Mehrab,

Have you tried this with 2.5.1 and how are you exporting it?

Jason

Mehrab wrote:
> Hi All
> I am using BIRT 2.5. I have a report with 14 columns. So all the columns
> are narrow. When I want to pdf export and column contain a big word then
> it truncated the word. But I want to view the whole word. Is their any
> solution?
>
> Thanks in advance.
> Here is my rptdesign
> <?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.0.v20090603 Build <2.5.0.v20090617-0630></property>
> <property name="layoutPreference">auto layout</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="103">
> <property
> name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
> <property
> name="odaURL">jdbc:oracle:thin:@192.168.174.25:1521:BDEV</property >
> <property name="odaUser">mferdous</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">YW5hYmFzZQ==</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Main_Data_Set" id="104">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COMM_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CREATOR</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CV_LAST_UPDATED</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">FDA_OUTCOME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">FIRST_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">LAST_MODIFIED</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">LAST_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">MIDDLE_INITIAL</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">MIDDLE_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MODIFIER</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PERSON_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">TRIALS_FDA</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">TRIALS_INDUSTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">RID</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COMM_ID</property>
> <property name="nativeName">COMM_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CREATOR</property>
> <property name="nativeName">CREATOR</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CV_LAST_UPDATED</property>
> <property name="nativeName">CV_LAST_UPDATED</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">FDA_OUTCOME</property>
> <property name="nativeName">FDA_OUTCOME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">FIRST_NAME</property>
> <property name="nativeName">FIRST_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">LAST_MODIFIED</property>
> <property name="nativeName">LAST_MODIFIED</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">LAST_NAME</property>
> <property name="nativeName">LAST_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">MIDDLE_INITIAL</property>
> <property name="nativeName">MIDDLE_INITIAL</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">MIDDLE_NAME</property>
> <property name="nativeName">MIDDLE_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MODIFIER</property>
> <property name="nativeName">MODIFIER</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PERSON_ID</property>
> <property name="nativeName">PERSON_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">TRIALS_FDA</property>
> <property name="nativeName">TRIALS_FDA</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">TRIALS_INDUSTRY</property>
> <property name="nativeName">TRIALS_INDUSTRY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">RID</property>
> <property name="nativeName">RID</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[ SELECT
> SIMS.PERSON."COMM_ID" AS "COMM_ID",SIMS.PERSON."CREATOR" AS
> "CREATOR",SIMS.PERSON."CV_LAST_UPDATED" AS
> "CV_LAST_UPDATED",SIMS.PERSON."FDA_OUTCOME" AS
> "FDA_OUTCOME",SIMS.PERSON."FIRST_NAME" AS
> "FIRST_NAME",SIMS.PERSON."LAST_MODIFIED" AS
> "LAST_MODIFIED",SIMS.PERSON."LAST_NAME" AS
> "LAST_NAME",SIMS.PERSON."MIDDLE_INITIAL" AS
> "MIDDLE_INITIAL",SIMS.PERSON."MIDDLE_NAME" AS
> "MIDDLE_NAME",SIMS.PERSON."MODIFIER" AS
> "MODIFIER",SIMS.PERSON."PERSON_ID" AS
> "PERSON_ID",SIMS.PERSON."TRIALS_FDA" AS
> "TRIALS_FDA",SIMS.PERSON."TRIALS_INDUSTRY" AS
> "TRIALS_INDUSTRY",SIMS.PERSON."RID" AS "RID" FROM SIMS.PERSON WHERE (
> SIMS.PERSON."CREATOR" = 'WWOOD' ) ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab-cell" id="2">
> <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="3">
> <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="Report_Title_Style" id="4">
> <property name="backgroundColor">#A9B2FD</property>
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">12px</property>
> <property name="fontWeight">bold</property>
> </style>
> <style name="Tpo_Label" id="5">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FF0000</property>
> </style>
> <style name="App_Name" id="6">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">small</property>
> <property name="fontWeight">bold</property>
> <property name="color">#4F687A</property>
> </style>
> <style name="Parameters" id="7">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> </style>
> <style name="Date" id="8">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> </style>
> <style name="TH_Lebel" id="9">
> <property name="fontSize">12px</property>
> <property name="fontWeight">bold</property>
> <property name="color">#F7F7F7</property>
> <property name="borderBottomColor">#F7F7F7</property>
> <property name="borderRightColor">#D1D0D0</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">0px</property>
> </style>
> <style name="Table_Data" id="10">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">12px</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="paddingTop">2pt</property>
> <property name="paddingLeft">2pt</property>
> <property name="paddingBottom">2pt</property>
> <property name="paddingRight">2pt</property>
> </style>
> <style name="Statistical_Data" id="11">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> <property name="borderBottomColor">#4F687A</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopColor">#4F687A</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="paddingTop">1pt</property>
> <property name="paddingLeft">1pt</property>
> <property name="paddingBottom">1pt</property>
> <property name="paddingRight">1pt</property>
> <property name="textAlign">left</property>
> </style>
> <style name="GroupBy" id="12">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">left</property>
> </style>
> <style name="sub_table" id="13">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">smaller</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> </style>
> <style name="Master_table" id="14">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="SubReport_TH_Lebel" id="15">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">12px</property>
> <property name="fontWeight">bold</property>
> </style>
> <style name="SubReport_Title_Lebel" id="16">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">12px</property>
> <property name="fontWeight">bold</property>
> </style>
> <style name="Confidential" id="17">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> <property name="color">#FF0000</property>
> <property name="textAlign">right</property>
> </style>
> <style name="copyright" id="18">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> </style>
> <style name="footerGridStyle" id="19">
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="pageNo" id="20">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">11pt</property>
> <property name="textAlign">right</property>
> </style>
> <style name="background_color" id="21">
> <property name="backgroundColor">#CFD3FF</property>
> </style>
> <style name="table_header" id="22">
> <property name="backgroundColor">#4F687A</property>
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">x-small</property>
> <property name="fontWeight">bold</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="textAlign">left</property>
> </style>
> <style name="title_and_logo" id="23">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">14px</property>
> <property name="fontWeight">bold</property>
> <property name="borderBottomColor">#4F687A</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderTopColor">#4F687A</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="border_bottom" id="24">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> </style>
> <style name="border_top" id="25">
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="border_bottom_right" id="26">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> </style>
> <style name="border_right" id="27">
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> </style>
> <style name="fcount_table" id="28">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">x-small</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> <style name="row_background_color" id="29">
> <property name="backgroundColor">#FF8040</property>
> </style>
> <style name="report_title" id="30">
> <property name="fontFamily">"Arial"</property>
> <property name="fontSize">14px</property>
> <property name="fontWeight">bold</property>
> </style>
> <style name="border_left_right" id="31">
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> </style>
> <style name="First_Column_Table_Data" id="32">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">12px</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="paddingTop">2pt</property>
> <property name="paddingLeft">2pt</property>
> <property name="paddingBottom">2pt</property>
> <property name="paddingRight">2pt</property>
> </style>
> <style name="groupby_header_cell" id="33">
> <property name="backgroundColor">#D4D0C8</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Master Page" id="34">
> <property name="type">a4</property>
> <property name="orientation">landscape</property>
> <property name="topMargin">0.25in</property>
> <property name="leftMargin">0.5in</property>
> <property name="bottomMargin">0.25in</property>
> <property name="rightMargin">0.5in</property>
> </simple-master-page>
> </page-setup>
> <body>
> <table name="MasterTable" id="109">
> <property name="style">Master_table</property>
> <property name="width">100%</property>
> <property name="dataSet">Main_Data_Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">COMM_ID</property>
> <expression
> name="expression">dataSetRow["COMM_ID"]</expression>
> </structure>
> <structure>
> <property name="name">CREATOR</property>
> <expression
> name="expression">dataSetRow["CREATOR"]</expression>
> </structure>
> <structure>
> <property name="name">CV_LAST_UPDATED</property>
> <expression
> name="expression">dataSetRow["CV_LAST_UPDATED"]</expression >
> </structure>
> <structure>
> <property name="name">FDA_OUTCOME</property>
> <expression
> name="expression">dataSetRow["FDA_OUTCOME"]</expression >
> </structure>
> <structure>
> <property name="name">FIRST_NAME</property>
> <expression
> name="expression">dataSetRow["FIRST_NAME"]</expression>
> </structure>
> <structure>
> <property name="name">LAST_MODIFIED</property>
> <expression
> name="expression">dataSetRow["LAST_MODIFIED"]</expression >
> </structure>
> <structure>
> <property name="name">LAST_NAME</property>
> <expression
> name="expression">dataSetRow["LAST_NAME"]</expression>
> </structure>
> <structure>
> <property name="name">MIDDLE_INITIAL</property>
> <expression
> name="expression">dataSetRow["MIDDLE_INITIAL"]</expression >
> </structure>
> <structure>
> <property name="name">MIDDLE_NAME</property>
> <expression
> name="expression">dataSetRow["MIDDLE_NAME"]</expression >
> </structure>
> <structure>
> <property name="name">MODIFIER</property>
> <expression
> name="expression">dataSetRow["MODIFIER"]</expression>
> </structure>
> <structure>
> <property name="name">PERSON_ID</property>
> <expression
> name="expression">dataSetRow["PERSON_ID"]</expression>
> </structure>
> <structure>
> <property name="name">TRIALS_FDA</property>
> <expression
> name="expression">dataSetRow["TRIALS_FDA"]</expression>
> </structure>
> <structure>
> <property name="name">TRIALS_INDUSTRY</property>
> <expression
> name="expression">dataSetRow["TRIALS_INDUSTRY"]</expression >
> </structure>
> <structure>
> <property name="name">RID</property>
> <expression
> name="expression">dataSetRow["RID"]</expression>
> </structure>
> </list-property>
> <property name="repeatHeader">true</property>
> <column id="140"/>
> <column id="141"/>
> <column id="142"/>
> <column id="143"/>
> <column id="144"/>
> <column id="145"/>
> <column id="146"/>
> <column id="147"/>
> <column id="148"/>
> <column id="149"/>
> <column id="150"/>
> <column id="151"/>
> <column id="152"/>
> <column id="153"/>
> <header>
> <row id="110">
> <property name="height">22px</property>
> <property name="style">table_header</property>
> <cell id="111">
> <property name="style">border_left_right</property>
> <label id="154">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">COMM_ID</text-property>
> </label>
> </cell>
> <cell id="112">
> <property name="style">border_right</property>
> <label id="155">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">CREATOR</text-property>
> </label>
> </cell>
> <cell id="113">
> <property name="style">border_right</property>
> <label id="156">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">CV_LAST_UPDATED</text-property>
> </label>
> </cell>
> <cell id="114">
> <property name="style">border_right</property>
> <label id="157">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">FDA_OUTCOME</text-property>
> </label>
> </cell>
> <cell id="115">
> <property name="style">border_right</property>
> <label id="158">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">FIRST_NAME</text-property>
> </label>
> </cell>
> <cell id="116">
> <property name="style">border_right</property>
> <label id="159">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">LAST_MODIFIED</text-property>
> </label>
> </cell>
> <cell id="117">
> <property name="style">border_right</property>
> <label id="160">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">LAST_NAME</text-property>
> </label>
> </cell>
> <cell id="118">
> <property name="style">border_right</property>
> <label id="161">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">MIDDLE_INITIAL</text-property>
> </label>
> </cell>
> <cell id="119">
> <property name="style">border_right</property>
> <label id="162">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">MIDDLE_NAME</text-property>
> </label>
> </cell>
> <cell id="120">
> <property name="style">border_right</property>
> <label id="163">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">MODIFIER</text-property>
> </label>
> </cell>
> <cell id="121">
> <property name="style">border_right</property>
> <label id="164">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">PERSON_ID</text-property>
> </label>
> </cell>
> <cell id="122">
> <property name="style">border_right</property>
> <label id="165">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">TRIALS_FDA</text-property>
> </label>
> </cell>
> <cell id="123">
> <property name="style">border_right</property>
> <label id="166">
> <property name="style">TH_Lebel</property>
> <text-property
> name="text">TRIALS_INDUSTRY</text-property>
> </label>
> </cell>
> <cell id="124">
> <property name="style">border_right</property>
> <label id="167">
> <property name="style">TH_Lebel</property>
> <text-property name="text">RID</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="125">
> <list-property name="highlightRules">
> <structure>
> <property name="operator">eq</property>
> <property
> name="backgroundColor">#DBE4EE</property>
> <expression name="testExpr">row[0] %
> 2</expression>
> <simple-property-list name="value1">
> <value>0</value>
> </simple-property-list>
> </structure>
> </list-property>
> <cell id="126">
> <property
> name="style">First_Column_Table_Data</property>
> <data id="168">
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["COMM_ID"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">COMM_ID</property>
> </data>
> </cell>
> <cell id="127">
> <property name="style">Table_Data</property>
> <data id="169">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["CREATOR"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">CREATOR</property>
> </data>
> </cell>
> <cell id="128">
> <property name="style">Table_Data</property>
> <data id="170">
> <structure name="dateTimeFormat">
> <property name="category">Medium
> Date</property>
> <property name="pattern">Medium
> Date</property>
> </structure>
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["CV_LAST_UPDATED"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">CV_LAST_UPDATED</property>
> </data>
> </cell>
> <cell id="129">
> <property name="style">Table_Data</property>
> <data id="171">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["FDA_OUTCOME"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">FDA_OUTCOME</property>
> </data>
> </cell>
> <cell id="130">
> <property name="style">Table_Data</property>
> <data id="172">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["FIRST_NAME"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">FIRST_NAME</property>
> </data>
> </cell>
> <cell id="131">
> <property name="style">Table_Data</property>
> <data id="173">
> <structure name="dateTimeFormat">
> <property name="category">Medium
> Date</property>
> <property name="pattern">Medium
> Date</property>
> </structure>
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["LAST_MODIFIED"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">LAST_MODIFIED</property>
> </data>
> </cell>
> <cell id="132">
> <property name="style">Table_Data</property>
> <data id="174">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["LAST_NAME"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">LAST_NAME</property>
> </data>
> </cell>
> <cell id="133">
> <property name="style">Table_Data</property>
> <data id="175">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["MIDDLE_INITIAL"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">MIDDLE_INITIAL</property>
> </data>
> </cell>
> <cell id="134">
> <property name="style">Table_Data</property>
> <data id="176">
> <property name="textAlign">left</property>
> <list-property name="mapRules">
> <structure>
> <expression
> name="testExpr">row["MIDDLE_NAME"]</expression>
> <property
> name="operator">is-null</property>
> <text-property
> name="display">--</text-property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">MIDDLE_NAME</property>
> </data>
> </cell>
> <cell id="135">
> <property name="style">Table_Data</property>
> <data id="177">
> <property name="textAlign"

Report message to a moderator

Previous Topic:Report design - dynamic date formats
Next Topic:column with missing values sometimes not displayed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 06:47:00 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly