Select the rows from table/datagrid and count the value from selected row

User Experience
, , , , , , , ,
1

Hi,

I have a grid that has a report definition as a data source. And in every row, it has a checkbox to select/deselect the rows (for now I’m using the .pySelected). Then, if the checkbox is selected, we will get the PI value and if the user clicks the Count PI button below the table, it will calculate all the PI ONLY from the selected rows. How can I accomplish this approach? How do we know the row is selected and we can get the PI value from that row?

I attach the screenshot below

grid.jpg
grid.jpg1280×613 51 KB

Please note that this table will be in the CaseInformation section

Thank you

2

Hi @AyuAnindita,

If you just need the count of selected rows from the table you can run a Data transform on click of countpi button and use following function @Utilities.countInPageList(“true”,pySelected,ReportResults).

If you want to sum the PI of selected rows, I would recommend you to use declare expression.

Thanks,

Vinay

3

@AyuAnindita Hi You can achieve this by two ways

  1. create a data page which is editable and give Report Definition as the source use the data page as a source for grid. Use pyselected property as a property for checkbox. On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList(“true”,pySelected,D_DataPage.pxResults)

  2. Have the same implementation as you have and On click of button run data transform to calculate the final PI. In DT use @Utilities.countInPageList(“true”,pySelected, ReportPage.pxResults). Please check the clipboard for the exact report definition page.