This discussion is archived
2 Replies Latest reply: Jun 3, 2013 5:23 AM by Jitendra RSS

Add Button Column in IR

688723 Newbie
Currently Being Moderated

I have created an Interactive report on a table. I want to add two buttons in each row: Accept and Reject, so that i can change the status(db column) of the corresponding record on button action.
How can I do so?
  • 1. Re: Add Button Column in IR
    vdsadhi Journeyer
    Currently Being Moderated
    Check the below link, It may be useful to you.

  • 2. Re: Add Button Column in IR
    Jitendra Pro
    Currently Being Moderated
    Hi poojaC,

    Try the below code,
    i am giving the idea to add buttons..may be this is not the way you want.

    -- put this code in report region
    select "ROWID", 
     '<input type="button" value="Accept"  onclick="func('||EMPNO||')">'  as "Accept",
     '<input type="button" value="Reject"  onclick="func('||EMPNO||')">'  as "Reject",
    from "#OWNER#"."EMP" 
    -- edit the Accept and reject column and change Display type to "standard report column"
    Step 2 : create one function in page header like
    -- here you can execute your process on button action 
    function func(id)
    Hope this will give you some idea.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points