| Dynamic selection of columns to be displayed report10g [message #335145] |
Mon, 21 July 2008 03:53  |
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  |
 |
Littlefoot
Messages: 21823
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'); |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
