5 Replies Latest reply: Dec 4, 2012 11:48 PM by Mindmap RSS

    tabular form

    974898
      Hi all,

      Edited by: anees_mohd on Dec 11, 2012 7:39 AM
        • 1. Re: tabular form
          Gus C
          I think from your description, you should be looking at a master/detail form

          Gus
          • 2. Re: tabular form
            974898
            *

            Edited by: anees_mohd on Dec 11, 2012 7:40 AM
            • 3. Re: tabular form
              Mindmap
              Salam Anees,

              You want to have a Report Region for employees. Whenever, you click on the employee_id, you want to see some details relate to that employee in another Report Region. Is that what you want ?? If yes, give me a few days, I am going to prepare an example for it .... Unless someone on the Forum answers your question soon.

              Best Regards,
              Fateh
              • 4. Re: tabular form
                974898
                *

                Edited by: anees_mohd on Dec 11, 2012 7:40 AM
                • 5. Re: tabular form
                  Mindmap
                  Salam Akhee,

                  If you create an example on apex.oracle.com, it will be easier. However, I am going to answer based on what I got:

                  You Create a DA (Dynamic Action):
                  Event: change value of your select list item
                  Action: refresh your Report Region.

                  In your report region. in Page Items to Submit, Add the names of your select value items.
                  e.g: P1_SELECT_VALUE2,P1_SELECT_VALUE1

                  And as you know the report source should be something similar to this:
                  Select ...., vendor_id , my_date ,.... from My_table 
                  where
                  vendor_id = :P1_SELECT_VALUE1 and my_date = :P1_SELECT_VALUE2
                  Please note that the Event of your DA could be a button click instead of refreshing the report region whenever you change the value of the select list.

                  If that does not work for you, then please create an example on apex.oracle.com.

                  Best Regards,
                  Fateh
                  ----------------------------------
                  If you believe that my answer was correct, then please mark the answer as correct.