Sunday, November 22, 2009

Highlight current selected record

If you want to easily highlight the current selected record, you should adapt some standards.
  • Use an id column in every table.
  • Always use a Px_id field on every page with a report, where x is the number of the page.
  • Make a report column template with the desired background color for the highlighted row.
  • The pl/sql expresion condition for this template:  
    • #ID# = v('P'||:APP_PAGE_ID||'_ID')