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
Hi,

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.

    https://forums.oracle.com/forums/thread.jspa?threadID=2536796&tstart=275

    Thanks
    Lakshmi
  • 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.

    step1
    -- 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",
    "EMPNO",
    "ENAME",
    "JOB",
    "MGR",
    "HIREDATE",
    "SAL",
    "COMM",
    "DEPTNO"
    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 
    
    <script>
    function func(id)
    {
    alert(id);
    }
    </script>
    Hope this will give you some idea.

    Regards,
    Jitendra

Legend

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