Forum Stats

  • 3,758,186 Users
  • 2,251,351 Discussions
  • 7,870,100 Comments

Discussions

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

SebaVasta
SebaVasta Member Posts: 42 Red Ribbon
edited Aug 31, 2021 5:28AM in Reports

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

Answers