Home » Developer & Programmer » Reports & Discoverer » Dynamic selection of columns to be displayed report10g
Dynamic selection of columns to be displayed report10g [message #335145] Mon, 21 July 2008 03:53 Go to next message
Messages: 38
Registered: February 2006
Location: INDIA
Hi All,

I need to display in a report only the columns which are selected in a form prior to calling the report. for eg

suppose a report has 5 columns but
the user has selected to display 3 column in a report,then the report must display only the 3 cols.the report layout must be adjusted dynamically based on the no. of cols selection.
by default all the 5 cols will be printed.

Kindly suggest something.

Many Thanks,
Re: Dynamic selection of columns to be displayed report10g [message #335157 is a reply to message #335145] Mon, 21 July 2008 04:42 Go to previous message
Messages: 21128
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, report needs to know which columns are to be displayed. One way to do that is to transfer this information via parameter(s).

Each of report's fields has to have its own Format trigger which will look like this:
return (:par_display_field_1 = 'Y');
As it returns Boolean, field will be displayed (or not) depending on parameter value.
Previous Topic: Page settings for cutsheet papers
Next Topic: improve the discovere standard view performance
Goto Forum:

Current Time: Mon Jul 24 14:06:03 CDT 2017

Total time taken to generate the page: 0.05986 seconds