BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports – Formulas

Using the picture function

The Picture Function can be used within a formula to print a string “2065555555″ in a telephone number format “(206)..

April 5, 2012 with 0 Comments

Display parameter values that where chosen at run time

For string parameters with multiple discrete values: Join(@Your_Parameter, chr(10) & chr(13)); For non-string parameters with multiple..

April 4, 2012 with 0 Comments

Shading every other line of the detail section

To shade every other line of the detail section of the report 1. Start by opening up the Section Expert by clicking on Go to Report,..

April 4, 2012 with 0 Comments

Repeating Group Headers

In Crystal Reports there is a feature to force group headers to repeat on each page. This can be done by checking the box next to..

April 4, 2012 with 1 Comment

Print “Cointinued on Next Page”

When a group will go beyond one page, you can print a messageat the bottom of the page using the following three formulas: 1. Open the..

April 4, 2012 with 0 Comments

Print a checkbox / bullet for a boolean column

Within Crystal Reports, you simply cannot create a checkbox for Boolean operators.  WIth the use of a formula and the Wing Ding font, this..

April 4, 2012 with 0 Comments

Add page numbers

If you would like to have your page number start with a high number, the following formula with accomplish this task. The following formula..

April 4, 2012 with 0 Comments

Listing employees length of service in months

The end result to the following formula will show the the length of service in months for an employee. 1. Create the following formulas and..

April 4, 2012 with 0 Comments

Limit the number of records per page

Create the following formula and place in the page header: WhilePrintingRecords; NumberVar counter := 0 Create the following formula and..

April 4, 2012 with 0 Comments

Finding the first friday of the month

Create the following formula and place in the detail section, the results wil return the first Friday of the month: WhileReadingRecords;..

April 3, 2012 with 0 Comments

GET SOCIAL

QUICK TIP

Use the Chart Sort Order dialog box to sort and group your chart data. This dialog box appears when you click the Order button on the Data tab of the Chart Expert for a chart with the Advanced layout type.

ADVERTISMENT