When you create an interactive report, you can specify the first link, when you specify sql for the query, this is a link to a single line IR view.
Standard, you start with this single column in IR, and you can find the details of this link column in the report attributes> Link Column. Please note that only here you can select the option "Link to single line viewing."
If you need additional columns of links, you will need to edit your request (edit the report). For instance:
select empno, ename, job, sal, null link_column1, null link_column2 from emp
Thus, I create 2 additional columns for the report, the value of which is always zero (however, this is not a requirement! You could just select "ename link_column1" as an additional column that can be used as link text).
To turn these columns into link columns (or any other column actually!), You need to go to the column edit page: either using the report attributes, either click the edit link next to the column, or in the form of a tree, right-click on the column and choosing to edit.
On the edit page, scroll down to the Column Link section. Here you can set the link to another page again.
After execution, you can check the link columns in your report attributes.
Finally, be sure to add columns to your interactive report! Since you are most likely to add them later, you need to go to the action menu, select the columns and add additional columns. Remember to save as primary if you want this to be your default view.