BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports – Design

Crystal Reports Barcode Font Freeware

A customer recently wanted to convert an employee ID number into a barcode in his crystal reports.  With that request, we that..

May 18, 2012 with 7 Comments

Wildcard parameters

Greatly increase the flexibility and effciency of your reports by using a wildcard parameter. This nifty trick  can be quite useful when..

April 5, 2012 with 2 Comments

Underlay sections

The art of underlaying sections is a pretty handy one to  master.  You can take ordinary grouped data and turn it into something very..

April 5, 2012 with 0 Comments

Suppressing blank lines in embedded fields

When you embed multiple fiends within a text object, you may encounter times wher an feild causes a blank line. You can suppress the blank..

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

Prevent truncated text-based object

When a text-based object is placed on a report, it is represented by an object frame. The height of the object is based on the height of..

April 4, 2012 with 0 Comments

GET SOCIAL

QUICK TIP

Reports should usually be grouped before sorting.

ADVERTISMENT