In Template 25 (Blue Responsive) there is a Report Template called "Comment Bubbles" which you can apply to your report.
This is handy for notes that belong to a parent record, as well as useful for displaying audit information to users.
I'm using APEX Version 4.2.0.00.27
The query needs to contain the following columns in order:
Attributes & Options
|Ref. No||Attribute (Column)||Description||Options, Examples|
|1||class||The class of the bubble which affects the style in which it is displayed.||
[null] - displays a yellow bubble
grayComment - displays a grey bubble
|2||note_type||The 'type' of the update - you may have notes, auditing updates, etc within the same report feed. Dislays bold, grey and in italics.|
|3||note_text||The main text/description that is displayed in the update.|
|4||attribute_1||Displayed as text within the bubble, following the 'note_text'|
|5||attribute_2||Displayed as text within the bubble, following 'attribute_1'||Can use <stong> tags to make text appear bold|
|6||attribute_3||Displayed as text within the bubble, following 'attribute_2'|
|7||attribute_4||Displayed as text within the bubble, following 'attribute_3'|
|8||created_by||Displays small, underneath the bubble on the far left. Usually used to display the data stored in the CREATED_BY column of the table's audit columns, usually populated by a trigger with the person who is currently logged into the session.|
Displays small, underneath the button, beside the 'created_by'. Usually used to display the data stored in the CREATED column of the table's audit columns, usually populated by a trigger at the time of creation.
Use function apex_util.get_since(mydate) to display the time from now.
To display like below:
apex_util.get_since(n.created) ||' - '||to_char(n.created,'Day DD-MON-YYYY HH24:MI') as "created_on"
|10||link||Displays the link with text. The properties of the text displayed can be defined in Report Attributes > Column Attributes > Column Link||#link (and then define the link in the 'Report Attributes')|
|11||created||Used for sorting. Not displayed in template.|
|12||note_id||Unique ID of the note. Used if you require an 'Edit' link. Not displayed in template.|
Check out Oracle's packaged app, "Customer Tracker". Take a look at the Comment Bubble region on page 50 for an example of how this is implemented.