Dynamic selection of columns to be displayed report10g [message #335145] |
Mon, 21 July 2008 03:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
aditiC
Messages: 38 Registered: February 2006 Location: INDIA
|
Member |
|
|
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,
Aditi
|
|
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|