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')

2 comments:

Darek said...

Any working exmaple?

Kamil Schvarcz said...

Hi,

nice but it not works in version 3.1.1. I have tested in version 3.2.0 and there is all correct.

Kamil