How to Use Dynamic Color Coding in Bold Reports
Bold Reports Designer enables you to create visually appealing reports by dynamically adjusting the background color of cells or textboxes based on data values. By using simple expressions in the BackgroundColor property, you can apply conditional formatting to make your reports clear and engaging.
This guide provides clear, step-by-step instructions and examples to help you implement dynamic color coding in your reports.
Steps to Apply Dynamic Color Coding
1. Access the Expression Builder
- On the report design surface, click the cell where you want to apply dynamic background colors.
- In the Properties panel, locate the Appearance section.
- Click the square box next to the BackgroundColor property and select Expression to open Expression Editor dialog.
2. Write the expression
Use an IIF expression to set the background color based on a condition:
=IIF(Fields!ComponentID.Value >= 1 AND Fields!ComponentID.Value <= 250, "#FF4D4F",
IIF(Fields!ComponentID.Value >= 251 AND Fields!ComponentID.Value <= 500, "#FFA940",
IIF(Fields!ComponentID.Value >= 501 AND Fields!ComponentID.Value <= 750, "#40C4FF",
IIF(Fields!ComponentID.Value >= 751 AND Fields!ComponentID.Value <= 1000, "#4CAF50", "#FFFFFF"))))
Note: Replace color with your actual column name.
The SSRS expression above assigns a color to a Tablix cell Background based on the ComponentID value using nested IIF statements. It checks the ComponentID value and returns a color:
| Range | HEX COLOR MAPPING |
|---|---|
| 1 to 250 | Red (#FF4D4F) |
| 251 to 500 | Orange (#FFA940) |
| 501 to 750 | Blue (#40C4FF) |
| 751 to 1000 | Green (#4CAF50) |
| Anything else | White (#FFFFFF) |
3. Preview the Report
Click OK and preview the report to see the dynamic background colors applied.
Conclusion
Dynamic color coding in Bold Reports enhances data visualization by allowing you to apply conditional formatting to cells or textboxes. Whether using simple IIF expressions for basic conditions or Switch statements for more complex scenarios, you can easily customize the appearance of your reports. By following these steps, you can create visually appealing and data-driven reports that effectively communicate insights to your audience.
You can download rdl report from here:
