julien.sauvevois@capgemini.com Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630> in exemple camembert exemple camembert /templates/blank_report.gif dynamic string simple Saisir le client : list-box client dataSetRow["customerNumber"] dataSetRow["customerName"] true true 242 true Unformatted org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels AMOUNT AMOUNT CUSTOMERNAME CUSTOMERNAME PAYMENTDATE PAYMENTDATE 1 AMOUNT float 2 CUSTOMERNAME string 3 PAYMENTDATE date DataSource param_1 client integer 4 1 true true true false 1 AMOUNT AMOUNT float 8 2 CUSTOMERNAME CUSTOMERNAME string 12 3 PAYMENTDATE PAYMENTDATE date 91 select p.amount,c.customerName,p.paymentDate from customers c,payments p where c.customerNumber = p.customerNumber and c.customerNumber = ? 1.0 In 1 4 10 0 Nullable true sum(p.amount) 1 8 23 31 Nullable sum(p.amount) sum(p.amount) 23 customerName 2 12 50 0 NotNullable customerName customerName 50 year(p.paymentDate) 3 -5 4 0 Nullable year(p.paymentDate) year(p.paymentDate) 4 ]]> 1 customerNumber integer 2 customerName string DataSource 1 customerNumber CUSTOMERNUMBER integer 4 2 customerName CUSTOMERNAME string 12 select c.customerNumber,c.customerName from customers c order by c.customerName 1.0 customerNumber 1 4 11 0 NotNullable customerNumber customerNumber 11 customerName 2 12 50 0 NotNullable customerName customerName 50 ]]> custom 70.56mm 141.11mm landscape 0in 0in 0in 0in 0in 0in 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 todo 16.0 true Center Center 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 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 Vertical Top_Bottom 1 255 0 0 0 true Right Categories Above 0.0 0.0 300.0 150.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true Two_Dimensional_With_Depth Points 20.0 0 'A','B','C','D','E' 6,4,12,8,10 0 true None 255 254 254 153 255 204 254 204 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 255 254 254 153 255 204 254 204 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 true row["AMOUNT"] Orthogonal_Value , Outside false true 5 Below 1 255 0 0 0 true Fixed_Length 10.0 1.0 14.0 false 1.0 Text Sum yyyy true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["PAYMENTDATE"] Orthogonal_Value , Outside false true Years 1.0 DateTime Sum ]]> JPG DataSet 200px 400px AMOUNT dataSetRow["AMOUNT"] float CUSTOMERNAME dataSetRow["CUSTOMERNAME"] string PAYMENTDATE dataSetRow["PAYMENTDATE"] date