3 Replies Latest reply: Jul 9, 2012 3:05 PM by VC RSS

    Interactive Report select all rows

      I have a I/R report that a user can select columns, then update > 1 row a time with other page item values.
      I have SELECT ALL and CLEAR ALL page buttons.
      The report runs slow due to a very complicated sql statement.

      I am trying to select or clear column 1 without "submitting" the page, and rerunning the "slow" report again.
      Right now, the SELECT ALL:
      1) submits the page 2) sets Pxx_SELECT_ALL_ROWS = 'Y' 3) reruns the report with a decode that "checks" all rows.

      Is there a way to do this WITHOUT submitting the page?

      The checkbox is column 1 of each row using:
      AS select_flag,