Ok bear with me but I am a complete noob at the crystal report formula thing, I have a report that is pulling employee's hourly wage information, I want to enter a formula that will multiply the field containing the hourly wage by 2080 (number of hours in a year) so that the yearly salary not hourly wage is displayed in that column of the report.  Anyone point me in the right direction?  Thanks.

The formula should be pretty simple.  Create a new formula in the Field Explorer window (not sure what its called in CR 8.5) and give it a name. Then enter similar code to this (using the correct table and field name):

{table.rate field}*2080

Save the formula and then drag and drop it onto your report in the Details section.

I have all the Crystal Reports functions documented with sample code in three chapters of my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

Edited by BrianBischof - 16 Apr 2008 at 11:34am