page item is P73_ACTION_OWNER_01 it is a text field i want to use text which is type in this text field to pass  as string in below sql query   select Name from EBA_PROJ_ROLES where ID in (select distinct ROLE_ID from EBA_PROJ_USER_REF where USER_ID in ('select ID from EBA_PROJ_STATUS_USERS where FIRST_NAME like' || : P73_ACTION_OWNER_01));

Hi sir jii, How to show the serial number in IR report if the query is in group by format.

Hello, Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: Suzy provides the monthly financial reporting based on figures. The shareholders of the store have changed effective November 2021. Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working. Many Thanks, Bansari

Hi sir jii,        How to display null value as zero in IR report can you please suggest.