Hi All,
I am trying to build a dynamic matrix report (or interactive grid?) which should have the edit capability. I am new to the matrix type of reports.
I looked at some of the examples in this forums (display pivot etc.,) but couldn't figure out how to edit the report in my scenario.
Below is my table (TARGET_DATA_TBL)
The interface I trying to build should look like the below.
- I have a CUSTOMER\_ID drop down in which I selected 3.
- The Matrix/report should populate as above (with X's).
- The X refers to an existing record from the table and are non-editable.
- The rest of the cells must be editable. A drop down with only X, NULL values. Defaulted to NULL.
- If a user comes and select an X in any of the cell, a new record must be created in the TARGET\_DATA\_TBL with the respective customer\_id,category,attribute.
For example, if I select X for CATEGORY\_1 and ATTRIB\_4 and new record must be inserted into the table with values (3, CATEGORY\_1, ATTRUB\_4) when the user clicks Save. Also, the cell must become read only (Please refer to the grayed out cells with X's).
The attributes and categories have their respective lookup tables from which the X and Y axis will be populated. Can this functionality be achieved with an interactive Grid?
Please advice on how to achieve this functionality. And let me know if any further information is needed.
Versions: 18.2, 12c
Thank you all in advance,
Daniel