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

Control Break and conditional color formatting in the report.

Npullangari

Summary

Control Break and conditional color formatting in the report.

Content

Hello,

I am trying to create reports in BI Publisher. The report has the Control breaking and color coding in it. I am trying to get color in the particular cell based on the condition like the screenshot below. Please suggest me a solution to get the conditional formatting (like based on the value in the cell the color should be differed in that column) and the data should be displayed in a breaking format.

Thank you for your suggestions!!

Find more posts tagged with

Accepted answers

All comments

Npullangari

Hello Sandeep,

Thank you for the information. Currently i am using the plugin of BI Publisher where i am unable to see most of the options that they are showing in the tool. Will this be the limitation of using the Plugin. Should I have the BI Publisher Tool to get all these things done.

Thank you..

Sandeep S. Chauhan-Oracle

Hi,

You can refer below links, this will help you.

Conditional formatting in RTF template:

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2494

Conditional Formatting in BI Publisher layout template:

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-AF9605D4-56E5-4EEF-AEC2-559A103091C0.htm#BIPRD2232

-Sandeep

Sandeep S. Chauhan-Oracle

Ho,

Do you mean "BI Publisher Desktop tool" when you are saying "Plugin of BI Publisher". If yes then you can get the option as shown below-

or you can write the code directly in form field like this.

Ex:

<?if:income>100?>

<xsl:attribute

xdofo:ctx="block" name="background-color">red

</xsl:attribute>

<?end if?>

Thanks,

Sandeep

YGUTTIKONDA

If you are using 11g version there is also an option to create an interactive layout, which is fairly simple compared to the RTF.. this may be a good start ..

2 parts to the layout you need to Group it by the Data Element ' Oven' and then apply conditional formatting based on the requirement.

Npullangari

Thank you Sandeep..