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.

Google Search

I would like to thank everyone for supporting my blog. A colleague told me today that my blog shows up on the first page of Google search engine for the following keywords:
- Microsoft Dynamics GP (#6)
- Microsoft Dynamics AND SQL (#4)
- Crystal Reports AND Microsoft Dynamics (#3)
- Sarbanes Oxley AND Microsoft Dynamics (#8)

Although my objective is to help the community learn more about the products featured in this blog, it’s very rewarding to know this things and makes me more eager to help.