Mark
Mark

Reputation: 135

Conditional link in Report

Can you have a column display either text or a link based on another column in the report?

The only way I can think of is to change to text to a link with the SQL query using anchor tags.

Is there another way?

Upvotes: 1

Views: 4218

Answers (2)

Tony Andrews
Tony Andrews

Reputation: 132580

I have just described a way to do it in this blog post. This uses the normal APEX column link method with some CSS and Javascript to make it conditional. Beware that I only came up with this solution today and it may have issues I'm not yet aware of!

Upvotes: 0

Tom
Tom

Reputation: 7028

Nope. Doing this in an IR is not really possible, because you'd need hidden columns. But setting columns to hidden doesn't output them into html anymore, so not targetable through JS. It'd be possible with the columns shown on the report, but that gets messy fast.

Using classic reports though, it is rather easy (and oddly enough, only found this after answering this): See this link If you want to take it even further, then indeed, output through your select, or use javascript to target hidden columns and use their values to manipulate the value of another column. Classic report only.

Upvotes: 1

Related Questions