Eclipse BIRT Designer Version 2.2.1.r22a_v20071101 Build <2.2.1.v20071101-1439> in (C) Copyright Blackboard Inc. 1998-2008 - All Rights Reserved Permission to use, copy, modify, and distribute this software without prior explicit written approval is strictly prohibited. Please refer to the file "copyright.html" for further important copyright and licensing information. BLACKBOARD MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY OF THE SOFTWARE, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. BLACKBOARD SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING OR DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES. Creates a blank report with no predefined content. Blank Report /templates/blank_report.gif false dynamic string multi-value false list-box status dataSetRow["STATUS"] "disp" + dataSetRow["STATUS"] true true true Unformatted org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels CUSTOMERNUMBER CUSTOMERNUMBER CUSTOMERNAME CUSTOMERNAME CONTACTLASTNAME CONTACTLASTNAME CONTACTFIRSTNAME CONTACTFIRSTNAME PHONE PHONE ADDRESSLINE1 ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINE2 CITY CITY STATE STATE POSTALCODE POSTALCODE COUNTRY COUNTRY SALESREPEMPLOYEENUMBER SALESREPEMPLOYEENUMBER CREDITLIMIT CREDITLIMIT 1 CUSTOMERNUMBER integer 2 CUSTOMERNAME string 3 CONTACTLASTNAME string 4 CONTACTFIRSTNAME string 5 PHONE string 6 ADDRESSLINE1 string 7 ADDRESSLINE2 string 8 CITY string 9 STATE string 10 POSTALCODE string 11 COUNTRY string 12 SALESREPEMPLOYEENUMBER integer 13 CREDITLIMIT float Data Source 1 CUSTOMERNUMBER CUSTOMERNUMBER integer 4 2 CUSTOMERNAME CUSTOMERNAME string 12 3 CONTACTLASTNAME CONTACTLASTNAME string 12 4 CONTACTFIRSTNAME CONTACTFIRSTNAME string 12 5 PHONE PHONE string 12 6 ADDRESSLINE1 ADDRESSLINE1 string 12 7 ADDRESSLINE2 ADDRESSLINE2 string 12 8 CITY CITY string 12 9 STATE STATE string 12 10 POSTALCODE POSTALCODE string 12 11 COUNTRY COUNTRY string 12 12 SALESREPEMPLOYEENUMBER SALESREPEMPLOYEENUMBER integer 4 13 CREDITLIMIT CREDITLIMIT float 8 select * from customers 1.0 CUSTOMERNUMBER 1 4 10 0 Nullable CUSTOMERNUMBER CUSTOMERNUMBER 11 CUSTOMERNAME 2 12 50 0 Nullable CUSTOMERNAME CUSTOMERNAME 50 CONTACTLASTNAME 3 12 50 0 Nullable CONTACTLASTNAME CONTACTLASTNAME 50 CONTACTFIRSTNAME 4 12 50 0 Nullable CONTACTFIRSTNAME CONTACTFIRSTNAME 50 PHONE 5 12 50 0 Nullable PHONE PHONE 50 ADDRESSLINE1 6 12 50 0 Nullable ADDRESSLINE1 ADDRESSLINE1 50 ADDRESSLINE2 7 12 50 0 Nullable ADDRESSLINE2 ADDRESSLINE2 50 CITY 8 12 50 0 Nullable CITY CITY 50 STATE 9 12 50 0 Nullable STATE STATE 50 POSTALCODE 10 12 15 0 Nullable POSTALCODE POSTALCODE 15 COUNTRY 11 12 50 0 Nullable COUNTRY COUNTRY 50 SALESREPEMPLOYEENUMBER 12 4 10 0 Nullable SALESREPEMPLOYEENUMBER SALESREPEMPLOYEENUMBER 11 CREDITLIMIT 13 8 15 0 Nullable CREDITLIMIT CREDITLIMIT 22 ]]> ORDERNUMBER ORDERNUMBER ORDERDATE ORDERDATE REQUIREDDATE REQUIREDDATE SHIPPEDDATE SHIPPEDDATE STATUS STATUS COMMENTS COMMENTS CUSTOMERNUMBER CUSTOMERNUMBER 1 ORDERNUMBER integer 2 ORDERDATE date 3 REQUIREDDATE date 4 SHIPPEDDATE date 5 STATUS string 6 COMMENTS string 7 CUSTOMERNUMBER integer 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 select * from orders STATUS STATUS 1 STATUS string Data Source 1 STATUS STATUS string 12 select distinct status from orders 1.0 STATUS 1 12 15 0 Nullable STATUS STATUS 15 ]]> landscape html new Date()]]> blackboard.platform.reporting.service.birt.handler.VariableColumnEventHandler DynColumn expression true 2 DynParameter expression true pStatus 100%orders ORDERNUMBER dataSetRow["ORDERNUMBER"] integer ORDERDATE dataSetRow["ORDERDATE"] date REQUIREDDATE dataSetRow["REQUIREDDATE"] date SHIPPEDDATE dataSetRow["SHIPPEDDATE"] date STATUS dataSetRow["STATUS"] string COMMENTS dataSetRow["COMMENTS"] string CUSTOMERNUMBER dataSetRow["CUSTOMERNUMBER"] integer TotalOrders any COUNT dataSetRow["STATUS"] == '%VALUE%' CustomerLevel any grpTop COUNT dataSetRow["STATUS"] == '%VALUE%' StatusCounts any grpStatus COUNT dataSetRow["STATUS"] == '%VALUE%' percentBase row["TotalOrders%COL%"]/row["TotalOrders"] any center

#000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin DynSpan boolean true #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin DynNoCopy boolean true 100% left file "blackboard.common/resources/image/clp_course_section_ti.gif" left %LABEL% #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Static Before Header #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin %COL% #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Static After Header #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Static Before #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin TotalOrders Percent Percent percentBase #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Static After

grpStatus none asc row["STATUS"] row["STATUS"] true false auto auto auto

STATUS StatusCounts

grpTop none asc row["CUSTOMERNUMBER"] row["CUSTOMERNUMBER"] true false auto auto auto