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 10pt html 701 Gateway Boulevard,
San Francisco, CA 94107

]]>
0.25in #FFFFFF top middle
100% 0.1in BackgroundBlueGray BackgroundBlueGray 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 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 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 row["productLine"] <undefined> Orthogonal_Value , Outside false false 2 Text Sum ]]> 100% 0.25in 0.1in BackgroundBlueGray BackgroundBlueGray 0.25in 100%Sales by Product row["TotalRevenue"] desc 2.541in 3.354in
BackgroundLightYellow BackgroundLightYellow BackgroundLightYellow
BackgroundLightGray BackgroundLightGray TableBodyText row["productName"] BackgroundLightGray TableBodyText Currency $#,##0.00 row["TotalRevenue"]