I have an interactive report displaying all the records from articles table. For a logged in author, I would like to display all the records, but the EDIT should be displayed only for those articles written by that author. In articles table, I have the column CREATED_BY
which has the author username.
I added a condition to Link Column as Value of Item / Column in Expression 1 = Expression 2 as Expression1=#CREATED_BY#
& Expression2= :APP_USER
But this does not work. This is the first time I am taking this approach to display edit link based on a condition.
When I added the condition Value of Item / Column in Expression 1 is not null
and set Expression1 = #CREATED_BY#
, it was still not displaying edit link. So, I think that #CREATED_BY#
is returning null. But the record in table has a value & I also see it in report column.
Can someone help? I don't know where I am going wrong.