SUMMARY CELLS IN TABLE UI ELEMENT

[sahai]

HI ,

i want to have the sum of certain columns in table ui element i read wdr_table_test ....but still could'nt get kindly suggest

HOW TO USE THE SUMMARY CELLS IN TABLE UI ELEMENT..

THANKS AND REGARDS,

SAHAI.S

Edited by: sahai.s on Apr 8, 2011 12:27 PM

[former_member389677]

Hi SAHAI,

The implementation consists of the following steps:

1. First, all data sets to be displayed have to be stored in an internal table. This

table should contain an additional column of type string. This column will

be filled with the name of the cell variant used to display the corresponding

table line.

2. The internal table has to be sorted according to the data set groups, subtotals

should be displayed for.

3. After each data set group an additional line has to be inserted into the

internal table. This table line has to contain the sums of the numeric columns

for this group. The cells forming the grouping criterion should contain the

corresponding values. The extra table column should be filled with the name

of the cell variant used to display this table line. All other nun-numeric

cells should be initial.

4. The context of the controller has to be defined. The data node should contain

all attributes to be displayed by the table. In addition, an attribute related

to the extra table column has to be defined. At runtime, this attribute will

contain the name of the cell variant used to render the related table line.

5. The content of the internal table has to be copied to the context.

6. Next, the view's layout has to be defined. Using the wizard, a simple table

displaying the content of the context node can be defined. However, the

extra table column (containing the cell variant name) may not be displayed.

7. For each TableColumn the property selectedCellVariant has to be bound to

the context attribute containing the cell variant name.

8. For each TableColumn, a cell variant of type TableSummaryCell has to be

defined as a direct sub element. The property variantKey has to be evaluated

with the variant name for the subtotal lines (defined in step 3).

9. Finally, a table cell editor (typically a TextView UI element) has to be defined

for each cell variant defined in the previous step. The primary property has

to be bound to the context attribute related to this column.

Regards

Shaira

Edited by: Shaira Madhu on Apr 8, 2011 12:40 PM

[former_member378730]

Can you please explain how to do total and sutotal for tree table in webdypro in detail??