<Caption> <Value>valueSeries</Value> <Font> <Name>SansSerif</Name> <Size>16.0</Size> <Bold>true</Bold> <Italic>false</Italic> <Strikethrough>false</Strikethrough> <Underline>false</Underline> <Alignment> <horizontalAlignment>Left</horizontalAlignment> <verticalAlignment>Top</verticalAlignment> </Alignment> <Rotation>0.0</Rotation> </Font> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> </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>

Eclipse BIRT Designer Version 0.0.1 Build <20050405-1230> in

valid string

true com.mysql.jdbc.Driver jdbc:mysql://localhost/classicmodels root

YWN0dWF0ZQ==

Classic Models

productLine any if-realized auto Product Line

SELECT productLine, SUM( priceEach*quantityOrdered ) AS 'TotalRevenue' FROM orderdetails, products WHERE orderdetails.productCode = products.productCode GROUP BY products.productLine;

Classic Models SELECT productName, SUM( priceEach*quantityOrdered ) AS 'TotalRevenue' FROM orderdetails, products WHERE orderdetails.productCode = products.productCode GROUP BY products.productName;

100% html

new Date()]]>

right

#EAEAEA 100% 2.8in 3.125in top 1 1 #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin "http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg" middle sans-serif 18pt bold #004080

Classic Models, Inc.

sans-serif 10pt html

701 Gateway Boulevard,
San Francisco, CA 94107

]]>

sans-serif 18pt bold

Top Selling Products

0.25in #FFFFFF top middle 100% 0.1in BackgroundBlueGray BackgroundBlueGray sans-serif x-large bold

Revenue By Product Line

0.25in

3.468in 6.145in Sales By Product Line

Pie Chart Standard Pie Chart 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false =Product Line Revenue SansSerif 24.0 false false false false Left Top 0.0 255 0 0 0 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 255 255 255 255 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 <undefined> SansSerif 12.0 false false false false Left Top 0.0 255 0 0 0 Vertical Top_Bottom Right Categories 0.0 0.0 441.75 249.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 255 255 255 255 true Two_Dimensional_With_Depth Points 15.0 1 A, B, C 5,4,12 0 Base Series 255 0 128 255 255 255 128 192 255 128 255 128 255 255 255 0 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 0 128 255 255 255 128 192 255 128 255 128 255 255 255 0 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 true <undefined> SansSerif 10.0 true false false false Left Top 46.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 true row["TotalRevenue"] valueSeriesIdentifier Orthogonal_Value $ 2 , Outside false 10 <Caption> <Value>valueSeries</Value> <Font> <Name>SansSerif</Name> <Size>16.0</Size> <Bold>true</Bold> <Italic>false</Italic> <Strikethrough>false</Strikethrough> <Underline>false</Underline> <Alignment> <horizontalAlignment>Left</horizontalAlignment> <verticalAlignment>Top</verticalAlignment> </Alignment> <Rotation>0.0</Rotation> </Font> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> </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> Below 1 255 0 0 0 true Stretch_To_Side 100.0 false 2 Text Sum true <undefined> SansSerif 12.0 false false false false Left Top 0.0 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["productLine"] <undefined> Orthogonal_Value , Outside false false 2 Text Sum ]]>

100% 0.25in 0.1in BackgroundBlueGray BackgroundBlueGray sans-serif x-large bold

Products in Revenue Generating Order

0.25in 100%Sales by Product

row["TotalRevenue"] desc

2.541in 3.354in

BackgroundLightYellow BackgroundLightYellow TableHeaderText

Product Name

BackgroundLightYellow TableHeaderText

Total Revenue

BackgroundLightGray BackgroundLightGray TableBodyText row["productName"] BackgroundLightGray TableBodyText Currency $#,##0.00 row["TotalRevenue"]