2 Replies Latest reply: Jun 3, 2013 7:23 AM by Jitendra RSS

    Add Button Column in IR

    688723
      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
          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
            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