Sept 2006 Articles

1. Adding Color to your Crystal Reports

One of the more requested features in Crystal Reports is color. The user wants to create conditional formulas in the report and show it in different colors. The easiest way to do this is to add conditional formulas in the Detail section. To do this, go to Insert>Section> Make sure you’re on the Details section then choose the Color tab. Mark the Background Color field then open Formula Editor. Once in Formula Editor is open you can create formula for you color, example shown below:

If {SOP10200.XTNDPRCE} > 1000 then RED else NOCOLOR

2. Using SQL Stored Procedures in Crystal Reports

This is a common question from the community. Yes, it is possible to use SQL Stored Procedures in Crystal Reports. To do this go to File>Options then go to the Database tab and mark Stored Procedures. Try to add a new table and you’ll see in your current database connection that both Tables and Stored Procedures would be available.