How To Access To Hidden Columns In Interactive Report
EEGJan 29 2009 — edited Feb 8 2009Hello.
I am using Apex 3.1.2. In an Interactive Report (IR) I've set up one of the columns to be a link and having its link attribute set as:
onClick="return dropdownmenu(this, event, menu1, '200px', '#ELEMENT#', '#IOC_CAPTAR_SEARCH#', '#SLC_CAPTAR_SEARCH#','#SYMBOLS_UPLOAD_ID#')"
The report values associated with the substitution columns #ELEMENT# and #SYMBOLS_UPLOAD_ID# are passed to my javascript function correctly.
However, the other two report substitution columns #IOC_CAPTAR_SEARCH# and #SLC_CAPTAR_SEARCH# are passed as the literal strings IOC_CAPTAR_SEARCH and SLC_CAPTAR_SEARCH.
After some testing I realized that what was happening is that these two columns are "hidden" fields in the IR report. Only if I un-hide them, do the actual associated report values get passed to javascript.
However, it is a requirement that I hide these two fields.
Would anyone know how to pass report values for "hidden" fields in an IR report to a javascript function referenced in the link attribute section?
Thank you.
Elie