nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to use conditional region in RTF template footer of BIP report?

Neha Aishwarya

Hi,

My PDF report output is supposed to have below footer text-

This certificate contains the analytical results of a sample which is from your shipment or is representative of your shipment, as determined at its origin point. Company1/Company2 MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND DISCLAIMS ALL IMPLIED WARRANTIES INCLUDING WARRANTIES OF MERCHANTABILITY OR FITNESS FOR PATICULAR USE OR FREEDOM FROM PATENT INFRINGEMENT. Company1/Company2 WILL NOT BE LIABLE FOR ANY SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES. Your only remedy for any defect in this product is the replacement of the defective product, or a refund of its purchase price, at our option.

Company1 should be printed if field ORG_2PT1_FLG='Y' else Company2.

I have tried using Template in my RTF template-

but the output looks like below, the company name comes in a new line, followed by an enter-

How can I achieve the desired output?

Thanks in advance, Neha

Find more posts tagged with

BIP

BI Publisher

BI Publisher Report Templates

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/60994#Comment_60994

Apologies, missed this point.

Can you try using @inlines after if statement. Check sample on below MOS:

How To Prevent New Paragraph (Carriage Return) In BI Publisher RTF Template (Doc ID 2191520.1)

Thanks.

Anil Pandey-Oracle

It can be achieved easily, the report can be generated with dynamic footer. e.g. Here if Account_class = 'CURNO1' then I am showing compan1 else company2 in report footer.

Below is snippet of Syntax and report sample.

All comments

Neha Aishwarya

Adding the code behind form fields mentioned in RTF template screenshot below-

<?template:Name?>

<?choose:?>

<?When: G_1/ORG_2PT1_FLG='Y'?>

Company2

<?end when?>

<?When: G_1/ORG_2PT1_FLG='N'?>

Company1

<?end when?>

<?end choose?>

<?end template?>

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/60977#Comment_60977

Can you try adjusting all piece of code in a single line?

<?template:Name?><?choose:?><?When: G_1/ORG_2PT1_FLG='Y'?>Company2<?end when?><?When: G_1/ORG_2PT1_FLG='N'?>Company1<?end when?><?end choose?><?end template?>

Thanks.

Neha Aishwarya

https://community.oracle.com/products/oracleanalytics/discussion/comment/60978#Comment_60978

Hi Mandeep, the output still looks the same. Below is what I changed in template-

Neha Aishwarya

Also, tried inserting IF directly in footer-

But no luck with o/p-

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/60981#Comment_60981

Can you put this whole thing in one tag instead of breaking it, something like below?

And when you click it, it should have everything inside it.

Thanks.

Neha Aishwarya

https://community.oracle.com/products/oracleanalytics/discussion/comment/60986#Comment_60986

Correct me if I am wrong Mandeep, but since we talking about conditional region in footer, form fields are not possible to add in header/footer, right?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/60994#Comment_60994

Apologies, missed this point.

Can you try using @inlines after if statement. Check sample on below MOS:

How To Prevent New Paragraph (Carriage Return) In BI Publisher RTF Template (Doc ID 2191520.1)

Thanks.

Anil Pandey-Oracle

It can be achieved easily, the report can be generated with dynamic footer. e.g. Here if Account_class = 'CURNO1' then I am showing compan1 else company2 in report footer.

Below is snippet of Syntax and report sample.

Neha Aishwarya

https://community.oracle.com/products/oracleanalytics/discussion/comment/61158#Comment_61158

Thanks Anil, this worked

Neha Aishwarya

https://community.oracle.com/products/oracleanalytics/discussion/comment/61002#Comment_61002

Thanks Mandeep, this answers my question as well.