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

The Left Outer Join includes all records in the primary table that have an exact match in the secondary table but also all records that don’t have a match in the secondary table. The Left Outer and Right Outer joins are useful when creating reports to find participants without information in their record.

ADVERTISMENT