Hi,
My interactive report is built based on the following query
SELECT ID_OPERACION, NOMBRE_CLIENTE, TOTAL_PAGAR, APEX_ITEM.CHECKBOX(1,O.ID_OPERACION, 'onclick="f_UpdateCollection(this)"',a.c001) "Seleccionar"
FROM OPERACIONES O, apex_collections a
WHERE a.c001 (+)= O.ID_OPERACION
and a.collection_name (+)= 'OPE_COLLECTION'
I'm using a collection because I don't want to lose the selected checks caused by the pagination.
I'm want to add a dynamic action that each time that a checkbox is selected, an item (P5_TOTAL_SELECCIONADO) sums the column TOTAL_PAGAR of all the selected check boxes, and that each time that a checkbox is deselected the item Total_seleccionado substracts the selected value.
How can i do that?