Hide layout in BIP when no data found while using xpt template

User_PW8X3

Hi,

I have created a BIP report containing two layouts, one of the other reports gets executed based on the filter conditions applied. Is there a way to hide the report which doesn't return back any data? Basically I want to only show the report layout that gets populated with data.

Can you please guide me with an example?

Thanks

Abhishek

Mallikarjuna Kuppauru-Oracle

Hi @User_PW8X3

Welcome to the Oracle Analytics BIPublisher Online Forum!

To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence. Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Is there a way to hide the report which doesn't return back any data? --> Is your report having any prompts ?

Regards,

Arjun

User_PW8X3

Hi Arjun,

Below is my reply to the your question

Is your report having any prompts ?

Yes the reports are executed using dashboard prompts

Thanks

Abhishek

Mallikarjuna Kuppauru-Oracle

Hi @User_PW8X3

Yes the reports are executed using dashboard prompts -->Means are you using analytics dashboard prompts to pass the parameters?

Regards,

Arjun

User_PW8X3

Hi Arjun,

That is correct.

Just to add as well there are two table view in a single xpt template.

Thanks

Abhishek

Mallikarjuna Kuppauru-Oracle

Hi @User_PW8X3

What is your test case here. You have 2 table views on same xpt template, you need to hide heading when ever data is not available?

For your information - Below are the modes from /dv --> console -->settings page. If you want to hide bip toolbar ..etc

Regards,

Arjun

User_PW8X3

Hi Arjun,

What is your test case here. You have 2 table views on same xpt template, you need to hide heading when ever data is not available?

Yes I need to hide the header column when data is not available.

Thanks

Abhishek

Mallikarjuna Kuppauru-Oracle

Hi @User_PW8X3

For xpt templates we don't have any option but you can try rtf .Refer below-

BI Publisher Reports and No Data Found - Oracle Forums

Regards,

Arjun