Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Masterpage orientation = landscape. Report prints and exports in portrait #2
Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #923501] Wed, 26 September 2012 00:39 Go to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member

Cant reply to my thread anymore. Same thing's happened a few times. I actually only have 4 or 5 posts. No idea where the 400+ came from Laughing

===
reply to : http://www.eclipse.org/forums/index.php/t/383902/
===


Hi Jason,

made no difference Sad

i fixed the watermark truncation when exporting to pdf by using pixels instead of inches when setting the size of the header grid.


the existing behaviour is
view in browser - print as html - prints as portrait. incorrect pagination (rows split over a page, wrong page numbers)

view in browser - print as pdf - fit on single page. tiny portrait table on landscape oriented page

view in browser - print as pdf - auto. Mostly correct now with the watermark showing. Some field truncation. Incorrect page numbers - there are 127 pages but every page shows 1 of 1. I use the following code in a dynamic text box in the footer

"Page " + pageNumber + " of " + totalPage;

I did notice that when i used the autotext "page n of m "that it worked correctly in PDF. Is there any way to format the auto text into a 'neater' format so that it doesnt look like
"1                          /                          1"?


<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_v20090521 Build &lt;2.3.2.v20090601-0700></property>
    <property name="units">in</property>
    <text-property name="title">REFUNDS AND REPAYMENTS AUTHORISED</text-property>
    <method name="initialize"><![CDATA[function wrap(longStr, width){
	length = longStr.length; 
	if(length <= width)
		return longStr;
	return (longStr.substring(0, width) + "\u200B" + wrap(longStr.substring(width, length), width)); 
}]]></method>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <list-property name="libraries">
        <structure>
            <property name="fileName">CAMSReportLibrary.config.rptlibrary</property>
            <property name="namespace">CAMSReportLibrary</property>
        </structure>
    </list-property>
    <parameters>
        <scalar-parameter name="FromDate" id="400">
            <property name="valueType">static</property>
            <property name="dataType">dateTime</property>
            <property name="paramType">simple</property>
            <text-property name="promptText">From Date</text-property>
            <property name="controlType">text-box</property>
            <property name="distinct">true</property>
            <structure name="format">
                <property name="category">Medium Date</property>
                <property name="pattern">Medium Date</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="ToDate" id="401">
            <property name="valueType">static</property>
            <property name="dataType">dateTime</property>
            <property name="paramType">simple</property>
            <text-property name="promptText">To Date</text-property>
            <property name="controlType">text-box</property>
            <property name="distinct">true</property>
            <structure name="format">
                <property name="category">Medium Date</property>
                <property name="pattern">Medium Date</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="JDBCmaximoDataSource" id="7"
 extends="CAMSReportLibrary.JDBCmaximoDataSource"/>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet" name="RefundsRepayments" id="402">
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">GroupID</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">GroupLabel</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CaseType</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">CaseNumber</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">Applicant</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">ApprovalDate</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">ApprovedBy</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">Amount</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">Reason</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">JDBCmaximoDataSource</property>
            <list-property name="parameters">
                <structure>
                    <property name="name">@FromDate</property>
                    <property name="paramName">FromDate</property>
                    <property name="nativeName">@FromDate</property>
                    <property name="dataType">dateTime</property>
                    <property name="nativeDataType">93</property>
                    <property name="position">1</property>
                    <property name="isOptional">true</property>
                    <property name="allowNull">true</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
                <structure>
                    <property name="name">@ToDate</property>
                    <property name="paramName">ToDate</property>
                    <property name="nativeName">@ToDate</property>
                    <property name="dataType">dateTime</property>
                    <property name="nativeDataType">93</property>
                    <property name="position">2</property>
                    <property name="isOptional">true</property>
                    <property name="allowNull">true</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">GroupID</property>
                    <property name="nativeName">GroupID</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">GroupLabel</property>
                    <property name="nativeName">GroupLabel</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CaseType</property>
                    <property name="nativeName">CaseType</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">CaseNumber</property>
                    <property name="nativeName">CaseNumber</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">Applicant</property>
                    <property name="nativeName">Applicant</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">ApprovalDate</property>
                    <property name="nativeName">ApprovalDate</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">ApprovedBy</property>
                    <property name="nativeName">ApprovedBy</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">Amount</property>
                    <property name="nativeName">Amount</property>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">Reason</property>
                    <property name="nativeName">Reason</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <property name="queryText">{call Report.usp_GetRefundsRepaymentsReport(?,?)} </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:DataSetParameters>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name>@FromDate</design:name>
        <design:position>1</design:position>
        <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
        <design:precision>23</design:precision>
        <design:scale>3</design:scale>
        <design:nullability>Nullable</design:nullability>
      </design:attributes>
      <design:inputAttributes>
        <design:elementAttributes>
          <design:optional>true</design:optional>
        </design:elementAttributes>
      </design:inputAttributes>
    </design:parameterDefinitions>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name>@ToDate</design:name>
        <design:position>2</design:position>
        <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
        <design:precision>23</design:precision>
        <design:scale>3</design:scale>
        <design:nullability>Nullable</design:nullability>
      </design:attributes>
      <design:inputAttributes>
        <design:elementAttributes>
          <design:optional>true</design:optional>
        </design:elementAttributes>
      </design:inputAttributes>
    </design:parameterDefinitions>
  </design:DataSetParameters>
</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="CAMS from to date Master Page" id="8" extends="CAMSReportLibrary.CAMS from to date Master Page">
            <overridden-values>
                <ref-entry baseId="378" name="HdrGrid" id="378"/>
                <ref-entry baseId="379" id="379"/>
                <ref-entry baseId="380" id="380"/>
                <ref-entry baseId="381" id="381"/>
                <ref-entry baseId="382" name="HdrTopGrid" id="382"/>
                <ref-entry baseId="383" id="383"/>
                <ref-entry baseId="384" id="384"/>
                <ref-entry baseId="385" id="385"/>
                <ref-entry baseId="386" id="386"/>
                <ref-entry baseId="387" name="SAWaterLogo" id="387"/>
                <ref-entry baseId="388" id="388"/>
                <ref-entry baseId="389" name="CamsTitle" id="389"/>
                <ref-entry baseId="390" id="390"/>
                <ref-entry baseId="391" id="391"/>
                <ref-entry baseId="392" name="HdrBottomGrid" id="392"/>
                <ref-entry baseId="393" id="393"/>
                <ref-entry baseId="394" id="394"/>
                <ref-entry baseId="395" id="395"/>
                <ref-entry baseId="396" id="396"/>
                <ref-entry baseId="397" name="RepTitle" id="397"/>
                <ref-entry baseId="398" id="398"/>
                <ref-entry baseId="399" name="ToFromLabel" id="399"/>
                <ref-entry baseId="283" name="FtrGrid" id="283"/>
                <ref-entry baseId="284" id="284"/>
                <ref-entry baseId="285" id="285"/>
                <ref-entry baseId="286" id="286"/>
                <ref-entry baseId="287" id="287"/>
                <ref-entry baseId="282" name="RunDate" id="282"/>
                <ref-entry baseId="288" id="288"/>
                <ref-entry baseId="302" name="PageNo" id="302"/>
            </overridden-values>
        </simple-master-page>
    </page-setup>
    <body>
        <label id="444">
            <text-property name="text"> </text-property>
        </label>
        <table id="73">
            <property name="fontSize">large</property>
            <property name="marginTop">1pt</property>
            <property name="marginLeft">1pt</property>
            <property name="marginBottom">1pt</property>
            <property name="marginRight">1pt</property>
            <property name="height">1.9895833333333333in</property>
            <property name="width">99.9%</property>
            <property name="dataSet">RefundsRepayments</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">GroupID</property>
                    <expression name="expression">dataSetRow["GroupID"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">GroupLabel</property>
                    <expression name="expression">dataSetRow["GroupLabel"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CaseType</property>
                    <expression name="expression">dataSetRow["CaseType"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CaseNumber</property>
                    <expression name="expression">dataSetRow["CaseNumber"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Applicant</property>
                    <expression name="expression">wrap(dataSetRow["Applicant"],25);</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">ApprovalDate</property>
                    <expression name="expression">dataSetRow["ApprovalDate"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">ApprovedBy</property>
                    <expression name="expression">dataSetRow["ApprovedBy"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Amount</property>
                    <expression name="expression">dataSetRow["Amount"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">Reason</property>
                    <expression name="expression">dataSetRow["Reason"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="107">
                <property name="width">0.8229166666666666in</property>
            </column>
            <column id="108">
                <property name="width">0.96875in</property>
            </column>
            <column id="109">
                <property name="width">1.698in</property>
            </column>
            <column id="110">
                <property name="width">0.9375in</property>
            </column>
            <column id="111">
                <property name="width">1.0833333333333333in</property>
            </column>
            <column id="112">
                <property name="width">1.1979166666666667in</property>
            </column>
            <column id="113">
                <property name="width">1.1145833333333333in</property>
            </column>
            <header>
                <row id="74">
                    <property name="backgroundColor">#7CC9FF</property>
                    <property name="fontFamily">"Verdana"</property>
                    <property name="fontSize">9pt</property>
                    <property name="fontWeight">bold</property>
                    <property name="borderBottomColor">#000000</property>
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">1px</property>
                    <property name="borderLeftColor">#000000</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">1px</property>
                    <property name="borderRightColor">#000000</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">1px</property>
                    <property name="borderTopColor">#000000</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">1pt</property>
                    <property name="textAlign">center</property>
                    <cell id="75">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <label id="428">
                            <text-property name="text">Case Type</text-property>
                        </label>
                    </cell>
                    <cell id="76">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <label id="430">
                            <text-property name="text">Case Number</text-property>
                        </label>
                    </cell>
                    <cell id="77">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <label id="432">
                            <text-property name="text">Applicant</text-property>
                        </label>
                    </cell>
                    <cell id="78">
                        <property name="colSpan">1</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">center</property>
                        <label id="434">
                            <text-property name="text">Approval Date</text-property>
                        </label>
                    </cell>
                    <cell id="427">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">center</property>
                        <label id="436">
                            <text-property name="text">Approved By</text-property>
                        </label>
                    </cell>
                    <cell id="80">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <label id="438">
                            <text-property name="text">Amount</text-property>
                        </label>
                    </cell>
                    <cell id="81">
                        <property name="backgroundColor">#7CC9FF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <label id="440">
                            <text-property name="text">Reason</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <group id="403">
                <property name="groupName">ReportGroup</property>
                <property name="interval">none</property>
                <property name="sortDirection">asc</property>
                <expression name="keyExpr">row["GroupID"]</expression>
                <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="404">
                        <cell id="405">
                            <property name="colSpan">7</property>
                            <property name="rowSpan">1</property>
                            <property name="borderBottomColor">#000000</property>
                            <property name="borderBottomStyle">solid</property>
                            <property name="borderBottomWidth">1px</property>
                            <property name="borderLeftColor">#000000</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">1px</property>
                            <property name="borderRightColor">#000000</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">1px</property>
                            <property name="borderTopColor">#000000</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">1px</property>
                            <data id="426">
                                <property name="resultSetColumn">GroupLabel</property>
                            </data>
                        </cell>
                    </row>
                </header>
            </group>
            <detail>
                <row id="85">
                    <property name="fontFamily">"Arial"</property>
                    <property name="fontSize">10pt</property>
                    <property name="fontStyle">normal</property>
                    <property name="borderBottomColor">#000000</property>
                    <property name="borderBottomStyle">solid</property>
                    <property name="borderBottomWidth">1pt</property>
                    <property name="borderLeftColor">#000000</property>
                    <property name="borderLeftStyle">solid</property>
                    <property name="borderLeftWidth">1pt</property>
                    <property name="borderRightColor">#000000</property>
                    <property name="borderRightStyle">solid</property>
                    <property name="borderRightWidth">1pt</property>
                    <property name="borderTopColor">#000000</property>
                    <property name="borderTopStyle">solid</property>
                    <property name="borderTopWidth">1pt</property>
                    <cell id="86">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="whiteSpace">normal</property>
                        <data id="429">
                            <property name="resultSetColumn">CaseType</property>
                        </data>
                    </cell>
                    <cell id="87">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="paddingTop">2pt</property>
                        <property name="paddingLeft">2pt</property>
                        <property name="paddingBottom">2pt</property>
                        <property name="paddingRight">2pt</property>
                        <property name="textAlign">center</property>
                        <data id="431">
                            <property name="resultSetColumn">CaseNumber</property>
                        </data>
                    </cell>
                    <cell id="88">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">left</property>
                        <data id="443">
                            <property name="resultSetColumn">Applicant</property>
                        </data>
                    </cell>
                    <cell id="89">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">center</property>
                        <data id="435">
                            <structure name="dateTimeFormat">
                                <property name="category">Medium Date</property>
                                <property name="pattern">Medium Date</property>
                            </structure>
                            <property name="resultSetColumn">ApprovalDate</property>
                        </data>
                    </cell>
                    <cell id="90">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">left</property>
                        <data id="437">
                            <property name="resultSetColumn">ApprovedBy</property>
                        </data>
                    </cell>
                    <cell id="91">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">right</property>
                        <data id="439">
                            <structure name="numberFormat">
                                <property name="category">Currency</property>
                                <property name="pattern">#,##0.00</property>
                            </structure>
                            <property name="resultSetColumn">Amount</property>
                        </data>
                    </cell>
                    <cell id="92">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">1px</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">1px</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">1px</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="textAlign">left</property>
                        <data id="441">
                            <property name="resultSetColumn">Reason</property>
                        </data>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>





Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #924389 is a reply to message #923501] Wed, 26 September 2012 20:12 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Is there any chance you could try this report in 3.7 or 4.2?

Jason
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #924552 is a reply to message #924389] Thu, 27 September 2012 00:04 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

Unfortunately no. I'm stuck with the version I'm on because these reports will be embedded inside Maximo


I've taken a look at the canned IBM reports that come with maximo and they suffer from the same limitations (landscape printing in portrait unless we preview in html and print to pdf) so I guess i can put this requirement into the 'not supported by this version' basket in my solution design doc

I've managed to work though the other issues i raised in this post so its all good for now

Thanks
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #925384 is a reply to message #924552] Thu, 27 September 2012 17:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you can reproduce the issue with the sample db I may be able to help with a work around.

Jason
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #925894 is a reply to message #925384] Fri, 28 September 2012 05:49 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Here you go

When I go to
Run| View report | In web browser

report renders in landscape

Click on print report - leave everything as default and print

The report prints scaled down in portrait. The bottom half of the page is empty


Same behaviour when the report is deployed onto the web server and executed within the maximo web app



<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_v20090521 Build &lt;2.3.2.v20090601-0700></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="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">CUSTOMERNUMBER</property>
                    <property name="displayName">CUSTOMERNUMBER</property>
                </structure>
                <structure>
                    <property name="columnName">CUSTOMERNAME</property>
                    <property name="displayName">CUSTOMERNAME</property>
                </structure>
                <structure>
                    <property name="columnName">CONTACTLASTNAME</property>
                    <property name="displayName">CONTACTLASTNAME</property>
                </structure>
                <structure>
                    <property name="columnName">CONTACTFIRSTNAME</property>
                    <property name="displayName">CONTACTFIRSTNAME</property>
                </structure>
                <structure>
                    <property name="columnName">PHONE</property>
                    <property name="displayName">PHONE</property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESSLINE1</property>
                    <property name="displayName">ADDRESSLINE1</property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESSLINE2</property>
                    <property name="displayName">ADDRESSLINE2</property>
                </structure>
                <structure>
                    <property name="columnName">CITY</property>
                    <property name="displayName">CITY</property>
                </structure>
                <structure>
                    <property name="columnName">STATE</property>
                    <property name="displayName">STATE</property>
                </structure>
                <structure>
                    <property name="columnName">POSTALCODE</property>
                    <property name="displayName">POSTALCODE</property>
                </structure>
                <structure>
                    <property name="columnName">COUNTRY</property>
                    <property name="displayName">COUNTRY</property>
                </structure>
                <structure>
                    <property name="columnName">SALESREPEMPLOYEENUMBER</property>
                    <property name="displayName">SALESREPEMPLOYEENUMBER</property>
                </structure>
                <structure>
                    <property name="columnName">CREDITLIMIT</property>
                    <property name="displayName">CREDITLIMIT</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CUSTOMERNUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CUSTOMERNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CONTACTLASTNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">CONTACTFIRSTNAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">PHONE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">ADDRESSLINE1</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">ADDRESSLINE2</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">CITY</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">STATE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">POSTALCODE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">COUNTRY</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">SALESREPEMPLOYEENUMBER</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">CREDITLIMIT</property>
                        <property name="dataType">float</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">CUSTOMERNUMBER</property>
                    <property name="nativeName">CUSTOMERNUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CUSTOMERNAME</property>
                    <property name="nativeName">CUSTOMERNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CONTACTLASTNAME</property>
                    <property name="nativeName">CONTACTLASTNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">CONTACTFIRSTNAME</property>
                    <property name="nativeName">CONTACTFIRSTNAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">PHONE</property>
                    <property name="nativeName">PHONE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">ADDRESSLINE1</property>
                    <property name="nativeName">ADDRESSLINE1</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">ADDRESSLINE2</property>
                    <property name="nativeName">ADDRESSLINE2</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">CITY</property>
                    <property name="nativeName">CITY</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">STATE</property>
                    <property name="nativeName">STATE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">POSTALCODE</property>
                    <property name="nativeName">POSTALCODE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">COUNTRY</property>
                    <property name="nativeName">COUNTRY</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">SALESREPEMPLOYEENUMBER</property>
                    <property name="nativeName">SALESREPEMPLOYEENUMBER</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">CREDITLIMIT</property>
                    <property name="nativeName">CREDITLIMIT</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <property name="queryText">select * FROM
CLASSICMODELS.CUSTOMERS</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">
            <property name="type">a4</property>
            <property name="orientation">landscape</property>
            <property name="topMargin">0.25in</property>
            <property name="leftMargin">0.25in</property>
            <property name="bottomMargin">0.25in</property>
            <property name="rightMargin">0.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>
        <table id="10">
            <property name="width">11in</property>
            <property name="dataSet">Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">CUSTOMERNAME</property>
                    <property name="displayName">CUSTOMERNAME</property>
                    <expression name="expression">dataSetRow["CUSTOMERNAME"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CUSTOMERNUMBER</property>
                    <property name="displayName">CUSTOMERNUMBER</property>
                    <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">PHONE</property>
                    <property name="displayName">PHONE</property>
                    <expression name="expression">dataSetRow["PHONE"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="23"/>
            <column id="24"/>
            <column id="25"/>
            <header>
                <row id="11">
                    <cell id="12">
                        <label id="26">
                            <text-property name="text">CUSTOMERNAME</text-property>
                        </label>
                    </cell>
                    <cell id="13">
                        <label id="28">
                            <text-property name="text">CUSTOMERNUMBER</text-property>
                        </label>
                    </cell>
                    <cell id="14">
                        <label id="30">
                            <text-property name="text">PHONE</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="15">
                    <cell id="16">
                        <data id="27">
                            <property name="resultSetColumn">CUSTOMERNAME</property>
                        </data>
                    </cell>
                    <cell id="17">
                        <data id="29">
                            <property name="resultSetColumn">CUSTOMERNUMBER</property>
                        </data>
                    </cell>
                    <cell id="18">
                        <data id="31">
                            <property name="resultSetColumn">PHONE</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="19">
                    <cell id="20"/>
                    <cell id="21"/>
                    <cell id="22"/>
                </row>
            </footer>
        </table>
    </body>
</report>
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #926558 is a reply to message #925894] Fri, 28 September 2012 19:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

When I print the report from the web viewer with print icon in the toolbar and choose pdf it comes out in landscape. What am I missing.

Jason
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #929987 is a reply to message #926558] Mon, 01 October 2012 23:54 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Sorry about reply delay, it was a long weekend here in australia

here are the scenarios

the existing behaviour is
view in browser - print as html - prints as portrait. incorrect pagination (rows split over a page, wrong page numbers)

view in browser - print as pdf - fit on single page. tiny portrait table on landscape oriented page

view in browser - print as pdf - auto. Prints as landscape


The last one (print to pdf:auto) works, it's the others that I can't get to work...
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #930782 is a reply to message #929987] Tue, 02 October 2012 16:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Understood. Can you log a bugzilla entry for this?

JAson
Re: Masterpage orientation = landscape. Report prints and exports in portrait #2 [message #931155 is a reply to message #930782] Wed, 03 October 2012 00:50 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
looks like it's already there

https://bugs.eclipse.org/bugs/show_bug.cgi?id=256722
Previous Topic:IE8 SVG Graph tooltip cut off
Next Topic:Can we hyperlink different part of single image with different reports??
Goto Forum:
  


Current Time: Tue Mar 19 11:03:57 GMT 2024

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

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

Back to the top