Download
Getting Started
Members
Projects
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
More
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
Toggle navigation
Bugzilla – Attachment 81255 Details for
Bug 207568
BIRT standalone Designer Fixed Colum width presentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
Terms of Use
|
Copyright Agent
Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read
this important communication.
Sample Report Design
FormulaSolution.rptdesign (text/xml), 115.86 KB, created by
Virgil Green
on 2007-10-26 08:05:55 EDT
(
hide
)
Description:
Sample Report Design
Filename:
MIME Type:
Creator:
Virgil Green
Created:
2007-10-26 08:05:55 EDT
Size:
115.86 KB
patch
obsolete
><?xml version="1.0" encoding="UTF-8"?> ><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14" id="1"> > <property name="createdBy">Eclipse BIRT Designer Version 2.1.2.v20070205-1728 Build <20070205-1728></property> > <property name="units">in</property> > <property name="includeResource">ReportLabels</property> > <property name="comments">Copyright (c) 2006 <<Your Company Name here>></property> > <parameters> > <scalar-parameter name="FormulaID" id="10"> > <property name="valueType">static</property> > <property name="dataType">integer</property> > <text-property name="promptText">Formula ID</text-property> > <property name="isRequired">true</property> > <property name="controlType">text-box</property> > <property name="defaultValue">32</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="TowerGroveFeedDemo" id="4"> > <property name="odaDriverClass">com.mysql.jdbc.Driver</property> > <property name="odaURL">jdbc:mysql://localhost/towergrovefeeddemo_en</property> > <property name="odaUser">tgs</property> > <encrypted-property name="odaPassword">dGdzMjEzNWE=</encrypted-property> > </oda-data-source> > </data-sources> > <data-sets> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Formula" id="5"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">BO_FrmNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">BO_FrmCde</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">BO_SpcNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">TotalCost</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">CostTypNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">Weight</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">WeightUnit</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">TotalIngredientPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">TotalIngredientMinimumPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">Type1</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">11</property> > <property name="name">Type2</property> > <property name="dataType">string</property> > </structure> > </list-property> > </structure> > <property name="dataSource">TowerGroveFeedDemo</property> > <list-property name="parameters"> > <structure> > <property name="name">FormulaID</property> > <property name="paramName">FormulaID</property> > <property name="dataType">integer</property> > <property name="position">1</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">BO_FrmNm</property> > <property name="nativeName">BO_FrmNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">BO_FrmCde</property> > <property name="nativeName">BO_FrmCde</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">BO_SpcNm</property> > <property name="nativeName">BO_SpcNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">TotalCost</property> > <property name="nativeName">TotalCost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">CostTypNm</property> > <property name="nativeName">CostTypNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">Weight</property> > <property name="nativeName">Weight</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">WeightUnit</property> > <property name="nativeName">WeightUnit</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">TotalIngredientPct</property> > <property name="nativeName">TotalIngredientPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">TotalIngredientMinimumPct</property> > <property name="nativeName">TotalIngredientMinimumPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">Type1</property> > <property name="nativeName">Type1</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">11</property> > <property name="name">Type2</property> > <property name="nativeName">Type2</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > </list-property> > <property name="queryText">select BO_FrmNm, BO_FrmCde, BO_SpcNm, TotalCost, CostTypNm, Weight, WeightUnit, TotalIngredientPct, TotalIngredientMinimumPct, Type1, Type2 >from Frm_NmCdSpc_CstTyp_WgtU >where Formula_ID=?</property> > </oda-data-set> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="FormulaIngredientInSolution" id="6"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">IngName</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">IngCode</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">FrmIng_DMYldWgt</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">FrmIng_AFYldWgt</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">FrmIng_Pct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">MinimumPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">MaximumPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">Cost</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">LowCost</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">HighCost</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">TowerGroveFeedDemo</property> > <list-property name="parameters"> > <structure> > <property name="name">FormulaID</property> > <property name="paramName">FormulaID</property> > <property name="dataType">integer</property> > <property name="position">1</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">IngName</property> > <property name="nativeName">IngName</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">IngCode</property> > <property name="nativeName">IngCode</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">FrmIng_DMYldWgt</property> > <property name="nativeName">FrmIng_DMYldWgt</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">FrmIng_AFYldWgt</property> > <property name="nativeName">FrmIng_AFYldWgt</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">FrmIng_Pct</property> > <property name="nativeName">FrmIng_Pct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">MinimumPct</property> > <property name="nativeName">MinimumPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">MaximumPct</property> > <property name="nativeName">MaximumPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">Cost</property> > <property name="nativeName">Cost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">LowCost</property> > <property name="nativeName">LowCost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">10</property> > <property name="name">HighCost</property> > <property name="nativeName">HighCost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select IngName, IngCode, FrmIng_DMYldWgt, FrmIng_AFYldWgt, FrmIng_Pct, MinimumPct, MaximumPct, Cost, LowCost, HighCost >from FrmIng_NmCdDM_InSln >where Formula_ID=?</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>IngName</design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>IngName</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>IngCode</design:name> > <design:position>2</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>IngCode</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmIng_DMYldWgt</design:name> > <design:position>3</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>23</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmIng_DMYldWgt</design:label> > <design:formattingHints> > <design:displaySize>23</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmIng_AFYldWgt</design:name> > <design:position>4</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>23</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmIng_AFYldWgt</design:label> > <design:formattingHints> > <design:displaySize>23</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmIng_Pct</design:name> > <design:position>5</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmIng_Pct</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>MinimumPct</design:name> > <design:position>6</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>MinimumPct</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>MaximumPct</design:name> > <design:position>7</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>MaximumPct</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>Cost</design:name> > <design:position>8</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>Cost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>LowCost</design:name> > <design:position>9</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>LowCost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>HighCost</design:name> > <design:position>10</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>HighCost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > </design:resultSetColumns> > </design:resultSetDefinitions> > </design:ResultSets> ></model:DesignValues>]]></xml-property> > </oda-data-set> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="FormulaIngredientNotInSolution" id="7"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">IngName</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">IngCode</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">MinimumPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">MaximumPct</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">Cost</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">LowCost</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">HighCost</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">TowerGroveFeedDemo</property> > <list-property name="parameters"> > <structure> > <property name="name">FormulaID</property> > <property name="paramName">FormulaID</property> > <property name="nativeName"></property> > <property name="dataType">integer</property> > <property name="nativeDataType">12</property> > <property name="position">1</property> > <property name="isInput">true</property> > </structure> > </list-property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">IngName</property> > <property name="nativeName">IngName</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">IngCode</property> > <property name="nativeName">IngCode</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">MinimumPct</property> > <property name="nativeName">MinimumPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">MaximumPct</property> > <property name="nativeName">MaximumPct</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">Cost</property> > <property name="nativeName">Cost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">LowCost</property> > <property name="nativeName">LowCost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">HighCost</property> > <property name="nativeName">HighCost</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select IngName, IngCode, MinimumPct, MaximumPct, Cost, LowCost, HighCost >from FrmIng_NmCd_NtInSln >where Formula_ID=?</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></design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:nullability>Unknown</design:nullability> > <design:uiHints> > <design:displayName>Formula ID</design:displayName> > </design:uiHints> > </design:attributes> > <design:inputAttributes> > <design:elementAttributes> > <design:optional>true</design:optional> > <design:masksValue>false</design:masksValue> > <design:uiHints> > <design:promptStyle>TextField</design:promptStyle> > </design:uiHints> > </design:elementAttributes> > </design:inputAttributes> > </design:parameterDefinitions> > </design:DataSetParameters> > <design:ResultSets derivedMetaData="true"> > <design:resultSetDefinitions> > <design:resultSetColumns> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>IngName</design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>IngName</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>IngCode</design:name> > <design:position>2</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>IngCode</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>MinimumPct</design:name> > <design:position>3</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>MinimumPct</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>MaximumPct</design:name> > <design:position>4</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>MaximumPct</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>Cost</design:name> > <design:position>5</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>Cost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>LowCost</design:name> > <design:position>6</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>LowCost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>HighCost</design:name> > <design:position>7</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>HighCost</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > </design:resultSetColumns> > </design:resultSetDefinitions> > </design:ResultSets> ></model:DesignValues>]]></xml-property> > </oda-data-set> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ForumulaNutrients" id="8"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">NutNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">NutCde</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">RatioUnitValue</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">FrmNut_Act</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">FrmNut_Min</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">FrmNut_Max</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">FrmNut_Cst</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">TowerGroveFeedDemo</property> > <list-property name="parameters"> > <structure> > <property name="name">FormulaID</property> > <property name="paramName">FormulaID</property> > <property name="nativeName"></property> > <property name="dataType">integer</property> > <property name="nativeDataType">12</property> > <property name="position">1</property> > <property name="isInput">true</property> > </structure> > </list-property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">NutNm</property> > <property name="nativeName">NutNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">NutCde</property> > <property name="nativeName">NutCde</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">RatioUnitValue</property> > <property name="nativeName">RatioUnitValue</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">FrmNut_Act</property> > <property name="nativeName">FrmNut_Act</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">FrmNut_Min</property> > <property name="nativeName">FrmNut_Min</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">FrmNut_Max</property> > <property name="nativeName">FrmNut_Max</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">FrmNut_Cst</property> > <property name="nativeName">FrmNut_Cst</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select NutNm, NutCde, RatioUnitValue, FrmNut_Act, FrmNut_Min, FrmNut_Max, FrmNut_Cst >from FrmNut_NmCd_RU >where Formula_ID=?</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></design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:nullability>Unknown</design:nullability> > <design:uiHints> > <design:displayName>Formula ID</design:displayName> > </design:uiHints> > </design:attributes> > <design:inputAttributes> > <design:elementAttributes> > <design:optional>true</design:optional> > <design:masksValue>false</design:masksValue> > <design:uiHints> > <design:promptStyle>TextField</design:promptStyle> > </design:uiHints> > </design:elementAttributes> > </design:inputAttributes> > </design:parameterDefinitions> > </design:DataSetParameters> > <design:ResultSets derivedMetaData="true"> > <design:resultSetDefinitions> > <design:resultSetColumns> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>NutNm</design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>NutNm</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>NutCde</design:name> > <design:position>2</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>50</design:precision> > <design:scale>0</design:scale> > <design:nullability>NotNullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>NutCde</design:label> > <design:formattingHints> > <design:displaySize>50</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>RatioUnitValue</design:name> > <design:position>3</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:precision>100</design:precision> > <design:scale>0</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>RatioUnitValue</design:label> > <design:formattingHints> > <design:displaySize>100</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmNut_Act</design:name> > <design:position>4</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmNut_Act</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmNut_Min</design:name> > <design:position>5</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmNut_Min</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmNut_Max</design:name> > <design:position>6</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmNut_Max</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > <design:resultColumnDefinitions> > <design:attributes> > <design:name>FrmNut_Cst</design:name> > <design:position>7</design:position> > <design:nativeDataTypeCode>8</design:nativeDataTypeCode> > <design:precision>22</design:precision> > <design:scale>31</design:scale> > <design:nullability>Nullable</design:nullability> > </design:attributes> > <design:usageHints> > <design:label>FrmNut_Cst</design:label> > <design:formattingHints> > <design:displaySize>22</design:displaySize> > </design:formattingHints> > </design:usageHints> > </design:resultColumnDefinitions> > </design:resultSetColumns> > </design:resultSetDefinitions> > </design:ResultSets> ></model:DesignValues>]]></xml-property> > </oda-data-set> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="FormulaRatios" id="9"> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">NB_NumNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">NB_NumCde</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">NB_NumTyp</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">DB_DnmNm</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">DB_DnmCde</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">DB_DnmTyp</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">FrmRat_Min</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">FrmRat_Max</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">FrmRat_Cst</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">TowerGroveFeedDemo</property> > <list-property name="parameters"> > <structure> > <property name="name">FormulaID</property> > <property name="paramName">FormulaID</property> > <property name="nativeName"></property> > <property name="dataType">integer</property> > <property name="nativeDataType">12</property> > <property name="position">1</property> > <property name="isInput">true</property> > </structure> > </list-property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">NB_NumNm</property> > <property name="nativeName">NB_NumNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">NB_NumCde</property> > <property name="nativeName">NB_NumCde</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">NB_NumTyp</property> > <property name="nativeName">NB_NumTyp</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">DB_DnmNm</property> > <property name="nativeName">DB_DnmNm</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">DB_DnmCde</property> > <property name="nativeName">DB_DnmCde</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">DB_DnmTyp</property> > <property name="nativeName">DB_DnmTyp</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">FrmRat_Min</property> > <property name="nativeName">FrmRat_Min</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">FrmRat_Max</property> > <property name="nativeName">FrmRat_Max</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">FrmRat_Cst</property> > <property name="nativeName">FrmRat_Cst</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select NB_NumNm, NB_NumCde, NB_NumTyp, DB_DnmNm, DB_DnmCde, DB_DnmTyp, FrmRat_Min, FrmRat_Max, FrmRat_Cst >from FrmRat_NumNmCdTyp_DnmNmCdTyp >where Formula_ID=?</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></design:name> > <design:position>1</design:position> > <design:nativeDataTypeCode>12</design:nativeDataTypeCode> > <design:nullability>Unknown</design:nullability> > <design:uiHints> > <design:displayName>Formula ID</design:displayName> > </design:uiHints> > </design:attributes> > <design:inputAttributes> > <design:elementAttributes> > <design:optional>true</design:optional> > <design:masksValue>false</design:masksValue> > <design:uiHints> > <design:promptStyle>TextField</design:promptStyle> > </design:uiHints> > </design:elementAttributes> > </design:inputAttributes> > </design:parameterDefinitions> > </design:DataSetParameters> ></model:DesignValues>]]></xml-property> > </oda-data-set> > </data-sets> > <page-setup> > <simple-master-page name="Simple MasterPage" id="2"> > <property name="leftMargin">0.5in</property> > <property name="rightMargin">0.5in</property> > <property name="textIndent">0em</property> > <page-header> > <grid id="13"> > <property name="width">100%</property> > <column id="14"/> > <column id="15"/> > <column id="16"/> > <row id="17"> > <cell id="18"> > <label id="21"> > <text-property name="text" key="LeastCostSolutionAndAnalysis">Least Cost Solution and Analysis</text-property> > </label> > </cell> > <cell id="19"> > <label id="22"> > <property name="textAlign">center</property> > <text-property name="text" key="TowerGroveFeed">Tower Grove Feed</text-property> > </label> > </cell> > <cell id="20"> > <text id="23"> > <property name="textAlign">right</property> > <property name="contentType">html</property> > <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> > </text> > </cell> > </row> > </grid> > </page-header> > <page-footer> > <grid id="383"> > <property name="width">100%</property> > <column id="384"/> > <column id="385"/> > <column id="386"/> > <row id="387"> > <cell id="388"/> > <cell id="389"/> > <cell id="390"> > <grid id="392"> > <property name="width">100%</property> > <column id="405"/> > <column id="393"/> > <column id="394"/> > <column id="395"/> > <row id="396"> > <cell id="404"> > <label id="403"> > <property name="textAlign">right</property> > <text-property name="text" key="Page"></text-property> > </label> > </cell> > <cell id="397"> > <auto-text id="398"> > <property name="textAlign">right</property> > <property name="type">page-number</property> > </auto-text> > </cell> > <cell id="399"> > <text id="400"> > <property name="textAlign">center</property> > <property name="contentType">plain</property> > <text-property name="content" key="Of"><![CDATA[/]]></text-property> > </text> > </cell> > <cell id="401"> > <auto-text id="402"> > <property name="type">total-page</property> > </auto-text> > </cell> > </row> > </grid> > </cell> > </row> > </grid> > </page-footer> > </simple-master-page> > </page-setup> > <body> > <grid name="FormulaHeader" id="24"> > <property name="width">100%</property> > <column id="25"/> > <column id="26"/> > <column id="27"/> > <column id="28"/> > <row id="29"> > <cell id="30"> > <label id="34"> > <text-property name="text" key="FormulaColon">Formula:</text-property> > </label> > </cell> > <cell id="31"> > <data id="327"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">BO_FrmNm</property> > <expression name="expression">dataSetRow["BO_FrmNm"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">BO_FrmNm</property> > </data> > </cell> > <cell id="32"> > <data id="328"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">BO_FrmCde</property> > <expression name="expression">dataSetRow["BO_FrmCde"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">BO_FrmCde</property> > </data> > </cell> > <cell id="33"> > <data id="329"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">BO_SpcNm</property> > <expression name="expression">dataSetRow["BO_SpcNm"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">BO_SpcNm</property> > </data> > </cell> > </row> > </grid> > <grid name="FormulaData" id="84"> > <property name="width">100%</property> > <column id="85"/> > <column id="86"/> > <column id="87"/> > <column id="88"/> > <column id="89"/> > <column id="90"/> > <column id="91"/> > <column id="92"/> > <row id="367"> > <cell id="368"> > <label id="376"> > <text-property name="text" key="TotalCost">Total Cost</text-property> > </label> > </cell> > <cell id="369"/> > <cell id="370"> > <property name="colSpan">2</property> > <property name="rowSpan">1</property> > <label id="378"> > <property name="textAlign">center</property> > <text-property name="text" key="BatchWeight">Weight</text-property> > </label> > </cell> > <cell id="372"> > <label id="380"> > <text-property name="text" key="ActualPercent">Act % </text-property> > </label> > </cell> > <cell id="373"> > <label id="381"> > <text-property name="text" key="MinimumPercent">Min %</text-property> > </label> > </cell> > <cell id="374"> > <label id="382"> > <text-property name="text" key="Type">Type</text-property> > </label> > </cell> > <cell id="375"/> > </row> > <row id="93"> > <cell id="94"> > <data id="117"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">TotalCost</property> > <expression name="expression">dataSetRow["TotalCost"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <property name="resultSetColumn">TotalCost</property> > </data> > </cell> > <cell id="95"> > <data id="118"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">CostTypNm</property> > <expression name="expression">dataSetRow["CostTypNm"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">CostTypNm</property> > </data> > </cell> > <cell id="96"> > <data id="119"> > <property name="textAlign">right</property> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">Weight</property> > <expression name="expression">dataSetRow["Weight"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <property name="resultSetColumn">Weight</property> > </data> > </cell> > <cell id="97"> > <data id="123"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">WeightUnit</property> > <expression name="expression">dataSetRow["WeightUnit"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">WeightUnit</property> > </data> > </cell> > <cell id="98"> > <data id="121"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">TotalIngredientPct</property> > <expression name="expression">dataSetRow["TotalIngredientPct"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <property name="resultSetColumn">TotalIngredientPct</property> > </data> > </cell> > <cell id="99"> > <data id="124"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">TotalIngredientMinimumPct</property> > <expression name="expression">dataSetRow["TotalIngredientMinimumPct"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <property name="resultSetColumn">TotalIngredientMinimumPct</property> > </data> > </cell> > <cell id="100"> > <data id="127"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">Type1</property> > <expression name="expression">dataSetRow["Type1"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">Type1</property> > </data> > </cell> > <cell id="101"> > <data id="126"> > <property name="dataSet">Formula</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">Type2</property> > <expression name="expression">dataSetRow["Type2"]</expression> > <property name="dataType">string</property> > </structure> > </list-property> > <property name="resultSetColumn">Type2</property> > </data> > </cell> > </row> > </grid> > <table name="IngredientsInFormula" id="39"> > <property name="width">100%</property> > <property name="dataSet">FormulaIngredientInSolution</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">IngName</property> > <expression name="expression">dataSetRow["IngName"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">IngCode</property> > <expression name="expression">dataSetRow["IngCode"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">FrmIng_DMYldWgt</property> > <expression name="expression">dataSetRow["FrmIng_DMYldWgt"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmIng_AFYldWgt</property> > <expression name="expression">dataSetRow["FrmIng_AFYldWgt"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmIng_Pct</property> > <expression name="expression">dataSetRow["FrmIng_Pct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">MinimumPct</property> > <expression name="expression">dataSetRow["MinimumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">MaximumPct</property> > <expression name="expression">dataSetRow["MaximumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">Cost</property> > <expression name="expression">dataSetRow["Cost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">LowCost</property> > <expression name="expression">dataSetRow["LowCost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">HighCost</property> > <expression name="expression">dataSetRow["HighCost"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <structure name="toc"> > <expression name="expressionValue">reportContext.getMessage("IngredientsInFormula");</expression> > </structure> > <column id="73"> > <property name="width">3in</property> > </column> > <column id="74"> > <property name="width">0.5in</property> > </column> > <column id="75"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="76"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="77"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="78"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="79"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="80"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="81"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <column id="82"> > <property name="width">0.5in</property> > <property name="textAlign">right</property> > </column> > <header> > <row id="330"> > <cell id="331"> > <property name="colSpan">10</property> > <property name="rowSpan">1</property> > <label id="83"> > <text-property name="text" key="IngredientsInFormula">Ingredients In Solution</text-property> > </label> > </cell> > </row> > <row id="40"> > <cell id="41"> > <label id="128"> > <property name="marginTop">0pt</property> > <property name="paddingTop">1pt</property> > <text-property name="text" key="Name">IngName</text-property> > </label> > </cell> > <cell id="42"> > <label id="130"> > <text-property name="text" key="Code">IngCode</text-property> > </label> > </cell> > <cell id="43"> > <label id="132"> > <text-property name="text" key="DMWeight">FrmIng_DMYldWgt</text-property> > </label> > </cell> > <cell id="44"> > <label id="134"> > <text-property name="text" key="AFWeight">FrmIng_AFYldWgt</text-property> > </label> > </cell> > <cell id="45"> > <label id="136"> > <text-property name="text" key="AFPercent">FrmIng_Pct</text-property> > </label> > </cell> > <cell id="46"> > <label id="138"> > <text-property name="text" key="MinimumPercent">MinimumPct</text-property> > </label> > </cell> > <cell id="47"> > <label id="140"> > <text-property name="text" key="MaximumPercent">MaximumPct</text-property> > </label> > </cell> > <cell id="48"> > <label id="142"> > <text-property name="text" key="Cost">Cost</text-property> > </label> > </cell> > <cell id="49"> > <label id="144"> > <text-property name="text" key="LowCost">LowCost</text-property> > </label> > </cell> > <cell id="50"> > <label id="146"> > <text-property name="text" key="HighCost">HighCost</text-property> > </label> > </cell> > </row> > </header> > <detail> > <row id="51"> > <cell id="52"> > <data id="129"> > <property name="resultSetColumn">IngName</property> > </data> > </cell> > <cell id="53"> > <data id="131"> > <property name="resultSetColumn">IngCode</property> > </data> > </cell> > <cell id="54"> > <data id="133"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">FrmIng_DMYldWgt</property> > </data> > </cell> > <cell id="55"> > <data id="135"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">FrmIng_AFYldWgt</property> > </data> > </cell> > <cell id="56"> > <data id="137"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">FrmIng_Pct</property> > </data> > </cell> > <cell id="57"> > <data id="139"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">MinimumPct</property> > </data> > </cell> > <cell id="58"> > <data id="141"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">MaximumPct</property> > </data> > </cell> > <cell id="59"> > <data id="143"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">Cost</property> > </data> > </cell> > <cell id="60"> > <data id="145"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">Fixed</property> > </structure> > <property name="resultSetColumn">LowCost</property> > </data> > </cell> > <cell id="61"> > <data id="147"> > <structure name="numberFormat"> > <property name="category">Fixed</property> > <property name="pattern">###0.000</property> > </structure> > <property name="resultSetColumn">HighCost</property> > </data> > </cell> > </row> > </detail> > <footer> > <row id="62"> > <cell id="63"/> > <cell id="64"/> > <cell id="65"/> > <cell id="66"/> > <cell id="67"/> > <cell id="68"/> > <cell id="69"/> > <cell id="70"/> > <cell id="71"/> > <cell id="72"/> > </row> > </footer> > </table> > <table id="411"> > <property name="width">100%</property> > <property name="dataSet">FormulaIngredientInSolution</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">IngName</property> > <expression name="expression">dataSetRow["IngName"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">IngCode</property> > <expression name="expression">dataSetRow["IngCode"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">FrmIng_DMYldWgt</property> > <expression name="expression">dataSetRow["FrmIng_DMYldWgt"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmIng_AFYldWgt</property> > <expression name="expression">dataSetRow["FrmIng_AFYldWgt"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmIng_Pct</property> > <expression name="expression">dataSetRow["FrmIng_Pct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">MinimumPct</property> > <expression name="expression">dataSetRow["MinimumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">MaximumPct</property> > <expression name="expression">dataSetRow["MaximumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">Cost</property> > <expression name="expression">dataSetRow["Cost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">LowCost</property> > <expression name="expression">dataSetRow["LowCost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">HighCost</property> > <expression name="expression">dataSetRow["HighCost"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <column id="445"> > <property name="width">3in</property> > </column> > <column id="446"> > <property name="width">0.5in</property> > </column> > <column id="447"> > <property name="width">0.5in</property> > </column> > <column id="448"> > <property name="width">0.5in</property> > </column> > <column id="449"> > <property name="width">0.5in</property> > </column> > <column id="450"> > <property name="width">0.5in</property> > </column> > <column id="451"> > <property name="width">0.5in</property> > </column> > <column id="452"> > <property name="width">0.5in</property> > </column> > <column id="453"> > <property name="width">0.5in</property> > </column> > <column id="454"> > <property name="width">0.5in</property> > </column> > <header> > <row id="412"> > <cell id="413"> > <label id="455"> > <text-property name="text" key="Name">IngName</text-property> > </label> > </cell> > <cell id="414"> > <label id="457"> > <text-property name="text" key="Code">IngCode</text-property> > </label> > </cell> > <cell id="415"> > <label id="459"> > <text-property name="text" key="DMWeight">FrmIng_DMYldWgt</text-property> > </label> > </cell> > <cell id="416"> > <label id="461"> > <text-property name="text" key="AFWeight">FrmIng_AFYldWgt</text-property> > </label> > </cell> > <cell id="417"> > <label id="463"> > <text-property name="text" key="AFPercent">FrmIng_Pct</text-property> > </label> > </cell> > <cell id="418"> > <label id="465"> > <text-property name="text" key="MinimumPercent">MinimumPct</text-property> > </label> > </cell> > <cell id="419"> > <label id="467"> > <text-property name="text" key="MaximumPercent">MaximumPct</text-property> > </label> > </cell> > <cell id="420"> > <label id="469"> > <text-property name="text" key="Cost">Cost</text-property> > </label> > </cell> > <cell id="421"> > <label id="471"> > <text-property name="text" key="LowCost">LowCost</text-property> > </label> > </cell> > <cell id="422"> > <label id="473"> > <text-property name="text" key="HighCost">HighCost</text-property> > </label> > </cell> > </row> > </header> > <detail> > <row id="423"> > <cell id="424"> > <data id="456"> > <property name="resultSetColumn">IngName</property> > </data> > </cell> > <cell id="425"> > <data id="458"> > <property name="resultSetColumn">IngCode</property> > </data> > </cell> > <cell id="426"> > <data id="460"> > <property name="resultSetColumn">FrmIng_DMYldWgt</property> > </data> > </cell> > <cell id="427"> > <data id="462"> > <property name="resultSetColumn">FrmIng_AFYldWgt</property> > </data> > </cell> > <cell id="428"> > <data id="464"> > <property name="resultSetColumn">FrmIng_Pct</property> > </data> > </cell> > <cell id="429"> > <data id="466"> > <property name="resultSetColumn">MinimumPct</property> > </data> > </cell> > <cell id="430"> > <data id="468"> > <property name="resultSetColumn">MaximumPct</property> > </data> > </cell> > <cell id="431"> > <data id="470"> > <property name="resultSetColumn">Cost</property> > </data> > </cell> > <cell id="432"> > <data id="472"> > <property name="resultSetColumn">LowCost</property> > </data> > </cell> > <cell id="433"> > <data id="474"> > <property name="resultSetColumn">HighCost</property> > </data> > </cell> > </row> > </detail> > <footer> > <row id="434"> > <cell id="435"/> > <cell id="436"/> > <cell id="437"/> > <cell id="438"/> > <cell id="439"/> > <cell id="440"/> > <cell id="441"/> > <cell id="442"/> > <cell id="443"/> > <cell id="444"/> > </row> > </footer> > </table> > <table name="IngredientsNotInFormula" id="155"> > <property name="width">100%</property> > <property name="dataSet">FormulaIngredientNotInSolution</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">IngName</property> > <expression name="expression">dataSetRow["IngName"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">IngCode</property> > <expression name="expression">dataSetRow["IngCode"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">MinimumPct</property> > <expression name="expression">dataSetRow["MinimumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">MaximumPct</property> > <expression name="expression">dataSetRow["MaximumPct"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">Cost</property> > <expression name="expression">dataSetRow["Cost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">LowCost</property> > <expression name="expression">dataSetRow["LowCost"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">HighCost</property> > <expression name="expression">dataSetRow["HighCost"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <structure name="toc"> > <expression name="expressionValue">reportContext.getMessage("IngredientsNotInFormula");</expression> > </structure> > <column id="180"> > <property name="width">3in</property> > </column> > <column id="181"> > <property name="width">0.5in</property> > </column> > <column id="410"> > <property name="width">1.5in</property> > </column> > <column id="182"> > <property name="width">0.5in</property> > </column> > <column id="183"> > <property name="width">0.5in</property> > </column> > <column id="184"> > <property name="width">0.5in</property> > </column> > <column id="185"> > <property name="width">0.5in</property> > </column> > <column id="186"> > <property name="width">0.5in</property> > </column> > <header> > <row id="341"> > <cell id="342"> > <property name="colSpan">8</property> > <property name="rowSpan">1</property> > <label id="154"> > <property name="borderBottomColor">#000000</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">medium</property> > <property name="borderLeftColor">#000000</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">medium</property> > <property name="borderRightColor">#000000</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">medium</property> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">medium</property> > <text-property name="text" key="IngredientsNotInFormula">Ingredients Not In Solution</text-property> > </label> > </cell> > </row> > <row id="156"> > <cell id="157"> > <label id="187"> > <text-property name="text" key="Name">IngName</text-property> > </label> > </cell> > <cell id="158"> > <label id="189"> > <text-property name="text" key="Code">IngCode</text-property> > </label> > </cell> > <cell id="407"/> > <cell id="159"> > <label id="191"> > <text-property name="text" key="MinimumPercent">MinimumPct</text-property> > </label> > </cell> > <cell id="160"> > <label id="193"> > <text-property name="text" key="MaximumPercent">MaximumPct</text-property> > </label> > </cell> > <cell id="161"> > <label id="195"> > <text-property name="text" key="Cost">Cost</text-property> > </label> > </cell> > <cell id="162"> > <label id="197"> > <text-property name="text" key="LowCost">LowCost</text-property> > </label> > </cell> > <cell id="163"> > <label id="199"> > <text-property name="text" key="HighCost">HighCost</text-property> > </label> > </cell> > </row> > </header> > <detail> > <row id="164"> > <cell id="165"> > <data id="188"> > <property name="resultSetColumn">IngName</property> > </data> > </cell> > <cell id="166"> > <data id="190"> > <property name="resultSetColumn">IngCode</property> > </data> > </cell> > <cell id="408"/> > <cell id="167"> > <data id="192"> > <property name="resultSetColumn">MinimumPct</property> > </data> > </cell> > <cell id="168"> > <data id="194"> > <property name="resultSetColumn">MaximumPct</property> > </data> > </cell> > <cell id="169"> > <data id="196"> > <property name="resultSetColumn">Cost</property> > </data> > </cell> > <cell id="170"> > <data id="198"> > <property name="resultSetColumn">LowCost</property> > </data> > </cell> > <cell id="171"> > <data id="200"> > <property name="resultSetColumn">HighCost</property> > </data> > </cell> > </row> > </detail> > <footer> > <row id="172"> > <cell id="173"/> > <cell id="174"/> > <cell id="409"/> > <cell id="175"/> > <cell id="176"/> > <cell id="177"/> > <cell id="178"/> > <cell id="179"/> > </row> > </footer> > </table> > <table name="NutrientsInSolution" id="208"> > <property name="width">100%</property> > <property name="dataSet">ForumulaNutrients</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">NutNm</property> > <expression name="expression">dataSetRow["NutNm"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">NutCde</property> > <expression name="expression">dataSetRow["NutCde"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">RatioUnitValue</property> > <expression name="expression">dataSetRow["RatioUnitValue"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">FrmNut_Act</property> > <expression name="expression">dataSetRow["FrmNut_Act"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmNut_Min</property> > <expression name="expression">dataSetRow["FrmNut_Min"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmNut_Max</property> > <expression name="expression">dataSetRow["FrmNut_Max"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmNut_Cst</property> > <expression name="expression">dataSetRow["FrmNut_Cst"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <structure name="toc"> > <expression name="expressionValue">reportContext.getMessage("NutrientsInFormula");</expression> > </structure> > <column id="239"/> > <column id="240"/> > <column id="241"/> > <column id="242"/> > <column id="243"/> > <column id="244"/> > <column id="245"/> > <header> > <row id="349"> > <cell id="350"> > <property name="colSpan">7</property> > <property name="rowSpan">1</property> > <label id="207"> > <property name="borderBottomColor">#000000</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">medium</property> > <property name="borderLeftColor">#000000</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">medium</property> > <property name="borderRightColor">#000000</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">medium</property> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">medium</property> > <text-property name="text" key="NutrientsInFormula">Nutrients In Solution</text-property> > </label> > </cell> > </row> > <row id="209"> > <cell id="210"> > <label id="248"> > <text-property name="text" key="Name">NutNm</text-property> > </label> > </cell> > <cell id="211"> > <label id="250"> > <text-property name="text" key="Code">NutCde</text-property> > </label> > </cell> > <cell id="212"> > <label id="252"> > <text-property name="text" key="Units">RatioUnitValue</text-property> > </label> > </cell> > <cell id="213"> > <label id="254"> > <text-property name="text" key="Actual">FrmNut_Act</text-property> > </label> > </cell> > <cell id="214"> > <label id="256"> > <text-property name="text" key="Minimum">FrmNut_Min</text-property> > </label> > </cell> > <cell id="215"> > <label id="258"> > <text-property name="text" key="Maximum">FrmNut_Max</text-property> > </label> > </cell> > <cell id="216"> > <label id="260"> > <text-property name="text" key="Cost">FrmNut_Cst</text-property> > </label> > </cell> > </row> > </header> > <detail> > <row id="219"> > <cell id="220"> > <data id="249"> > <property name="resultSetColumn">NutNm</property> > </data> > </cell> > <cell id="221"> > <data id="251"> > <property name="resultSetColumn">NutCde</property> > </data> > </cell> > <cell id="222"> > <data id="253"> > <property name="resultSetColumn">RatioUnitValue</property> > </data> > </cell> > <cell id="223"> > <data id="255"> > <property name="resultSetColumn">FrmNut_Act</property> > </data> > </cell> > <cell id="224"> > <data id="257"> > <property name="resultSetColumn">FrmNut_Min</property> > </data> > </cell> > <cell id="225"> > <data id="259"> > <property name="resultSetColumn">FrmNut_Max</property> > </data> > </cell> > <cell id="226"> > <data id="261"> > <property name="resultSetColumn">FrmNut_Cst</property> > </data> > </cell> > </row> > </detail> > <footer> > <row id="229"> > <cell id="230"/> > <cell id="231"/> > <cell id="232"/> > <cell id="233"/> > <cell id="234"/> > <cell id="235"/> > <cell id="236"/> > </row> > </footer> > </table> > <table name="Ratios" id="269"> > <property name="width">100%</property> > <property name="dataSet">FormulaRatios</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">NB_NumNm</property> > <expression name="expression">dataSetRow["NB_NumNm"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">NB_NumCde</property> > <expression name="expression">dataSetRow["NB_NumCde"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">NB_NumTyp</property> > <expression name="expression">dataSetRow["NB_NumTyp"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">DB_DnmNm</property> > <expression name="expression">dataSetRow["DB_DnmNm"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">DB_DnmCde</property> > <expression name="expression">dataSetRow["DB_DnmCde"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">DB_DnmTyp</property> > <expression name="expression">dataSetRow["DB_DnmTyp"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">FrmRat_Min</property> > <expression name="expression">dataSetRow["FrmRat_Min"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmRat_Max</property> > <expression name="expression">dataSetRow["FrmRat_Max"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">FrmRat_Cst</property> > <expression name="expression">dataSetRow["FrmRat_Cst"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > <structure name="toc"> > <expression name="expressionValue">reportContext.getMessage("Ratios");</expression> > </structure> > <column id="300"/> > <column id="301"/> > <column id="302"/> > <column id="303"/> > <column id="304"/> > <column id="305"/> > <column id="306"/> > <column id="307"/> > <column id="308"/> > <header> > <row id="357"> > <cell id="358"> > <property name="colSpan">9</property> > <property name="rowSpan">1</property> > <label id="268"> > <property name="borderBottomColor">#000000</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">medium</property> > <property name="borderLeftColor">#000000</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">medium</property> > <property name="borderRightColor">#000000</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">medium</property> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">medium</property> > <text-property name="text" key="Ratios">Ratios</text-property> > </label> > </cell> > </row> > <row id="270"> > <cell id="271"> > <label id="309"> > <text-property name="text" key="NumeratorName">NB_NumNm</text-property> > </label> > </cell> > <cell id="272"> > <label id="311"> > <text-property name="text" key="Code">NB_NumCde</text-property> > </label> > </cell> > <cell id="273"> > <label id="313"> > <text-property name="text" key="Type">NB_NumTyp</text-property> > </label> > </cell> > <cell id="274"> > <label id="315"> > <text-property name="text" key="DenominatorName">DB_DnmNm</text-property> > </label> > </cell> > <cell id="275"> > <label id="317"> > <text-property name="text" key="Code">DB_DnmCde</text-property> > </label> > </cell> > <cell id="276"> > <label id="319"> > <text-property name="text" key="Type">DB_DnmTyp</text-property> > </label> > </cell> > <cell id="277"> > <label id="321"> > <text-property name="text" key="Minimum">FrmRat_Min</text-property> > </label> > </cell> > <cell id="278"> > <label id="323"> > <text-property name="text" key="Maximum">FrmRat_Max</text-property> > </label> > </cell> > <cell id="279"> > <label id="325"> > <text-property name="text" key="Cost">FrmRat_Cst</text-property> > </label> > </cell> > </row> > </header> > <detail> > <row id="280"> > <cell id="281"> > <data id="310"> > <property name="resultSetColumn">NB_NumNm</property> > </data> > </cell> > <cell id="282"> > <data id="312"> > <property name="resultSetColumn">NB_NumCde</property> > </data> > </cell> > <cell id="283"> > <data id="314"> > <property name="resultSetColumn">NB_NumTyp</property> > </data> > </cell> > <cell id="284"> > <data id="316"> > <property name="resultSetColumn">DB_DnmNm</property> > </data> > </cell> > <cell id="285"> > <data id="318"> > <property name="resultSetColumn">DB_DnmCde</property> > </data> > </cell> > <cell id="286"> > <data id="320"> > <property name="resultSetColumn">DB_DnmTyp</property> > </data> > </cell> > <cell id="287"> > <data id="322"> > <property name="resultSetColumn">FrmRat_Min</property> > </data> > </cell> > <cell id="288"> > <data id="324"> > <property name="resultSetColumn">FrmRat_Max</property> > </data> > </cell> > <cell id="289"> > <data id="326"> > <property name="resultSetColumn">FrmRat_Cst</property> > </data> > </cell> > </row> > </detail> > <footer> > <row id="290"> > <cell id="291"/> > <cell id="292"/> > <cell id="293"/> > <cell id="294"/> > <cell id="295"/> > <cell id="296"/> > <cell id="297"/> > <cell id="298"/> > <cell id="299"/> > </row> > </footer> > </table> > </body> ></report>
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 207568
: 81255