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 94811 Details for
Bug 225695
BIRT's numeric format can produce "-0"
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
Terms of Use
|
Copyright Agent
Product Sales by Country.rptdesign
Product Sales by Country.rptdesign (text/plain), 83.03 KB, created by
Paul Rogers
on 2008-04-04 01:24:57 EDT
(
hide
)
Description:
Product Sales by Country.rptdesign
Filename:
MIME Type:
Creator:
Paul Rogers
Created:
2008-04-04 01:24:57 EDT
Size:
83.03 KB
patch
obsolete
><?xml version="1.0" encoding="UTF-8"?> ><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1"> > <property name="author">Actuate</property> > <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080227-1131></property> > <property name="units">in</property> > <text-property name="title">Product Sales by Country</text-property> > <property name="comments">Copyright (c) 2007 <<Your Company Name here>></property> > <html-property name="description">Example report with totals at multiple grouping levels. Also shows a bar chart.</html-property> > <text-property name="displayName">Product Sales by Country</text-property> > <property name="iconFile">/templates/blank_report.gif</property> > <data-sources> > <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Classic Models" id="6"> > <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property> > <property name="odaURL">jdbc:classicmodels:sampledb</property> > <property name="odaUser">ClassicModels</property> > </oda-data-source> > </data-sources> > <data-sets> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Product Sales by Customer" id="7"> > <list-property name="computedColumns"> > <structure> > <property name="name">extendedPrice</property> > <expression name="expression">row["QUANTITYORDERED"] * row["PRICEEACH"]</expression> > <property name="dataType">any</property> > </structure> > </list-property> > <list-property name="columnHints"> > <structure> > <property name="columnName">CUSTOMERNUMBER</property> > <property name="displayName">CUSTOMERNUMBER</property> > </structure> > <structure> > <property name="columnName">CUSTOMERNAME</property> > <property name="displayName">CUSTOMERNAME</property> > </structure> > <structure> > <property name="columnName">STATE</property> > <property name="displayName">STATE</property> > </structure> > <structure> > <property name="columnName">COUNTRY</property> > <property name="displayName">COUNTRY</property> > </structure> > <structure> > <property name="columnName">ORDERNUMBER</property> > <property name="displayName">ORDERNUMBER</property> > </structure> > <structure> > <property name="columnName">ORDERDATE</property> > <property name="displayName">ORDERDATE</property> > </structure> > <structure> > <property name="columnName">QUANTITYORDERED</property> > <property name="displayName">QUANTITYORDERED</property> > </structure> > <structure> > <property name="columnName">PRICEEACH</property> > <property name="displayName">PRICEEACH</property> > </structure> > </list-property> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">CUSTOMERNUMBER</property> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">CUSTOMERNAME</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">STATE</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">COUNTRY</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">ORDERNUMBER</property> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">ORDERDATE</property> > <property name="dataType">date</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">QUANTITYORDERED</property> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">PRICEEACH</property> > <property name="dataType">float</property> > </structure> > <structure> > <property name="position">9</property> > <property name="name">extendedPrice</property> > <property name="dataType">any</property> > </structure> > </list-property> > </structure> > <property name="dataSource">Classic Models</property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">CUSTOMERNUMBER</property> > <property name="nativeName">CUSTOMERNUMBER</property> > <property name="dataType">integer</property> > <property name="nativeDataType">4</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">CUSTOMERNAME</property> > <property name="nativeName">CUSTOMERNAME</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">3</property> > <property name="name">STATE</property> > <property name="nativeName">STATE</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">4</property> > <property name="name">COUNTRY</property> > <property name="nativeName">COUNTRY</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">5</property> > <property name="name">ORDERNUMBER</property> > <property name="nativeName">ORDERNUMBER</property> > <property name="dataType">integer</property> > <property name="nativeDataType">4</property> > </structure> > <structure> > <property name="position">6</property> > <property name="name">ORDERDATE</property> > <property name="nativeName">ORDERDATE</property> > <property name="dataType">date</property> > <property name="nativeDataType">91</property> > </structure> > <structure> > <property name="position">7</property> > <property name="name">QUANTITYORDERED</property> > <property name="nativeName">QUANTITYORDERED</property> > <property name="dataType">integer</property> > <property name="nativeDataType">4</property> > </structure> > <structure> > <property name="position">8</property> > <property name="name">PRICEEACH</property> > <property name="nativeName">PRICEEACH</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select CUSTOMERS.CUSTOMERNUMBER, > CUSTOMERS.CUSTOMERNAME, > CUSTOMERS.STATE, > CUSTOMERS.COUNTRY, > ORDERS.ORDERNUMBER, > ORDERS.ORDERDATE, > ORDERDETAILS.QUANTITYORDERED, > ORDERDETAILS.PRICEEACH >from CUSTOMERS, ORDERS, ORDERDETAILS >where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER > and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER >order by COUNTRY, CUSTOMERNAME</property> > </oda-data-set> > <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Current Year Sales by Country" id="222"> > <list-property name="columnHints"> > <structure> > <property name="columnName">COUNTRY</property> > <property name="displayName">COUNTRY</property> > </structure> > <structure> > <property name="columnName">SALES</property> > <property name="displayName">SALES</property> > </structure> > </list-property> > <structure name="cachedMetaData"> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">COUNTRY</property> > <property name="dataType">string</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">SALES</property> > <property name="dataType">float</property> > </structure> > </list-property> > </structure> > <property name="dataSource">Classic Models</property> > <list-property name="resultSet"> > <structure> > <property name="position">1</property> > <property name="name">COUNTRY</property> > <property name="nativeName">COUNTRY</property> > <property name="dataType">string</property> > <property name="nativeDataType">12</property> > </structure> > <structure> > <property name="position">2</property> > <property name="name">SALES</property> > <property name="nativeName">SALES</property> > <property name="dataType">float</property> > <property name="nativeDataType">8</property> > </structure> > </list-property> > <property name="queryText">select CUSTOMERS.COUNTRY, > SUM(ORDERDETAILS.QUANTITYORDERED * > ORDERDETAILS.PRICEEACH) SALES >from CUSTOMERS, ORDERS, ORDERDETAILS >where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER > and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER > and YEAR( ORDERS.ORDERDATE ) = 2005 >group by CUSTOMERS.COUNTRY >order by COUNTRY</property> > </oda-data-set> > </data-sets> > <styles> > <style name="crosstab-cell" id="4"> > <property name="borderBottomColor">#CCCCCC</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">1pt</property> > <property name="borderLeftColor">#CCCCCC</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">1pt</property> > <property name="borderRightColor">#CCCCCC</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">1pt</property> > <property name="borderTopColor">#CCCCCC</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">1pt</property> > </style> > <style name="crosstab" id="5"> > <property name="borderBottomColor">#CCCCCC</property> > <property name="borderBottomStyle">solid</property> > <property name="borderBottomWidth">1pt</property> > <property name="borderLeftColor">#CCCCCC</property> > <property name="borderLeftStyle">solid</property> > <property name="borderLeftWidth">1pt</property> > <property name="borderRightColor">#CCCCCC</property> > <property name="borderRightStyle">solid</property> > <property name="borderRightWidth">1pt</property> > <property name="borderTopColor">#CCCCCC</property> > <property name="borderTopStyle">solid</property> > <property name="borderTopWidth">1pt</property> > </style> > <style name="report" id="208"> > <property name="fontFamily">sans-serif</property> > <property name="fontSize">10pt</property> > </style> > <style name="table-header" id="209"> > <property name="fontWeight">bold</property> > <property name="color">#314C7C</property> > <property name="textAlign">left</property> > </style> > <style name="total" id="210"> > <structure name="numberFormat"> > <property name="category">Currency</property> > <property name="pattern">#,##0</property> > </structure> > <property name="textAlign">right</property> > </style> > <style name="major-total" id="240"> > <structure name="numberFormat"> > <property name="category">Currency</property> > <property name="pattern">$#,##0</property> > </structure> > <property name="textAlign">right</property> > </style> > <style name="total-change" id="241"> > <structure name="numberFormat"> > <property name="category">Percent</property> > <property name="pattern">###0%</property> > </structure> > <property name="textAlign">right</property> > </style> > </styles> > <page-setup> > <simple-master-page name="Simple MasterPage" id="2"> > <property name="topMargin">0.25in</property> > <property name="leftMargin">0.25in</property> > <property name="bottomMargin">0.25in</property> > <property name="rightMargin">0.25in</property> > <page-footer> > <grid id="211"> > <property name="width">100%</property> > <column id="212"/> > <column id="213"/> > <column id="214"/> > <row id="215"> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">dotted</property> > <property name="borderTopWidth">thin</property> > <cell id="216"> > <property name="paddingTop">6pt</property> > <property name="paddingRight">1pt</property> > <data id="221"> > <structure name="dateTimeFormat"> > <property name="category">Long Date</property> > <property name="pattern">Long Date</property> > </structure> > <list-property name="boundDataColumns"> > <structure> > <property name="name">DateField</property> > <expression name="expression">new Date( )</expression> > <property name="dataType">date</property> > </structure> > </list-property> > <property name="resultSetColumn">DateField</property> > </data> > </cell> > <cell id="217"> > <property name="paddingTop">6pt</property> > <property name="paddingRight">1pt</property> > </cell> > <cell id="218"> > <property name="paddingTop">6pt</property> > <property name="paddingRight">1pt</property> > <auto-text id="220"> > <property name="textAlign">right</property> > <property name="type">page-number</property> > </auto-text> > </cell> > </row> > </grid> > </page-footer> > </simple-master-page> > </page-setup> > <body> > <label id="201"> > <property name="fontSize">x-large</property> > <property name="fontWeight">bold</property> > <property name="color">#314C7C</property> > <property name="paddingTop">1pt</property> > <property name="paddingLeft">1pt</property> > <property name="paddingBottom">12pt</property> > <property name="textAlign">center</property> > <text-property name="text">Product Sales By Country</text-property> > </label> > <grid id="224"> > <property name="textAlign">center</property> > <property name="width">100%</property> > <column id="225"/> > <column id="226"/> > <column id="227"/> > <row id="228"> > <cell id="229"/> > <cell id="230"> > <extended-item extensionName="Chart" name="SalesByCountryChart" id="223"> > <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType"> > <Type>Bar Chart</Type> > <SubType>Side-by-side</SubType> > <Block> > <Children xsi:type="layout:TitleBlock"> > <Bounds> > <Left>0.0</Left> > <Top>0.0</Top> > <Width>0.0</Width> > <Height>0.0</Height> > </Bounds> > <Insets> > <Top>3.0</Top> > <Left>3.0</Left> > <Bottom>3.0</Bottom> > <Right>3.0</Right> > </Insets> > <Row>-1</Row> > <Column>-1</Column> > <Rowspan>-1</Rowspan> > <Columnspan>-1</Columnspan> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Visible>true</Visible> > <Label> > <Caption> > <Value>Sales by Country</Value> > <Font> > <Size>16.0</Size> > <Bold>true</Bold> > <Alignment> > <horizontalAlignment>Center</horizontalAlignment> > <verticalAlignment>Center</verticalAlignment> > </Alignment> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>true</Visible> > </Label> > </Children> > <Children xsi:type="layout:Plot"> > <Bounds> > <Left>0.0</Left> > <Top>0.0</Top> > <Width>0.0</Width> > <Height>0.0</Height> > </Bounds> > <Insets> > <Top>3.0</Top> > <Left>3.0</Left> > <Bottom>3.0</Bottom> > <Right>3.0</Right> > </Insets> > <Row>-1</Row> > <Column>-1</Column> > <Rowspan>-1</Rowspan> > <Columnspan>-1</Columnspan> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Visible>true</Visible> > <HorizontalSpacing>5</HorizontalSpacing> > <VerticalSpacing>5</VerticalSpacing> > <ClientArea> > <Outline> > <Style>Solid</Style> > <Thickness>0</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>0.0</Left> > <Bottom>0.0</Bottom> > <Right>0.0</Right> > </Insets> > </ClientArea> > </Children> > <Children xsi:type="layout:Legend"> > <Bounds> > <Left>0.0</Left> > <Top>0.0</Top> > <Width>0.0</Width> > <Height>0.0</Height> > </Bounds> > <Insets> > <Top>3.0</Top> > <Left>3.0</Left> > <Bottom>3.0</Bottom> > <Right>3.0</Right> > </Insets> > <Row>-1</Row> > <Column>-1</Column> > <Rowspan>-1</Rowspan> > <Columnspan>-1</Columnspan> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Visible>false</Visible> > <ClientArea> > <Outline> > <Style>Solid</Style> > <Thickness>0</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Insets> > <Top>2.0</Top> > <Left>2.0</Left> > <Bottom>2.0</Bottom> > <Right>2.0</Right> > </Insets> > </ClientArea> > <Text> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Text> > <Orientation>Vertical</Orientation> > <Direction>Top_Bottom</Direction> > <Separator> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>true</Visible> > </Separator> > <Position>Right</Position> > <ItemType>Series</ItemType> > <Title> > <Caption> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>false</Visible> > </Title> > <TitlePosition>Above</TitlePosition> > </Children> > <Bounds> > <Left>0.0</Left> > <Top>0.0</Top> > <Width>576.0</Width> > <Height>216.0</Height> > </Bounds> > <Insets> > <Top>3.0</Top> > <Left>3.0</Left> > <Bottom>3.0</Bottom> > <Right>3.0</Right> > </Insets> > <Row>-1</Row> > <Column>-1</Column> > <Rowspan>-1</Rowspan> > <Columnspan>-1</Columnspan> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Visible>true</Visible> > </Block> > <Dimension>Two_Dimensional</Dimension> > <Units>Points</Units> > <SeriesThickness>10.0</SeriesThickness> > <SampleData> > <BaseSampleData> > <DataSetRepresentation>A, B, C</DataSetRepresentation> > </BaseSampleData> > <OrthogonalSampleData> > <DataSetRepresentation>5,4,12</DataSetRepresentation> > <SeriesDefinitionIndex>0</SeriesDefinitionIndex> > </OrthogonalSampleData> > </SampleData> > <Interactivity/> > <Axes> > <Type>Text</Type> > <Title> > <Caption> > <Value>X-Axis Title</Value> > <Font> > <Size>14.0</Size> > <Bold>true</Bold> > <Alignment> > <horizontalAlignment>Center</horizontalAlignment> > <verticalAlignment>Center</verticalAlignment> > </Alignment> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>false</Visible> > </Title> > <TitlePosition>Below</TitlePosition> > <AssociatedAxes> > <Type>Linear</Type> > <Title> > <Caption> > <Value>Y-Axis Title</Value> > <Font> > <Size>14.0</Size> > <Bold>true</Bold> > <Alignment> > <horizontalAlignment>Center</horizontalAlignment> > <verticalAlignment>Center</verticalAlignment> > </Alignment> > <Rotation>90.0</Rotation> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>false</Visible> > </Title> > <TitlePosition>Left</TitlePosition> > <SeriesDefinitions> > <Query> > <Definition></Definition> > </Query> > <SeriesPalette> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>80</Red> > <Green>166</Green> > <Blue>218</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>242</Red> > <Green>88</Green> > <Blue>106</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>232</Red> > <Green>172</Green> > <Blue>57</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>255</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>64</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>170</Red> > <Green>85</Green> > <Blue>85</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>192</Red> > <Green>192</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>192</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>7</Red> > <Green>146</Green> > <Blue>94</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>128</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>255</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>0</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>64</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>80</Red> > <Green>240</Green> > <Blue>120</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>64</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>0</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>0</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>64</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>0</Blue> > </Entries> > </SeriesPalette> > <Series xsi:type="type:BarSeries"> > <Visible>true</Visible> > <Label> > <Caption> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>false</Visible> > </Label> > <DataDefinition> > <Definition>row["SALES"]</Definition> > </DataDefinition> > <SeriesIdentifier></SeriesIdentifier> > <DataPoint> > <Components> > <Type>Orthogonal_Value</Type> > </Components> > <Separator>, </Separator> > </DataPoint> > <LabelPosition>Outside</LabelPosition> > <Stacked>false</Stacked> > <Riser>Rectangle</Riser> > </Series> > <Grouping> > <Enabled>false</Enabled> > <GroupingInterval>2</GroupingInterval> > <GroupType>Text</GroupType> > <AggregateExpression>Sum</AggregateExpression> > </Grouping> > <Sorting>Ascending</Sorting> > </SeriesDefinitions> > <Orientation>Vertical</Orientation> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>true</Visible> > </LineAttributes> > <Label> > <Caption> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>true</Visible> > </Label> > <LabelPosition>Left</LabelPosition> > <Staggered>false</Staggered> > <MajorGrid> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>196</Red> > <Green>196</Green> > <Blue>196</Blue> > </Color> > <Visible>false</Visible> > </LineAttributes> > <TickStyle>Across</TickStyle> > <TickAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>196</Red> > <Green>196</Green> > <Blue>196</Blue> > </Color> > <Visible>true</Visible> > </TickAttributes> > </MajorGrid> > <MinorGrid> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>225</Red> > <Green>225</Green> > <Blue>225</Blue> > </Color> > <Visible>false</Visible> > </LineAttributes> > <TickStyle>Across</TickStyle> > <TickAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>225</Red> > <Green>225</Green> > <Blue>225</Blue> > </Color> > <Visible>false</Visible> > </TickAttributes> > </MinorGrid> > <Scale> > <MinorGridsPerUnit>5</MinorGridsPerUnit> > </Scale> > <Origin> > <Type>Min</Type> > <Value xsi:type="data:NumberDataElement"> > <Value>0.0</Value> > </Value> > </Origin> > <PrimaryAxis>true</PrimaryAxis> > <Percent>false</Percent> > </AssociatedAxes> > <SeriesDefinitions> > <Query> > <Definition></Definition> > </Query> > <SeriesPalette> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>80</Red> > <Green>166</Green> > <Blue>218</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>242</Red> > <Green>88</Green> > <Blue>106</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>232</Red> > <Green>172</Green> > <Blue>57</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>255</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>64</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>170</Red> > <Green>85</Green> > <Blue>85</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>192</Red> > <Green>192</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>192</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>7</Red> > <Green>146</Green> > <Blue>94</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>128</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>255</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>192</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>0</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>64</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>80</Red> > <Green>240</Green> > <Blue>120</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>64</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>0</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>0</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>64</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>128</Red> > <Green>128</Green> > <Blue>128</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>64</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Entries> > <Entries xsi:type="attribute:ColorDefinition"> > <Transparency>255</Transparency> > <Red>255</Red> > <Green>128</Green> > <Blue>0</Blue> > </Entries> > </SeriesPalette> > <Series> > <Visible>true</Visible> > <Label> > <Caption> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>false</Visible> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>false</Visible> > </Label> > <DataDefinition> > <Definition>row["COUNTRY"]</Definition> > </DataDefinition> > <SeriesIdentifier></SeriesIdentifier> > <DataPoint> > <Components> > <Type>Orthogonal_Value</Type> > </Components> > <Separator>, </Separator> > </DataPoint> > <LabelPosition>Outside</LabelPosition> > <Stacked>false</Stacked> > </Series> > <Grouping> > <Enabled>false</Enabled> > <GroupingInterval>2</GroupingInterval> > <GroupType>Text</GroupType> > <AggregateExpression>Sum</AggregateExpression> > </Grouping> > </SeriesDefinitions> > <Orientation>Horizontal</Orientation> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > <Visible>true</Visible> > </LineAttributes> > <Label> > <Caption> > <Value></Value> > <Font> > <Alignment/> > </Font> > </Caption> > <Background xsi:type="attribute:ColorDefinition"> > <Transparency>0</Transparency> > <Red>255</Red> > <Green>255</Green> > <Blue>255</Blue> > </Background> > <Outline> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>0</Red> > <Green>0</Green> > <Blue>0</Blue> > </Color> > </Outline> > <Insets> > <Top>0.0</Top> > <Left>2.0</Left> > <Bottom>0.0</Bottom> > <Right>3.0</Right> > </Insets> > <Visible>true</Visible> > </Label> > <LabelPosition>Below</LabelPosition> > <Staggered>true</Staggered> > <MajorGrid> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>196</Red> > <Green>196</Green> > <Blue>196</Blue> > </Color> > <Visible>false</Visible> > </LineAttributes> > <TickStyle>Across</TickStyle> > <TickAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>196</Red> > <Green>196</Green> > <Blue>196</Blue> > </Color> > <Visible>true</Visible> > </TickAttributes> > </MajorGrid> > <MinorGrid> > <LineAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>225</Red> > <Green>225</Green> > <Blue>225</Blue> > </Color> > <Visible>false</Visible> > </LineAttributes> > <TickStyle>Across</TickStyle> > <TickAttributes> > <Style>Solid</Style> > <Thickness>1</Thickness> > <Color> > <Transparency>255</Transparency> > <Red>225</Red> > <Green>225</Green> > <Blue>225</Blue> > </Color> > <Visible>false</Visible> > </TickAttributes> > </MinorGrid> > <Scale> > <MinorGridsPerUnit>5</MinorGridsPerUnit> > </Scale> > <Origin> > <Type>Min</Type> > <Value xsi:type="data:NumberDataElement"> > <Value>0.0</Value> > </Value> > </Origin> > <PrimaryAxis>true</PrimaryAxis> > <CategoryAxis>true</CategoryAxis> > <Percent>false</Percent> > </Axes> > <Orientation>Vertical</Orientation> > <UnitSpacing>50.0</UnitSpacing> > <Rotation/> ></model:ChartWithAxes> >]]></xml-property> > <property name="outputFormat">SVG</property> > <property name="textAlign">center</property> > <property name="textIndent">0em</property> > <property name="orphans">2</property> > <property name="marginTop">0pt</property> > <property name="dataSet">Current Year Sales by Country</property> > <property name="height">3in</property> > <property name="width">8in</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">COUNTRY</property> > <expression name="expression">dataSetRow["COUNTRY"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">SALES</property> > <expression name="expression">dataSetRow["SALES"]</expression> > <property name="dataType">float</property> > </structure> > </list-property> > </extended-item> > </cell> > <cell id="231"/> > </row> > </grid> > <table id="8"> > <property name="marginTop">0pt</property> > <property name="width">100%</property> > <property name="dataSet">Product Sales by Customer</property> > <list-property name="boundDataColumns"> > <structure> > <property name="name">CUSTOMERNUMBER</property> > <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="name">CUSTOMERNAME</property> > <expression name="expression">dataSetRow["CUSTOMERNAME"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">COUNTRY</property> > <expression name="expression">dataSetRow["COUNTRY"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">ORDERNUMBER</property> > <expression name="expression">dataSetRow["ORDERNUMBER"]</expression> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="name">QUANTITYORDERED</property> > <expression name="expression">dataSetRow["QUANTITYORDERED"]</expression> > <property name="dataType">integer</property> > </structure> > <structure> > <property name="name">PRICEEACH</property> > <expression name="expression">dataSetRow["PRICEEACH"]</expression> > <property name="dataType">float</property> > </structure> > <structure> > <property name="name">STATE</property> > <expression name="expression">dataSetRow["STATE"]</expression> > <property name="dataType">string</property> > </structure> > <structure> > <property name="name">CurrentYearSalesForCustomer</property> > <property name="displayName">Current Year Sales by Customer</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>Customer</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2005, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2006, 1, 1 )</expression> > </structure> > <structure> > <property name="name">PriorYearSalesForCustomer</property> > <property name="displayName">Prior Year Sales by customer</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>Customer</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2004, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2005, 1, 1 )</expression> > </structure> > <structure> > <property name="name">Prior_Year_Sales_Cust</property> > <property name="displayName">Prior Year Sales</property> > <expression name="expression">row["PriorYearSalesForCustomer"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Current_Year_Sales_Cust</property> > <property name="displayName">Current Year Sales</property> > <expression name="expression">row["CurrentYearSalesForCustomer"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Sales_Change_Cust</property> > <property name="displayName">Change in Sales</property> > <expression name="expression">Finance.percent( row["PriorYearSalesForCustomer"], >row["CurrentYearSalesForCustomer"] - row["PriorYearSalesForCustomer"] );</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">CurrentYearSalesForCountry</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>country</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2005, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2006, 1, 1 )</expression> > </structure> > <structure> > <property name="name">PriorYearSalesForCountry</property> > <property name="displayName">Prior Year Sales by Country</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>country</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2004, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2005, 1, 1 )</expression> > </structure> > <structure> > <property name="name">Prior_Year_Total_Country</property> > <property name="displayName">Prior Year Sales by Country</property> > <expression name="expression">row["PriorYearSalesForCountry"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Current_Year_Total_Country</property> > <property name="displayName">Current Year Total by Country</property> > <expression name="expression">row["CurrentYearSalesForCountry"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Sales_Change_Country</property> > <expression name="expression">base = row["PriorYearSalesForCountry"]; >change = row["CurrentYearSalesForCountry"] - row["PriorYearSalesForCountry"]; > >if ( base == 0 ) 1; >else change / base;</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">PriorYearSalesTotal</property> > <property name="displayName">Prior Year Sales Total</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2004, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2005, 1, 1 )</expression> > </structure> > <structure> > <property name="name">CurrentYearSalesTotal</property> > <property name="displayName">Current Year Sales Total</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2005, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2006, 1, 1 )</expression> > </structure> > <structure> > <property name="name">Prior_Year_Total</property> > <property name="displayName">Prior Year Sales Total</property> > <expression name="expression">row["PriorYearSalesTotal"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Current_Year_Total</property> > <property name="displayName">Current Year Sales Total</property> > <expression name="expression">row["CurrentYearSalesTotal"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Sales_Change_Total</property> > <property name="displayName">Sales Change Total</property> > <expression name="expression">row["CurrentYearSalesTotal"] - row["PriorYearSalesTotal"] >Finance.percent( row["PriorYearSalesTotal"], >row["CurrentYearSalesTotal"] - row["PriorYearSalesTotal"] );</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">PriorYearSalesForState</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>State</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2004, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2005, 1, 1 )</expression> > </structure> > <structure> > <property name="name">CurrentYearSalesForState</property> > <expression name="expression">dataSetRow["extendedPrice"]</expression> > <property name="dataType">any</property> > <simple-property-list name="aggregateOn"> > <value>State</value> > </simple-property-list> > <property name="aggregateFunction">SUM</property> > <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2005, 1, 1 ) && >dataSetRow["ORDERDATE"] < new Date( 2006, 1, 1 )</expression> > </structure> > <structure> > <property name="name">Prior_Year_Sales_State</property> > <property name="displayName">Prior Year Sales by State</property> > <expression name="expression">row["PriorYearSalesForState"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Current_Year_Sales_State</property> > <property name="displayName">Current Year Sales by State</property> > <expression name="expression">row["CurrentYearSalesForState"]</expression> > <property name="dataType">any</property> > </structure> > <structure> > <property name="name">Sales_Change_State</property> > <property name="displayName">Sales Change by State</property> > <expression name="expression">base = row["PriorYearSalesForState"]; >change = row["CurrentYearSalesForState"] - row["PriorYearSalesForState"]; > >if ( base == 0 ) 1; >else change / base;</expression> > <property name="dataType">any</property> > </structure> > </list-property> > <column id="21"> > <property name="width">0.78125in</property> > </column> > <column id="22"> > <property name="width">0.5520833333in</property> > </column> > <column id="23"/> > <column id="27"> > <property name="width">8em</property> > </column> > <column id="31"> > <property name="width">8em</property> > </column> > <column id="86"> > <property name="width">8em</property> > </column> > <column id="94"/> > <header> > <row id="232"> > <cell id="233"> > <property name="colSpan">7</property> > <property name="rowSpan">1</property> > </cell> > </row> > <row id="9"> > <property name="backgroundColor">#FFF1A8</property> > <cell id="10"> > <label id="76"> > <property name="textAlign">left</property> > <text-property name="text">Country</text-property> > </label> > </cell> > <cell id="11"> > <label id="72"> > <property name="textAlign">left</property> > <text-property name="text">State</text-property> > </label> > </cell> > <cell id="12"> > <label id="77"> > <property name="textAlign">left</property> > <text-property name="text">Customer</text-property> > </label> > </cell> > <cell id="24"> > <label id="95"> > <property name="marginTop">0pt</property> > <property name="paddingTop">1pt</property> > <property name="textAlign">right</property> > <text-property name="text">Prior Year</text-property> > </label> > </cell> > <cell id="28"> > <label id="96"> > <property name="marginTop">0pt</property> > <property name="paddingTop">1pt</property> > <property name="textAlign">right</property> > <text-property name="text">Current Year</text-property> > </label> > </cell> > <cell id="79"> > <label id="97"> > <property name="marginTop">0pt</property> > <property name="paddingTop">1pt</property> > <property name="textAlign">right</property> > <text-property name="text">Change</text-property> > </label> > </cell> > <cell id="87"/> > </row> > </header> > <group id="59"> > <property name="groupName">country</property> > <property name="interval">none</property> > <property name="sortDirection">asc</property> > <expression name="keyExpr">row["COUNTRY"]</expression> > <structure name="toc"> > <expression name="expressionValue">row["COUNTRY"]</expression> > </structure> > <property name="repeatHeader">true</property> > <property name="hideDetail">false</property> > <property name="pageBreakAfter">auto</property> > <property name="pageBreakBefore">auto</property> > <property name="pageBreakInside">auto</property> > <header> > <row id="60"> > <property name="backgroundColor">#E0ECFF</property> > <cell id="61"> > <property name="colSpan">3</property> > <property name="rowSpan">1</property> > <data id="150"> > <property name="marginTop">0pt</property> > <property name="paddingTop">1pt</property> > <property name="resultSetColumn">COUNTRY</property> > </data> > </cell> > <cell id="64"> > <data id="180"> > <property name="style">major-total</property> > <property name="resultSetColumn">Prior_Year_Total_Country</property> > </data> > </cell> > <cell id="65"> > <data id="181"> > <property name="style">major-total</property> > <property name="resultSetColumn">Current_Year_Total_Country</property> > </data> > </cell> > <cell id="80"> > <data id="182"> > <property name="style">total-change</property> > <property name="resultSetColumn">Sales_Change_Country</property> > </data> > </cell> > <cell id="88"> > <property name="paddingTop">1pt</property> > <property name="paddingLeft">2em</property> > <image name="Country Indicator" id="204"> > <method name="onRender"><![CDATA[diff = row["CurrentYearSalesForCountry"] - row["PriorYearSalesForCountry"]; >if ( diff > 100 ) > imageName = "Up Trend Green Button 16x16.png"; >else if ( diff < -100 ) > imageName = "Down Trend Red Button 16x16.png"; >else > imageName = "Neutral Trend Orange Button 16x16.png";]]></method> > <property name="source">embed</property> > <property name="imageName">Neutral Trend Orange Button 16x16.png</property> > </image> > </cell> > </row> > </header> > </group> > <group id="32"> > <property name="groupName">State</property> > <property name="interval">none</property> > <property name="sortDirection">asc</property> > <expression name="keyExpr">row["STATE"]</expression> > <structure name="toc"> > <expression name="expressionValue">row["STATE"]</expression> > </structure> > <property name="repeatHeader">true</property> > <property name="hideDetail">false</property> > <property name="pageBreakAfter">auto</property> > <property name="pageBreakBefore">auto</property> > <property name="pageBreakInside">auto</property> > <header> > <row id="33"> > <property name="backgroundColor">#F4F9FF</property> > <list-property name="visibility"> > <structure> > <property name="format">all</property> > <expression name="valueExpr">row["STATE"] == null</expression> > </structure> > </list-property> > <cell id="34"/> > <cell id="35"> > <property name="colSpan">2</property> > <property name="rowSpan">1</property> > <data id="151"> > <property name="resultSetColumn">STATE</property> > </data> > </cell> > <cell id="37"> > <data id="197"> > <property name="style">total</property> > <property name="resultSetColumn">Prior_Year_Sales_State</property> > </data> > </cell> > <cell id="38"> > <data id="198"> > <property name="style">total</property> > <property name="resultSetColumn">Current_Year_Sales_State</property> > </data> > </cell> > <cell id="81"> > <data id="200"> > <property name="style">total</property> > <property name="resultSetColumn">Sales_Change_State</property> > </data> > </cell> > <cell id="89"> > <property name="paddingTop">1pt</property> > <property name="paddingLeft">2em</property> > <image name="State Indicator" id="203"> > <method name="onRender"><![CDATA[diff = row["CurrentYearSalesForState"] - row["PriorYearSalesForState"]; >if ( diff > 100 ) > imageName = "Up Trend Green Button 16x16.png"; >else if ( diff < -100 ) > imageName = "Down Trend Red Button 16x16.png"; >else > imageName = "Neutral Trend Orange Button 16x16.png";]]></method> > <property name="source">embed</property> > <property name="imageName">Neutral Trend Orange Button 16x16.png</property> > </image> > </cell> > </row> > </header> > </group> > <group id="133"> > <property name="groupName">Customer</property> > <property name="interval">none</property> > <property name="sortDirection">asc</property> > <expression name="keyExpr">row["CUSTOMERNAME"]</expression> > <property name="repeatHeader">true</property> > <property name="hideDetail">false</property> > <property name="pageBreakAfter">auto</property> > <property name="pageBreakBefore">auto</property> > <property name="pageBreakInside">auto</property> > <footer> > <row id="142"> > <cell id="143"/> > <cell id="144"/> > <cell id="145"> > <data id="152"> > <property name="resultSetColumn">CUSTOMERNAME</property> > </data> > </cell> > <cell id="146"> > <data id="176"> > <property name="style">total</property> > <property name="resultSetColumn">Prior_Year_Sales_Cust</property> > </data> > </cell> > <cell id="147"> > <data id="177"> > <property name="style">total</property> > <property name="resultSetColumn">Current_Year_Sales_Cust</property> > </data> > </cell> > <cell id="148"> > <data id="178"> > <property name="style">total</property> > <property name="resultSetColumn">Sales_Change_Cust</property> > </data> > </cell> > <cell id="149"> > <property name="paddingTop">1pt</property> > <property name="paddingLeft">2em</property> > <image name="Customer Indicator" id="202"> > <method name="onRender"><![CDATA[diff = row["CurrentYearSalesForCustomer"] - row["PriorYearSalesForCustomer"]; >if ( diff > 100 ) > imageName = "Up Trend Green Button 16x16.png"; >else if ( diff < -100 ) > imageName = "Down Trend Red Button 16x16.png"; >else > imageName = "Neutral Trend Orange Button 16x16.png";]]></method> > <property name="source">embed</property> > <property name="imageName">Up Trend Green Button 16x16.png</property> > </image> > </cell> > </row> > </footer> > </group> > <footer> > <row id="17"> > <property name="backgroundColor">#E0ECFF</property> > <cell id="18"> > <property name="colSpan">3</property> > <property name="rowSpan">1</property> > <label id="184"> > <property name="fontWeight">bold</property> > <text-property name="text">Grand Total:</text-property> > </label> > </cell> > <cell id="26"> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">double</property> > <property name="borderTopWidth">medium</property> > <data id="185"> > <property name="style">major-total</property> > <property name="resultSetColumn">Prior_Year_Total</property> > </data> > </cell> > <cell id="30"> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">double</property> > <property name="borderTopWidth">medium</property> > <data id="186"> > <property name="style">major-total</property> > <property name="resultSetColumn">Current_Year_Total</property> > </data> > </cell> > <cell id="85"> > <property name="borderTopColor">#000000</property> > <property name="borderTopStyle">double</property> > <property name="borderTopWidth">medium</property> > <data id="187"> > <property name="style">major-total</property> > <property name="resultSetColumn">Sales_Change_Total</property> > </data> > </cell> > <cell id="93"> > <property name="paddingTop">1pt</property> > <property name="paddingLeft">2em</property> > <image name="Total Indicator" id="205"> > <method name="onRender"><![CDATA[diff = row["CurrentYearSalesTotal"] - row["PriorYearSalesTotal"]; >if ( diff > 100 ) > imageName = "Up Trend Green Button 16x16.png"; >else if ( diff < -100 ) > imageName = "Down Trend Red Button 16x16.png"; >else > imageName = "Neutral Trend Orange Button 16x16.png";]]></method> > <property name="source">embed</property> > <property name="imageName">Up Trend Green Button 16x16.png</property> > </image> > </cell> > </row> > </footer> > </table> > </body> > <list-property name="images"> > <structure> > <property name="name">Down Trend Red Button 16x16.png</property> > <property name="data"> > iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAALHRFWHRDcmVhdGlvbiBUaW1lAEZyaSAx > NCBNYXIgMjAwOCAxNzozMjoxOCAtMDgwMAb3YgQAAAAHdElNRQfYAw8AIhyeyUQLAAAACXBIWXMAAA7D > AAAOwwHHb6hkAAAABGdBTUEAALGPC/xhBQAAAM9QTFRFxsbG99bW1oyEzlJCxjkxzlpK3pSM997e/+/v > 1oR7xjEhzikY3jEYxjkp3pyUzmNa7zEh5zkh54yE55SM5zkp5zEY1oRz7zkp76Wc////762l56Wc762t > 9+fn3qWl797W1ikY1nNrzko551pS54R7//f3987G78a951pK53Nr74Rz987O94yE95yU75yU74R71ntz > 94x795SM/5SM96Wc76Wl/5yU/6Wc97Wt77Wt75SM57W1/62l972155yU/7Wt98a9572199bO562l57Wt > zQDthAAAAAF0Uk5TAEDm2GYAAADWSURBVHjaNY/rcoJADIUj4qqwAgUsBKstlUtVtIqIbAWl1vd/pmZt > /SaTyTlJfhwAYnBjjBnf8OCmiIQQSvqnjUnbttcrtfOP1LOzqC5NjO2lEozepqFf1HWD2NR14W9jMOy8 > LI8VojiW66/oBGG0y/J9gXjY59kuUsBcLFdJtkbcZOnqc7GF93kUY+IgOimi/WFCl7sB4uu9AvcthKFu > eeRIAm+sz6Cj8X/nxbO4OgU6IceXe4trE5nMJOfJdtwx157vWQZDTeeEPjIecTtKV1V7rC/nX59RGlaN > V9muAAAAAElFTkSuQmCC > </property> > </structure> > <structure> > <property name="name">Neutral Trend Orange Button 16x16.png</property> > <property name="data"> > iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAAB3RJTUUH2AMPAQMC6ZsGvAAAAAlwSFlz > AAAOdAAADnQBaySz1gAAAARnQU1BAACxjwv8YQUAAAClUExURcbGxv/35/fGjO+lUu+UOe+tY//Opfe9 > hOd7COd7AO97APeEAPd7AOdzAOeEIf/Wrf+ECP+MEPe1c/+UIf+cKf+UGP+MCP/Wtf/nzv+cMeeMIf+c > Of+lQv+lSv+tUu+ta++ECP/37/+9e/ecQv+1Y//v3v/////GjPecOf+9c//Wpf/etf/GhPetY//OlP/O > nP/GlP/evfetWv+lUve1a//nxve1Y3wljs8AAAABdFJOUwBA5thmAAAAvElEQVR42jXPbQOBMBQF4EtU > trJqU8JQxlTavKT//9NcyvPp3vPpHAD0Ttq+670zDCZd0jwQ66bD/zQsa1DGtPcNWm1r9lPbygI8ntpY > t0auNfpVQFvdtDHGWmPuulQWrqqqm9GtUgnwvTpfRlpJCcdcrotRKfkJljTOd3KP5E7E5ABzknKRb1Eu > VlHIYO3TGBMkeEo2WCwJMeGC81VK/exb1QlpFKMo8Icx4PkLQgMSLhn8906d2Wzu/u4P3K4XsC3h5pkA > AAAASUVORK5CYII= > </property> > </structure> > <structure> > <property name="name">Up Trend Green Button 16x16.png</property> > <property name="data"> > iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAAB3RJTUUH2AMPADYCSmiuPQAAAAlwSFlz > AAAOdAAADnQBaySz1gAAAARnQU1BAACxjwv8YQUAAACWUExURcbGxtb33pTWnFq9a0q1UmO9a5zWpef3 > 54zOlDmtSjm1SkK9UkKtUnPGe0q9WkrGWozWlITOjFrGY2POc/f/92PGc6XerVrOa3POe////+/372vO > c3POhFLGY4TWjIzWnHPGhN733s7v1pzepd7352vGc3vWjHvOhJTenMbvxsbvzs7vzq3eta3ntbXnvb3n > xoTWlL3nvQTLBgwAAAABdFJOUwBA5thmAAAAzElEQVR42jWP4XaCMAxG0+qQUgeVQkawwGidSsGyvf/L > reh2f+V+5yQnH0CkXbgaklDBH8spzNbO4fvn5Rwn79no/eRwc3RhXRnRuK6BB4CLeYRgKcLCA28tJBxx > picWnVqgUfeJqCU6EPm7UlBfXdxHIox38HqD/NyPdoihG+ylr79gJztt+oFI9UZ32SekWVHqs6nI6LqT > AoEJWXzopqKmLgt5bAHSmJS6qjYXz1ffhcwLxXMpxelVJhWZlDITx+S/LuO7/f4tOWzzL0f8E+RbH9Yc > AAAAAElFTkSuQmCC > </property> > </structure> > </list-property> ></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 225695
: 94811