Eclipse BIRT Designer Version 2.2.1.r221_v20070924 Build <2.2.0.v20070924-1550> in Copyright (c) 2006 <<Your Company Name here>> Creates a blank report with no predefined content. Customer Cube.Data Set.x integer false Customer Cube.Data Set.y integer false 235 105 Blank Report /templates/blank_report.gif org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels 1 ORDERNUMBER integer 2 ORDERDATE date 3 REQUIREDDATE date 4 SHIPPEDDATE date 5 STATUS string 6 COMMENTS string 7 CUSTOMERNUMBER integer 8 CUSTOMERNUMBER_8 integer 9 CUSTOMERNAME string 10 CONTACTLASTNAME string 11 CONTACTFIRSTNAME string 12 PHONE string 13 ADDRESSLINE1 string 14 ADDRESSLINE2 string 15 CITY string 16 STATE string 17 POSTALCODE string 18 COUNTRY string 19 SALESREPEMPLOYEENUMBER integer 20 CREDITLIMIT float 21 ORDERNUMBER_21 integer 22 PRODUCTCODE string 23 QUANTITYORDERED integer 24 PRICEEACH float 25 ORDERLINENUMBER integer 26 PRODUCTCODE_26 string 27 PRODUCTNAME string 28 PRODUCTLINE string 29 PRODUCTSCALE string 30 PRODUCTVENDOR string 31 PRODUCTDESCRIPTION string 32 QUANTITYINSTOCK integer 33 BUYPRICE float 34 MSRP float Data Source 1 ORDERNUMBER ORDERNUMBER integer 4 2 ORDERDATE ORDERDATE date 91 3 REQUIREDDATE REQUIREDDATE date 91 4 SHIPPEDDATE SHIPPEDDATE date 91 5 STATUS STATUS string 12 6 COMMENTS COMMENTS string 12 7 CUSTOMERNUMBER CUSTOMERNUMBER integer 4 8 CUSTOMERNUMBER_8 CUSTOMERNUMBER integer 4 9 CUSTOMERNAME CUSTOMERNAME string 12 10 CONTACTLASTNAME CONTACTLASTNAME string 12 11 CONTACTFIRSTNAME CONTACTFIRSTNAME string 12 12 PHONE PHONE string 12 13 ADDRESSLINE1 ADDRESSLINE1 string 12 14 ADDRESSLINE2 ADDRESSLINE2 string 12 15 CITY CITY string 12 16 STATE STATE string 12 17 POSTALCODE POSTALCODE string 12 18 COUNTRY COUNTRY string 12 19 SALESREPEMPLOYEENUMBER SALESREPEMPLOYEENUMBER integer 4 20 CREDITLIMIT CREDITLIMIT float 8 21 ORDERNUMBER_21 ORDERNUMBER integer 4 22 PRODUCTCODE PRODUCTCODE string 12 23 QUANTITYORDERED QUANTITYORDERED integer 4 24 PRICEEACH PRICEEACH float 8 25 ORDERLINENUMBER ORDERLINENUMBER integer 5 26 PRODUCTCODE_26 PRODUCTCODE string 12 27 PRODUCTNAME PRODUCTNAME string 12 28 PRODUCTLINE PRODUCTLINE string 12 29 PRODUCTSCALE PRODUCTSCALE string 12 30 PRODUCTVENDOR PRODUCTVENDOR string 12 31 PRODUCTDESCRIPTION PRODUCTDESCRIPTION string 12 32 QUANTITYINSTOCK QUANTITYINSTOCK integer 4 33 BUYPRICE BUYPRICE float 8 34 MSRP MSRP float 8 select * from CLASSICMODELS.ORDERS, CLASSICMODELS.CUSTOMERS, CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS where CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS.ORDERNUMBER and CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCTS.PRODUCTCODE and CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS.CUSTOMERNUMBER and CLASSICMODELS.ORDERS.STATUS = 'Shipped' Summary Field1 NewTabularHierarchy2 string PRODUCTLINE DataForCube true NewTabularHierarchy3 date-time year SHIPPEDDATE date-time quarter SHIPPEDDATE date-time month SHIPPEDDATE date-time week-of-month SHIPPEDDATE date-time week-of-year SHIPPEDDATE date-time day-of-week SHIPPEDDATE date-time day-of-month SHIPPEDDATE date-time day-of-year SHIPPEDDATE date-time hour SHIPPEDDATE date-time minute SHIPPEDDATE date-time second SHIPPEDDATE DataForCube sum dataSetRow["QUANTITYORDERED"]*dataSetRow["PRICEEACH"] float DataForCube html new Date()]]> revenue Currency $#,##0 right revenue eq rwch = reportContext.getPersistentGlobalVariable("rwc"); rwch%2; 0 #E1FABC Group3/year Group2/PRODUCTLINE #FFFFFF Currency $#,##0 right revenue_Group3/year_Group2/PRODUCTLINE Group2/PRODUCTLINE #E1FABC Currency $#,##0 right revenue_Group2/PRODUCTLINE Group3/year #E1FABC Currency $#,##0 right revenue_Group3/year Group3/quarter #E1FABC Currency $#,##0 right revenue_Group3/quarter all true dummy #E1FABC bold #000000 solid 1px #000000 solid 1px #000000 solid 1px #000000 solid 1px Currency $#,##0 right revenue_1 #808000 #808000 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px Grand Total Group3 Group3/year #808000 "Microsoft Sans Serif" 10pt bold #FFFFFF Year/QTR #808000 10pt bold #FFFFFF year solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 #808000 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px center Total Group3/quarter #808000 "Microsoft Sans Serif" 10pt bold #FFFFFF #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px center quarter #808000 "MS Sans Serif" 10pt bold #FFFFFF Grand Total #808000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 Group2 Group2/PRODUCTLINE #808000 sans-serif 10pt bold #FFFFFF PRODUCTLINE #808000 solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 false solid 2px #000000 solid 2px #000000 solid 2px #000000 solid 2px #000000 salesbydate PRODUCTLINE dimension["Group2"]["PRODUCTLINE"] any year dimension["Group3"]["year"] any revenue measure["revenue"] any quarter dimension["Group3"]["quarter"] any revenue_Group3/year_Group2/PRODUCTLINE measure["revenue"] Group3/year Group2/PRODUCTLINE sum revenue_Group2/PRODUCTLINE measure["revenue"] Group2/PRODUCTLINE sum revenue_Group3/year measure["revenue"] Group3/year sum revenue_Group3/quarter measure["revenue"] any Group3/quarter sum revenue_1 measure["revenue"] sum dummy importPackage( Packages.java.lang ); rwctmp = reportContext.getPersistentGlobalVariable("rwc").intValue(); rwctmp = rwctmp + 1; rwci = new Integer( rwctmp ); reportContext.setPersistentGlobalVariable("rwc", rwci); rwctmp any