Home » Archived » BIRT » Empty first page
Empty first page [message #656463] |
Fri, 25 February 2011 18:49 |
Jim Garrison Messages: 57 Registered: July 2009 |
Member |
|
|
After upgrading BIRT from version 2.3.2 to 2.6.1, some reports have started producing empty first pages. I've checked the source XML of the rptdesign and the referenced rptlibrary and verified that ALL settings of page break properties are set to "auto". I.e. there are no forced page breaks anywhere in the report definition. The first page contains the master page header/footer items but no data.
Being a relative newbie to BIRT I'm not sure where to go next to solve (or even debug) this problem. My Google-fu turns up some old bugs (2.1 timeframe) relating to blank first pages but they were resolved long ago.
I have some screenshots but this system doesn't seem to allow attachments.
[Updated on: Fri, 25 February 2011 19:01] Report message to a moderator
|
|
| |
Re: Empty first page [message #656476 is a reply to message #656463] |
Fri, 25 February 2011 20:13 |
|
Jim,
Can you post one of the reports?
Jason
On 2/25/2011 1:49 PM, Jim Garrison wrote:
> After upgrading BIRT from a previous version (I think it was 2.0) to
> 2.6.1, some reports have started producing empty first pages. I've
> checked the source XML of the rptdesign and the referenced rptlibrary
> and verified that ALL settings of page break properties are set to
> "auto". I.e. there are no forced page breaks anywhere in the report
> definition. The first page contains the master page header/footer items
> but no data.
>
> Being a relative newbie to BIRT I'm not sure where to go next to solve
> (or even debug) this problem. My Google-fu turns up some old bugs (2.1
> timeframe) relating to blank first pages but they were resolved long ago.
>
> I have some screenshots but this system doesn't seem to allow attachments.
>
>
|
|
|
Re: Empty first page [message #656484 is a reply to message #656476] |
Fri, 25 February 2011 20:46 |
Jim Garrison Messages: 57 Registered: July 2009 |
Member |
|
|
Here it is... (I wish there were a way to attach a zip file instead)
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.1.v20100902 Build <2.6.1.v20100915-1750></property>
<property name="units">in</property>
<property name="theme">troux_core.Troux Theme</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<list-property name="libraries">
<structure>
<property name="fileName">troux_core.rptlibrary</property>
<property name="namespace">troux_core</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="BlueprintID" id="927">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">1</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="concealValue">true</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Categories" id="929">
<property name="valueType">dynamic</property>
<property name="dataSetName">Prompt Categories Data Set</property>
<expression name="valueExpr">dataSetRow["STANDARDS_CATEGORY_ID"]</expression>
<expression name="labelExpr">dataSetRow["STANDARDS_CATEGORY_NAME"]</expression>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<property name="paramType">multi-value</property>
<property name="controlType">list-box</property>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Troux Datamart" id="7"
extends="troux_core.Troux Datamart"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Catalog Data Set" id="652">
<list-property name="filter">
<structure>
<property name="operator">in</property>
<expression name="expr">row["CAT_ID"]</expression>
<simple-property-list name="value1">
<value>params["Categories"].value</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CAT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CAT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRODUCT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCT_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">MANUF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">MANUF_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MANUF_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MANUF_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">VERSION_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">VERSION_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">VERSION_ALIAS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">VERSION_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">VERSION_VERSION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">VERSION_SCOPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">VERSION_USAGE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">VERSION_PATCH</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">VERSION_LAST_REVIEW</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">VERSION_REVIEW_NOTES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">VERSION_REVIEW_CYCLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">STEWARD_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">STEWARD_TITLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">STEWARD_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">STEWARD_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">VENDOR_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">VENDOR_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">VENDOR_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">VENDOR_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PHASE_TYPE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[if ( this.queryText.contains("{fn ") ) {
try {
var trouxReportContext = Packages.com.troux.common.utils.ReportContext.getTrouxReportContext(reportContext.getAppContext());
this.queryText = trouxReportContext.dbSpecific(this.getDataSource().getName(), this.queryText);
} catch (e) {
this.queryText = this.queryText.replace("{fn dbDate}", "getdate()");
this.queryText = this.queryText.replace("{fn dbDate}", "getdate()");
}
}]]></method>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CAT_ID</property>
<property name="nativeName">CAT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CAT_NAME</property>
<property name="nativeName">CAT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRODUCT_ID</property>
<property name="nativeName">PRODUCT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCT_NAME</property>
<property name="nativeName">PRODUCT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCT_DESC</property>
<property name="nativeName">PRODUCT_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">MANUF_NAME</property>
<property name="nativeName">MANUF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">MANUF_CONTACT</property>
<property name="nativeName">MANUF_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MANUF_EMAIL</property>
<property name="nativeName">MANUF_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MANUF_PHONE</property>
<property name="nativeName">MANUF_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">VERSION_ID</property>
<property name="nativeName">VERSION_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">VERSION_NAME</property>
<property name="nativeName">VERSION_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">VERSION_ALIAS</property>
<property name="nativeName">VERSION_ALIAS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">VERSION_DESC</property>
<property name="nativeName">VERSION_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">VERSION_VERSION</property>
<property name="nativeName">VERSION_VERSION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">VERSION_SCOPE</property>
<property name="nativeName">VERSION_SCOPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">VERSION_USAGE</property>
<property name="nativeName">VERSION_USAGE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">VERSION_PATCH</property>
<property name="nativeName">VERSION_PATCH</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">VERSION_LAST_REVIEW</property>
<property name="nativeName">VERSION_LAST_REVIEW</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">VERSION_REVIEW_NOTES</property>
<property name="nativeName">VERSION_REVIEW_NOTES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">VERSION_REVIEW_CYCLE</property>
<property name="nativeName">VERSION_REVIEW_CYCLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">STEWARD_NAME</property>
<property name="nativeName">STEWARD_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">STEWARD_TITLE</property>
<property name="nativeName">STEWARD_TITLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">STEWARD_PHONE</property>
<property name="nativeName">STEWARD_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">STEWARD_EMAIL</property>
<property name="nativeName">STEWARD_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">VENDOR_NAME</property>
<property name="nativeName">VENDOR_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">VENDOR_CONTACT</property>
<property name="nativeName">VENDOR_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">VENDOR_EMAIL</property>
<property name="nativeName">VENDOR_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">VENDOR_PHONE</property>
<property name="nativeName">VENDOR_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PHASE_TYPE</property>
<property name="nativeName">PHASE_TYPE</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
SC.STANDARDS_CATEGORY_ID CAT_ID,
SC.STANDARDS_CATEGORY_NAME CAT_NAME,
ITP.HARDWARE_PRODUCT_COMPONENT_ID PRODUCT_ID,
ITP.HARDWARE_PRODUCT_COMPONENT_NAM PRODUCT_NAME,
ITP.HARDWARE_PRODUCT_DESCRIPTION PRODUCT_DESC,
MAN.EXTERNAL_ORG_COMP_NAME MANUF_NAME,
MAN.EXTERNAL_ORGANIZATION_CONTACT MANUF_CONTACT,
MAN.EXTERNAL_ORGANIZATION_EMAIL_AD MANUF_EMAIL,
MAN.EXTERNAL_ORGANIZATION_PHONE MANUF_PHONE,
VER.HARDWARE_PRODUCT_MODEL_ID VERSION_ID,
VER.HARDWARE_PRODUCT_MODEL_NAME VERSION_NAME,
VER.HARDWARE_PRODUCT_MODEL_ALIAS VERSION_ALIAS,
VER.HARDWARE_PRODUCT_MODEL_DESC VERSION_DESC,
VER.HARDWARE_PRODUCT_MODEL_VERSION VERSION_VERSION,
VER.STANDARD_CANDIDATE_SCOPE VERSION_SCOPE,
VER.STANDARD_CANDIDATE_USAGE_GUIDE VERSION_USAGE,
VER.STANDARD_CANDIDATE_REC_PATCH VERSION_PATCH,
VER.STANDARD_CANDIDATE_LAST_REVIEW VERSION_LAST_REVIEW,
VER.STANDARD_CANDIDATE_REVIEW_NOTE VERSION_REVIEW_NOTES,
VER.STANDARD_CANDIDATE_REV_CYC VERSION_REVIEW_CYCLE,
P.PERSON_COMPONENT_NAME STEWARD_NAME,
P.PERSON_BUSINESS_TITLE STEWARD_TITLE,
P.PERSON_OFFICE_PHONE_NUMBER STEWARD_PHONE,
P.PERSON_EMAIL_ADDRESS STEWARD_EMAIL,
VEN.EXTERNAL_ORG_COMP_NAME VENDOR_NAME,
VEN.EXTERNAL_ORGANIZATION_CONTACT VENDOR_CONTACT,
VEN.EXTERNAL_ORGANIZATION_EMAIL_AD VENDOR_EMAIL,
VEN.EXTERNAL_ORGANIZATION_PHONE VENDOR_PHONE,
LP.PHASE_TYPE PHASE_TYPE
FROM STANDARDS_CATEGORY SC
JOIN (
SELECT STANDARDS_CATEGORY_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID, HARDWARE_PRODUCT_COMPONENT_ID, MANUFACTURER_COMPONENT_ID, STEWARD_COMPONENT_ID, VENDOR_COMPONENT_ID, PHASE_COMPONENT_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY STANDARDS_CATEGORY_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID, HARDWARE_PRODUCT_COMPONENT_ID, MANUFACTURER_COMPONENT_ID, STEWARD_COMPONENT_ID, VENDOR_COMPONENT_ID, PHASE_COMPONENT_ID
) FACT ON FACT.STANDARDS_CATEGORY_COMP_ID = SC.STANDARDS_CATEGORY_ID
JOIN HARDWARE_PRODUCT_MODEL VER ON FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = VER.HARDWARE_PRODUCT_MODEL_ID
LEFT JOIN HARDWARE_PRODUCT ITP ON FACT.HARDWARE_PRODUCT_COMPONENT_ID = ITP.HARDWARE_PRODUCT_COMPONENT_ID
LEFT JOIN EXTERNAL_ORGANIZATION MAN ON FACT.MANUFACTURER_COMPONENT_ID = MAN.EXTERNAL_ORG_COMP_ID
LEFT JOIN PERSON P ON FACT.STEWARD_COMPONENT_ID = P.PERSON_COMPONENT_ID
LEFT JOIN EXTERNAL_ORGANIZATION VEN ON FACT.VENDOR_COMPONENT_ID = VEN.EXTERNAL_ORG_COMP_ID
LEFT JOIN (
SELECT LP.PHASE_COMPONENT_ID, LP.PHASE_TYPE, LP.PHASE_START_DATE, LP.PHASE_END_DATE
FROM LIFECYCLE_PHASE LP
JOIN DM_ENUMLIFECYCLE_TYPE LT ON LP.LIFECYCLE_TYPE_ID = LT.TROUXENUMERATIONVALUEID
WHERE LT.UUID = 'PropTypeValue_StandardsLifecycleType_Internal_for_Hardware_Product_Model_UUID'
) LP ON FACT.PHASE_COMPONENT_ID = LP.PHASE_COMPONENT_ID
WHERE
FACT.PHASE_COMPONENT_ID IS NULL
OR (
LP.PHASE_START_DATE <= {fn dbDate}
AND (LP.PHASE_END_DATE IS NULL OR LP.PHASE_END_DATE >= {fn dbDate})
)
ORDER BY CAT_NAME, PRODUCT_NAME, VERSION_NAME]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Prompt Categories Data Set" id="928">
<list-property name="columnHints">
<structure>
<property name="columnName">STANDARDS_CATEGORY_ID</property>
<text-property name="displayName">STANDARDS_CATEGORY_ID</text-property>
</structure>
<structure>
<property name="columnName">STANDARDS_CATEGORY_NAME</property>
<text-property name="displayName">STANDARDS_CATEGORY_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">BlueprintID</property>
<property name="paramName">BlueprintID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STANDARDS_CATEGORY_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">STANDARDS_CATEGORY_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STANDARDS_CATEGORY_ID</property>
<property name="nativeName">STANDARDS_CATEGORY_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">STANDARDS_CATEGORY_NAME</property>
<property name="nativeName">STANDARDS_CATEGORY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
SC.STANDARDS_CATEGORY_ID,
SC.STANDARDS_CATEGORY_NAME
FROM STANDARDS_CATEGORY SC
JOIN STANDARDS_FACT_HARDWARE FACT
ON SC.STANDARDS_CATEGORY_ID = FACT.STANDARDS_CATEGORY_COMP_ID
WHERE SC.STANDARDS_CAT_BLUEPRINT_ID = ?
AND FACT.HARDWARE_PRODUCT_MODEL_COMP_ID IS NOT NULL
GROUP BY SC.STANDARDS_CATEGORY_NAME, SC.STANDARDS_CATEGORY_ID
ORDER BY SC.STANDARDS_CATEGORY_NAME]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STANDARDS_CATEGORY_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STANDARDS_CATEGORY_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STANDARDS_CATEGORY_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STANDARDS_CATEGORY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STANDARDS_CATEGORY_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STANDARDS_CATEGORY_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Org Scope Data Set" id="930">
<list-property name="columnHints">
<structure>
<property name="columnName">ORG_SCOPE_ID</property>
<text-property name="displayName">ORG_SCOPE_ID</text-property>
</structure>
<structure>
<property name="columnName">ORG_SCOPE_NAME</property>
<text-property name="displayName">ORG_SCOPE_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORG_SCOPE_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORG_SCOPE_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORG_SCOPE_ID</property>
<property name="nativeName">ORG_SCOPE_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORG_SCOPE_NAME</property>
<property name="nativeName">ORG_SCOPE_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
ORG.INTERNAL_ORG_COMP_ID ORG_SCOPE_ID,
ORG.INTERNAL_ORG_COMP_NAME ORG_SCOPE_NAME
FROM INTERNAL_ORGANIZATION ORG
JOIN (
SELECT ORGANIZATION_SCOPE_COMPONENT_I, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY ORGANIZATION_SCOPE_COMPONENT_I, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.ORGANIZATION_SCOPE_COMPONENT_I = ORG.INTERNAL_ORG_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY ORG_SCOPE_NAME]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORG_SCOPE_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ORG_SCOPE_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORG_SCOPE_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORG_SCOPE_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ORG_SCOPE_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORG_SCOPE_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="BizFxns Data Set" id="947">
<list-property name="columnHints">
<structure>
<property name="columnName">BF_ID</property>
<text-property name="displayName">BF_ID</text-property>
</structure>
<structure>
<property name="columnName">BF_NAME</property>
<text-property name="displayName">BF_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BF_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">BF_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BF_ID</property>
<property name="nativeName">BF_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">BF_NAME</property>
<property name="nativeName">BF_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
BF.BUSINESS_FUNCTION_COMP_ID BF_ID,
BF.BUSINESS_FUNCTION_COMP_NAME BF_NAME
FROM BUSINESS_FUNCTION BF
JOIN (
SELECT BUSINESS_FUNCTION_COMPONENT_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY BUSINESS_FUNCTION_COMPONENT_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.BUSINESS_FUNCTION_COMPONENT_ID = BF.BUSINESS_FUNCTION_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY BF_NAME]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BF_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>BF_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BF_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BF_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>BF_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BF_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Industry Standards Data Set" id="964">
<list-property name="columnHints">
<structure>
<property name="columnName">ISV_ID</property>
<text-property name="displayName">ISV_ID</text-property>
</structure>
<structure>
<property name="columnName">ISV_NAME</property>
<text-property name="displayName">ISV_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ISV_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ISV_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ISV_ID</property>
<property name="nativeName">ISV_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ISV_NAME</property>
<property name="nativeName">ISV_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
ISV.INDUSTRY_STANDARD_VER_COMP_ID ISV_ID,
ISV.INDUSTRY_STANDARD_VER_COM_NAME ISV_NAME
FROM INDUSTRY_STANDARD_VERSION ISV
JOIN (
SELECT INDUSTRY_STANDARD_VER_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY INDUSTRY_STANDARD_VER_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.INDUSTRY_STANDARD_VER_COMP_ID = ISV.INDUSTRY_STANDARD_VER_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY ISV_NAME]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ISV_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ISV_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ISV_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ISV_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ISV_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ISV_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Related Artifacts Data Set" id="981">
<list-property name="columnHints">
<structure>
<property name="columnName">LINK_TEXT</property>
<text-property name="displayName">LINK_TEXT</text-property>
</structure>
<structure>
<property name="columnName">LINK_URL</property>
<text-property name="displayName">LINK_URL</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">LINK_TEXT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LINK_URL</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">LINK_TEXT</property>
<property name="nativeName">LINK_TEXT</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LINK_URL</property>
<property name="nativeName">LINK_URL</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
HARDWARE_PRODUCT_MODEL_RELATE1 LINK_TEXT,
HARDWARE_PRODUCT_MODEL_RELATED LINK_URL
FROM HARDWARE_PRODUCT_MODEL_HARDWAR
WHERE HARDWARE_PRODUCT_MODEL_ID = ?
ORDER BY HARDWARE_PRODUCT_MODEL_LIST_IN]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SOFTWARE_PRODUCT_VER_RA_TEXT</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOFTWARE_PRODUCT_VER_RA_TEXT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOFTWARE_PRODUCT_VER_RA_TEXT</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SOFTWARE_PRODUCT_VER_RA_URL</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOFTWARE_PRODUCT_VER_RA_URL</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOFTWARE_PRODUCT_VER_RA_URL</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
|
|
| |
Re: Empty first page [message #656496 is a reply to message #656486] |
Fri, 25 February 2011 22:27 |
|
Jim,
My email address is jasonweathersby at windstream dot net.
Jason
On 2/25/2011 4:07 PM, Jim Garrison wrote:
> Hmmm.... looks like the forum system truncated the long report
> definition. Please email me at mailto:jgarrison@troux.com and I'll send
> you the complete file.
|
|
|
Re: Empty first page [message #656825 is a reply to message #656496] |
Mon, 28 February 2011 17:55 |
Jim Garrison Messages: 57 Registered: July 2009 |
Member |
|
|
I have identified the source of the problem. When this report was originally designed (long before my time) a grid was used to effect some padding around the outside of the content. At the top level of the design (in the body) is a 3x3 grid with skinny top and bottom rows and left and right columns, with all content going in the center cell.
body
grid
column1 width=2%
column2 width=96%
column3 width=2%
row1 (empty)
row2
table with all report content
row3 (empty)
All the border cells are empty, and if I completely remove the grid and place the content table in the body directly, there is no initial page break.
body
table with all report content
So the bug appears to occur if the content, which is larger than a single output page, inside a grid. In this case, the normal suppression of the page break before the first page does not seem to function.
Is this a bug, or is this behavior expected?
[Updated on: Mon, 28 February 2011 18:11] Report message to a moderator
|
|
|
Re: Empty first page [message #656837 is a reply to message #656825] |
Mon, 28 February 2011 18:17 |
|
Jim,
I know we made changes to the page breaks in 2.6.2 which were bug fixes.
Before reporting this could you try 2.6.2?
Jason
On 2/28/2011 12:55 PM, Jim Garrison wrote:
> Some tinkering has led me to believe that the initial page break is a
> bug, resulting from failure to suppress the break on the first page when
> the layout is too long to fit on a single page. The layout is
>
> table
> group1 header
> group2 header
> group3 header
> grid1 with lots of rows
> grid2 with lots of rows
>
>
> The first virtual "page" is quite long and is output over several report
> pages.
>
> If I remove enough rows so that it fits on one output page, the initial
> (and incorrect) page break disappears.
|
|
| |
Re: Empty first page [message #656866 is a reply to message #656857] |
Mon, 28 February 2011 19:34 |
|
Thanks Jim
On 2/28/2011 2:27 PM, Jim Garrison wrote:
> Now that I understand the problem I was able to search the existing bugs
> and found this:
>
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=323222
>
> Which looks almost exactly like what we're seeing.
>
> I have a workaround (remove grid; set table left-margin:.25in,
> width:96%) that will accomplish what we need for now. Curiously I was
> unable to get CSS to work at all (margin and padding values were
> ignored) but I'll leave that issue for another day.
>
> I'm out of time and won't be able to upgrade to 2.6.2 until after April
> 7th or so.
|
|
| | |
Goto Forum:
Current Time: Tue Sep 24 18:35:03 GMT 2024
Powered by FUDForum. Page generated in 0.05458 seconds
|