Skip to content

Round Function

Uses

The Round function can be used to control how numbers are rounded in your reports. By default, numbers will be displayed according to the default formatting you have set up; however the number will not be changed unless you use the Round Function. Continue reading ‘Round Function’ »

How to Display the Actual Number

When you configure how numbers display, you select the number of decimal places to show. Crystal Reports then rounds the display value to that decimal position and that is what you see.

But what if you want to display the actual number? If the original number has no decimal places, you want to see that. If the original has three decimal places, you want to see all three.

You can do this using conditional formatting. Continue reading ‘How to Display the Actual Number’ »

Rounding in Crystal Reports: Rounding to Unusual Amounts

You can quickly round to the nearest decimal place, but what if you need to round to an unusual point? For example, the nearest eighth mile? Or the nearest quarter hour? These activities are often done when calculating time sheets or mileage calculations. Fortunately, it’s relatively easy to modify the Round function to handle these odd fractions: Continue reading ‘Rounding in Crystal Reports: Rounding to Unusual Amounts’ »

Rounding in Crystal Reports: Display vs. Function

By default, Crystal Reports rounds all numbers displayed in your reports, according to the global settings. You can override these settings in a specific field by following these steps: Continue reading ‘Rounding in Crystal Reports: Display vs. Function’ »

MonthName Function

Uses

The MonthName function can be used to display the name of the month, when you provide a number between 1 and 12 (1 being January). It is useful for showing the month name in Group titles or labeling groups in charts.

It can be combined with the DatePart function to return the month name of a variable or calculation. Continue reading ‘MonthName Function’ »

DayOfWeek

Uses

The DayOfWeek function can be used to determine what day of the week a given date falls on, returned as a 1-7. By default, Sunday is assumed to be the first day of the week (1). Continue reading ‘DayOfWeek’ »

DateAdd Function

Uses

The DateAdd function can be used to add an interval of time to a date. For example, you can quickly calculate a date one week from today. It’s very useful for calculating deadlines.

The resulting value will always be correct; it takes into account the number of days in each month, including during leap year.

Continue reading ‘DateAdd Function’ »

DateDiff Function

Uses

The DateDiff function is used to determine the amount of time between two datetimes. You control the interval used in measuring the different (years, hours, etc.)

ToText Function

Uses

The ToText function can be used to convert number, date, boolean, or time values to a string (text). It provides you with controls that let you control how the resulting string looks.

It’s mostly used for concatenation (for example, you can create a title for your report that shows the records covered, or a group name that shows the date range included.)

Picture Function

The Picture function lets you provide a template to use when formatting a string. For example, you can force a phone number to appear in the format (906) 555-1212, or a Social Security number to appear in the format 326-75-3847. Use it in conjunction with the ToText function, and you can also control how a number is displayed. Continue reading ‘Picture Function’ »