Customizing Prompt value in BI Publisher rtf report

BHANU PRAKASH CHUNDURI

Summary

Prompt value for All option shoud show text - 'ALL' isntead of all the values from the prompt

Content

Hello All,

 

I got a requirement in BI Publisher Reporting.The users wants to see the prompts that are selected on top of the page in output. Currently they're seeing the selected prompt values. But the latest requirement is when they select 'All' option in the Prompt they're getting all the values in the output which is very huge and users are not interested to see such output which is kinda confusing. So they want to see 'ALL' as text in the output when they select 'All' in the prompts. I'm trying to find a way to get this done.

Is there anyway to do this?. I need some suggestions from you Gurus.

 

Thank you.

FPonte

Hi Bhanu.

I'm assuming you will transform your Prompt to bring NULL if ALL is selected.

If that is the case check the post below

Handling null values in bi publisher rtf template

Hope it helps.

Cheers.

Fernando

JSB

Bhanu,

if you check the option 'ALL' then you need to change your code accordingly:

 AND (DEPT.DEPT_NAME IN (:p_dept_name) OR 'ALL' IN (:p_dept_name || 'ALL'))    

 

Cheers

BHANU PRAKASH CHUNDURI

Thank you Fernando. I modified the SQL accordingly and then change the Prompts as you suggested.

Thanks again for the link you suggested.