Column Headings in an Interactive Report

Question

I have an interactive report which needs to display different data based on value selected in a select list.

Interactive report is displaying data from a generic table, but what data is stored in which column depends on ID selected in the select list. What values does a column hold for any ID is stored in another table. Is there any way I can have column headings from my definition table, and data from the generic table?

Answer 1

The page help indicates that Column Heading for Interactive Report supports Application, Page Items and System Variables. So if you want the column header to display the value of item P1_COL1_HEADER then you would put &P1_COL1_HEADER. as value. The leading "&" and trailing "." are important.