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