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

SebaVasta

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

Suresh-Sangaran-Oracle

Hello,

If your Formula Column is part of your Layout design, it can be directly used to generate a CSV.

For complex Formula columns, you can use a PlaceHolder column which can hold the data during runtime as well display results in the layout/output files(csv).

Ref: https://docs.oracle.com/middleware/12213/formsandreports/use-reports/pbr_trouble001.htm#RSPUB03019

2.3.3 About placeholder columns

https://docs.oracle.com/middleware/12213/formsandreports/build-reports/orbr_concepts2003.htm#RSBDR311

4.8.12 Creating or editing a placeholder column

https://docs.oracle.com/middleware/12213/formsandreports/build-reports/orbr_howto008.htm#RSBDR857

Add Ref:https://community.oracle.com/tech/developers/discussion/4181054/placeholder-columns-pl-sql-formula

Thanks, Suresh