Monday, July 2, 2012

Crystal Reports : Using Conditional Fonts

I have a few clients that use conditional formatting on their reports. That is, when a certain condition is met, certain formulas or database values can make themselves stand out by changing color or font style. 

The typical examples would include making a sales total field "red" if it drops below a certain value.

Let's assume our Sales Total field is called "{SalesTotal}".

1. Right-click on the field in question and select Format Field.
2. Click on the "Font" tab.
3. Click on the "x-2" (formula) button next to Color.
4. Use the following fomula: if {SalesTotal} < 100 then crMaroon else crBlack

This formula forces the sales total to be drawn in red if it drops below 100, oherwise it stays black.

Pro Tip: When testing a condition to change the font, any fields on the report are available to use.

3 comments:

Microsoft Dynamics AX training in Hyderabad said...

Microsoft Dynamics AX training, do keep a few things in mind to get the maximum out of the course as well as the application.we teach Microsoft Dynamics AX training and class at Hyderabad.

Microsoft Dynamics AX training in Hyderabad
Microsoft Dynamics CRM training in Hyderabad
Microsoft Dynamics NAV training in Hyderabad

Microsoft Dynamics CRM training in Hyderabad said...

Microsoft Dynamics CRM training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM training and class available at Hyderabad.

Microsoft Dynamics AX online training
Microsoft Dynamics CRM online training
Microsoft Dynamics NAV online training

lakshmi ganapathi said...

Can I simply just say what a comfort to find a person that truly understands what they're discussing on the web. You certainly know how to bring an issue to light and make it important. More and more passport agents in hyderabad