Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
