Categories
- All Categories
- 132 Oracle Analytics News
- 24 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 3 Oracle Analytics Industry
- Find Partners
- For Partners
How to use conditional region in RTF template footer of BIP report?
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
Best Answers
-
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.
1 -
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.
2
Answers
-
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?>
0 -
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.
0 -
Hi Mandeep, the output still looks the same. Below is what I changed in template-
0 -
Also, tried inserting IF directly in footer-
But no luck with o/p-
0 -
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.
0 -
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?
0 -
Thanks Anil, this worked
0 -
Thanks Mandeep, this answers my question as well.
1