Friday, 23 July 2010

Highlight Selected Row

This may be an a bit old topic. However I am getting emails from time to time asking how to do that. This example shows how to easily highlight a selected row in a report and make it persistant while reloading / submitting the page.

12 comments:

  1. Hi Denes,

    Thanks for a great example.

    Just small thing - in the description you didn't mention that there should be a link on "edit" button that sets P151_EMPNO item.

    Thanks,
    Lev

    ReplyDelete
  2. Dear Sir,

    I am working on it and pasted your given code but i dont understand. where i have to write it

    Put the following in the HTML Expression of the last column:

    please guide in this regard.

    Regards
    Kamran

    ReplyDelete
  3. Thank you! It was very useful.

    ReplyDelete
  4. Hello Denes

    I couldn't make it working from my APEX 4.0, could you please explain step2 ? Do we need to use the "Column Link " and "Link Attributes" ?

    Thanks
    SS

    ReplyDelete
  5. Thanks, It's super easy and so much better than how I was doing it.

    Regards,
    Ben

    ReplyDelete
  6. Hi ,

    I have created a Report with breaking , i have many challenges here.

    i need you help ,

    1) Report has first four column , the breaking is on first three column. but i want to apply break on fourth column too


    2) I want only the sum should be displayed on the fist and second column breaks and the third and fourth column sum should not appear on the screen.

    3) I donot want the first two columns to be displayed on screen , when i am making them as not show, then the sum Label in the sum rows are moving off , I want them to be displayed on the 3,4 column as these are the columns which should be seen on scree.


    4) I want the %sum_header_value# to display #colum1_value# and #column2_value# on the screen for the break sum correspondingly.

    Kindly! please Guide me on this.

    Waiting for your replies.


    Thanks & Regards,
    Nandini Thakur

    ReplyDelete
  7. Hi Nandini,

    Are you using interactive report?

    You can apply control break on upto 6 columns on Interactive Report.

    And also show and hide the desired columns without loosing the control breaks.

    Thanks,
    Vikram

    ReplyDelete
  8. Hi Vikram ,

    Thanks for the suggestion ,but i donot want to go with the interacxtive report as there thecontrol will be in the hands of end user and on top it wil be difficult to overwrite the exisiting the functionalites of it.


    T0 add one more thing , i wanted to check how to modifiy the sum column names when i am breaking for threee columns and i want to rename their sum row labels .
    Regards,
    Nandini Thakut

    ReplyDelete
  9. I was able to follow your instructions and get it working with the exception of one problem.

    After i select a row, it highlights fine, but when i hover over that row, the highlighter effect disappears

    ReplyDelete
  10. Excelent but same problem when i hover over that row, the highlighter effect disappears.

    ReplyDelete
  11. Just remove the highlighting row from the report template.

    ReplyDelete
  12. Thank you very much it was very helpful for me

    ReplyDelete