Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Control Break and conditional color formatting in the report.
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!!
Answers
-
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..
0 -
Hi,
You can refer below links, this will help you.
Conditional formatting in RTF template:
Conditional Formatting in BI Publisher layout template:
-Sandeep
0 -
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
0 -
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.
0 -
Thank you Sandeep..
0
