Hi All,
I recently approached to ApEx 4.2 under my Institution, please be patient!
I developed a short application for Quality Control issues, I have some problems about retrieving a summary table.
I created a Report-Form for a Customer Satisfaction section: the Form present 13 questions and users can answer using "1-5" numerical values.
Please find attached a screenshot of the Report table where you can see the answers for each user.
In the same Report page, I would like to create another table (below the present) with 5 fixed rows (corresponding to the "1-5" choices) and 13 columns (corresponding to the 13 questions, R14 and R15 are optional). The new table should display the frequency value ( e.g. COUNT(R1) ) for each answer per year.
Just for example, I created a LOOP to retrieve the results for 1st column:
declare
v_c number(2);
begin
for i in 1..5 LOOP
select COUNT(R1) into v_c
from QC_CS_RISPOSTE
where R1 = i
AND ANNO = 2014;
DBMS_OUTPUT.PUT_LINE(v_c);
END LOOP;
end;
/
Results:
2 3 1 1 1 Statement processed.
0.01 seconds
I apologize for my inexperience, hope you understand.
Thank you, best regards
K