Hi,
I need to access to the saved report results but i can not found them in the database,
Iin the table T_AV_REPORT_RESULTS, i found juste the style in JRXML but the PRINT_OBJ is empty.
I need to access to report results, because i want to create a chart that represent the evolution of orphan accounts in the time, i can not use orphaned_date cause when we will link an account we will lose this value.
Best Regards.
The whole result is stored in the column RR_NT of the table T_AV_REPORT_RESULTS. This column is a nested table with each row storing value of one column of report result row.. So... if report result has 5 rows with 10 columns to display, this nested table will have 50 rows of data stored.
The results from following query(Replace result_name with name of report result) should give an idea of how the data is stored
select results.* from T_AV_REPORT_RESULTS rr, table(rr.RR_NT) results where rr.description = 'result_name'
Thank you for your help
The whole result is stored in the column RR_NT of the table T_AV_REPORT_RESULTS. This column is a nested table with each row storing value of one column of report result row.. So... if report result has 5 rows with 10 columns to display, this nested table will have 50 rows of data stored.
The results from following query(Replace result_name with name of report result) should give an idea of how the data is stored
select results.* from T_AV_REPORT_RESULTS rr, table(rr.RR_NT) results where rr.description = 'result_name'