Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to convert a report to CSV output when some column are Report formula columns?

SebaVastaAug 31 2021 — edited Aug 31 2021

We have a tabular report which works fine.
Now the users want the same report but as a comma delimited CSV file.
Problem is, 1/2 of the columns in the group are formula columns which have PL/SQL.
Is there way to reuse the code in the formula columns instead of writing DB functions and calling them in the report SQL?
Because problem is we cannot do this with Oracle Reports formula columns:
SELECT table_col1 || ',' || table_col2 || ',' || CF_report_formula_col1 || ',' || table_col3
FROM table1, 2, 3
WHERE

Comments

Post Details

Added on Aug 31 2021
1 comment
640 views