In 4.2, there's an option in the Link Column section of an IR to make it conditional, but it's not in the 4.2 docs. Even the screenshot in the 2-day manual (http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35122/build_app.htm#BCEJICGI) doesn't show it.
I'd like to make it conditional on the result of each value of a particular column of the IR report. For example, if the IR contains a column called USERNAME, how do I reference that column in the link column conditions like "Value of Item / Column in expression 1 is not null"?
Conditions on report columns apply to the entire column, not individual cells on a row-by-row basis. Neither can report column values be referenced in condition expressions.For the record, that thread mentioned referencing the report item by enclosing it in hashes, in my case, #USERNAME#. I did try that, but every condition I tried came out false as the link column never displayed.
with the Display As column attribute for <tt>link_col</tt> set to Standard Report Column.
⋮ case when field1 is null then '<a href="/* generated URL */">Foobar</a>' else field1 end link_col ⋮