use style in database view

[VaniK]

Hi, I have created a database view to use it in a report. I have a decimal field which needs to be highlighted in the report based on certain condition. 

ex: if the number is above 36 it should highlight green, else red

I have tried using configure style option on the main table but it does not carry over to the table. Any suggestions to achieve this? 

TIA! 

[Shashank_18]

Hi @VaniK ,

You can use Field Style to display the field with certain background color. 

Please create 2 entries in the Field style table using your DB View:

1st Condition:

2nd entry will have condition shown below:

Hope this will resolve your issue. Please mark it as helpful/correct if it resolves your issue.

Thanks !

[VaniK]

Thank you @Shashank_18 for your reply. I did create 'field style' on the table field but the color is only appearing on the table list view and form view but neither in the database view (this is the data source for the report) nor in the report. 

[Shashank_18]

Hi @VaniK ,

To make it visible in the Database View table, you need to pass the attribute along with the prefix of that column.

I have created it and its working fine in both DB View and Report.

If possible, please share the screenshot, so that I can have a view of it.

[VaniK]

Hi @Shashank_18 , Here are my screenshots

First screenshot is database view list view, second screen shot is created a style but does not work.