Home » Developer & Programmer » Reports & Discoverer » How to use Formula column in Oracle Reports
How to use Formula column in Oracle Reports [message #269188] Fri, 21 September 2007 00:56 Go to next message
Messages: 1
Registered: August 2007
Location: Bangalore
Junior Member
Hi all
There is a column which i want to be displayed in a report but cannot select the column in the main query. Someone suggested I can use Formula column for that purpose but I have no idea how to use it.PLEASE HELP.
Re: How to use Formula column in Oracle Reports [message #269203 is a reply to message #269188] Fri, 21 September 2007 02:41 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create it in the Data Model editor using the Formula Column button (can be found in the Tool Palette).

Name it as you wish, choose its datatype and width. Press "PL/SQL Formula" property button and write PL/SQL code which would return desired value.

Create a field in the Paper Layout editor and make it source to be previously defined formula column.

By the way, all this (and much more) can be found in Report Builder's Online Help System. Why didn't you search for it?
Previous Topic: add fields at different frequencies
Next Topic: Matrix Report
Goto Forum:

Current Time: Sat Aug 19 23:16:59 CDT 2017

Total time taken to generate the page: 0.32856 seconds