Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-dev] BIRT API 2 aggregate functions on the same group

Hi,
I have written the following Code, wondering, why it computed two times the Sum of the the column
In allegate i put the produced report (You will find two times VarianceExp)

protected void createBody(ReportDesignHandle design) throws SemanticException {
        TableHandle table = design.getElementFactory().newTableItem("dataTable", 5, 1, 1, 1);
        table.setProperty(StyleHandle.TEXT_ALIGN_PROP, DesignChoiceConstants.TEXT_ALIGN_CENTER);
        table.setWidth("80%");
        table.setProperty(TableHandle.DATA_SET_PROP, "setScripted");

        // bind the data set columns to the table
        DataSetHandle dataSetHandle = (DataSetHandle) design.getDataSets().get(0);
        List resultSetCols = dataSetHandle.getListProperty(DataSetHandle.RESULT_SET_PROP);
        PropertyHandle boundCols = table.getColumnBindings();
        for (Iterator iterator = resultSetCols.iterator(); iterator.hasNext();) {
            ResultSetColumn rsHandle = (ResultSetColumn) iterator.next();
            ComputedColumn col = StructureFactory.createComputedColumn();
            col.setName(rsHandle.getColumnName());
            col.setExpression("dataSetRow[\"" + rsHandle.getColumnName() + "\"]");
            boundCols.addItem(col);
        }
        //Aggregate fields for footer of group       
        ComputedColumn groupVarianceExp = StructureFactory.createComputedColumn();
        groupVarianceExp.setName("VarianceExp");
        groupVarianceExp.setDisplayName("VarDisp");
        groupVarianceExp.setExpression("dataSetRow[\"Real\"]");
        groupVarianceExp.setAggregateFunction(DesignChoiceConstants.MEASURE_FUNCTION_MIN);
        groupVarianceExp.setAggregateOn("GroupPerValue");
        boundCols.addItem(groupVarianceExp);

        ComputedColumn groupMedianExp = StructureFactory.createComputedColumn();
        groupMedianExp.setName("MedianExp");
        groupMedianExp.setDisplayName("MedDisp");
        groupMedianExp.setExpression("dataSetRow[\"Real\"]");
        groupMedianExp.setAggregateFunction(DesignChoiceConstants.MEASURE_FUNCTION_SUM);
        groupMedianExp.setAggregateOn("GroupPerValue");
        boundCols.addItem(groupMedianExp);


        // Table sorter
        SortKey key = StructureFactory.createSortKey();
        key.setKey("row[\"Log-ID\"]");
        key.setDirection("asc");
        PropertyHandle sort = table.getPropertyHandle(TableHandle.SORT_PROP);
        sort.addItem(key);

        // Header
        RowHandle rowHandle = (RowHandle) table.getHeader().get(0);

        CellHandle tblCellHandle = (CellHandle) rowHandle.getCells().get(0);
        LabelHandle labelHandle = design.getElementFactory().newLabel(null);
        labelHandle.setText("Name");
        labelHandle.setStyleName("LabelStyle");
        tblCellHandle.getContent().add(labelHandle);

        tblCellHandle = (CellHandle) rowHandle.getCells().get(1);
        labelHandle = design.getElementFactory().newLabel(null);
        labelHandle.setText("Log-ID");
        labelHandle.setStyleName("LabelStyle");
        tblCellHandle.getContent().add(labelHandle);

        tblCellHandle = (CellHandle) rowHandle.getCells().get(2);
        labelHandle = design.getElementFactory().newLabel(null);
        labelHandle.setText("Expected");
        labelHandle.setStyleName("LabelStyle");
        tblCellHandle.getContent().add(labelHandle);

        tblCellHandle = (CellHandle) rowHandle.getCells().get(3);
        labelHandle = design.getElementFactory().newLabel(null);
        labelHandle.setText("Exp.at Start");
        labelHandle.setStyleName("LabelStyle");
        tblCellHandle.getContent().add(labelHandle);

        tblCellHandle = (CellHandle) rowHandle.getCells().get(4);
        labelHandle = design.getElementFactory().newLabel(null);
        labelHandle.setText("Real");
        labelHandle.setStyleName("LabelStyle");
        tblCellHandle.getContent().add(labelHandle);

        // Table Group
        TableGroupHandle group = design.getElementFactory().newTableGroup();
        group.setName("GroupPerValue");
        group.setKeyExpr("row[\"Name\"]");
        table.getGroups().add(group);

        RowHandle grpHdrHandle = design.getElementFactory().newTableRow(5);
        tblCellHandle = (CellHandle) grpHdrHandle.getCells().get(0);
        tblCellHandle.setDrop(DesignChoiceConstants.DROP_TYPE_DETAIL);
        DataItemHandle data = "">
        data.setStyleName("DataStyle");
        data.setResultSetColumn("Name");
        tblCellHandle.getContent().add(data);
        group.getHeader().add(grpHdrHandle);
       
        //Median Footer
        RowHandle groupMedFooter = design.getElementFactory().newTableRow(5);
        tblCellHandle = (CellHandle) groupMedFooter.getCells().get(0);
        tblCellHandle = (CellHandle) groupMedFooter.getCells().get(1);
        tblCellHandle.setProperty(StyleHandle.TEXT_ALIGN_PROP, DesignChoiceConstants.TEXT_ALIGN_LEFT);
        tblCellHandle.getContent().add(createLabel("Median", "Median"));
        tblCellHandle = (CellHandle) groupMedFooter.getCells().get(2);
        DataItemHandle dataHandle = design.getElementFactory().newDataItem("MedExp");
        dataHandle.setResultSetColumn("MedianExp");
        dataHandle.setDisplayName("Median");
        tblCellHandle.getContent().add(dataHandle);
       

        tblCellHandle = (CellHandle) groupMedFooter.getCells().get(3);
        tblCellHandle = (CellHandle) groupMedFooter.getCells().get(4);
        group.getFooter().add(groupMedFooter);
        //Variance Footer
        RowHandle groupVarFooter = design.getElementFactory().newTableRow(5);
        tblCellHandle = (CellHandle) groupVarFooter.getCells().get(0);
        tblCellHandle = (CellHandle) groupVarFooter.getCells().get(1);
        tblCellHandle.setProperty(StyleHandle.TEXT_ALIGN_PROP, DesignChoiceConstants.TEXT_ALIGN_LEFT);
        tblCellHandle.getContent().add(createLabel("Variance", "Variance"));
        tblCellHandle = (CellHandle) groupVarFooter.getCells().get(2);
        DataItemHandle dataVarHandle = design.getElementFactory().newDataItem("VarExp");
        dataVarHandle.setResultSetColumn("VarianceExp");
        dataVarHandle.setDisplayName("Variance");
        tblCellHandle.getContent().add(dataVarHandle);
   
        tblCellHandle = (CellHandle) groupVarFooter.getCells().get(3);
        tblCellHandle = (CellHandle) groupVarFooter.getCells().get(4);
        group.getFooter().add(groupVarFooter);

        //second footer
        RowHandle groupFooter = design.getElementFactory().newTableRow(5);
        tblCellHandle = (CellHandle) groupFooter.getCells().get(0);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_COLOR_PROP, "#FF8000");
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_STYLE_PROP, DesignChoiceConstants.LINE_STYLE_SOLID);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_WIDTH_PROP, DesignChoiceConstants.LINE_WIDTH_THIN);
        tblCellHandle = (CellHandle) groupFooter.getCells().get(1);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_COLOR_PROP, "#FF8000");
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_STYLE_PROP, DesignChoiceConstants.LINE_STYLE_SOLID);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_WIDTH_PROP, DesignChoiceConstants.LINE_WIDTH_THIN);
        tblCellHandle = (CellHandle) groupFooter.getCells().get(2);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_COLOR_PROP, "#FF8000");
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_STYLE_PROP, DesignChoiceConstants.LINE_STYLE_SOLID);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_WIDTH_PROP, DesignChoiceConstants.LINE_WIDTH_THIN);
        tblCellHandle = (CellHandle) groupFooter.getCells().get(3);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_COLOR_PROP, "#FF8000");
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_STYLE_PROP, DesignChoiceConstants.LINE_STYLE_SOLID);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_WIDTH_PROP, DesignChoiceConstants.LINE_WIDTH_THIN);
        tblCellHandle = (CellHandle) groupFooter.getCells().get(4);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_COLOR_PROP, "#FF8000");
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_STYLE_PROP, DesignChoiceConstants.LINE_STYLE_SOLID);
        tblCellHandle.setProperty(StyleHandle.BORDER_BOTTOM_WIDTH_PROP, DesignChoiceConstants.LINE_WIDTH_THIN);
        group.getFooter().add(groupFooter);

        // Add DataItems to the Detail Row
        // first column
        RowHandle detail = (RowHandle) table.getDetail().get(0);
        tblCellHandle = (CellHandle) detail.getCells().get(1);
        data = "">        data.setStyleName("DataStyle");
        data.setResultSetColumn("Log-ID");
        tblCellHandle.getContent().add(data);

        tblCellHandle = (CellHandle) detail.getCells().get(2);
        data = "">        data.setStyleName("DataStyle");
        data.setResultSetColumn("Exp");
        tblCellHandle.getContent().add(data);

        // second column
        tblCellHandle = (CellHandle) detail.getCells().get(3);
        data = "">        data.setStyleName("DataStyle");
        data.setResultSetColumn("ExpSt");
        tblCellHandle.getContent().add(data);

        // second column
        tblCellHandle = (CellHandle) detail.getCells().get(4);
        data = "">        data.setStyleName("DataStyle");
        data.setResultSetColumn("Real");
        tblCellHandle.getContent().add(data);

        design.getBody().add(table);
    }


----- Urspr√ľngliche Mail ----
Von: Xiaoying Gu <xgu@xxxxxxxxxxx>
An: birt-dev@xxxxxxxxxxx
Gesendet: Samstag, den 24. Mai 2008, 14:42:32 Uhr
Betreff: [birt-dev] New Eclipse BIRT Milestone Build Available for Download

BIRT Community,

 

 

The BIRT development team are pleased to let you know that BIRT 2.3 RC1 Build (build number: 20080522-1340) is now available for download.

Build <2.3RC1 > can be downloaded from the BIRT download page: http://download.eclipse.org/birt/downloads/build.php?build=M-R1-2.3RC1-200805221340 

 

As always, please provide your feedback through the newsgroup or by reporting bugs through Bugzilla.

 

 

Regards,

BIRT Team

 

 

 

 



Gesendet von Yahoo! Mail.
Dem pfiffigeren Posteingang.

Attachment: CompReport-2008-05-28 15h41 14s.rptdesign
Description: Binary data


Back to the top