Add Row Colour

Add Color to a Particular Row

· User can colour a particular Row, Column or Cell of the Report with the help of an appropriate SQL Query.

· In the following example, data related to some particular Item is coloured with a certain colour. Other Items are coloured blue.

· Follow the same procedure as in this Example

· Modifications are to be made only in the Stored Procedure Query. Refer to the image below for the query.

· Clear Cache once the changes are made.

View Report

· Find the Test Report in the Menu bar and click on SampleReport.

· Result shows Item number 2000142 in Green, 2000270 in Yellow and the rest of the Items in Blue Color.