BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports – How-To’s

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

Turning off smart linking in Crystal Reports

Crystal Reports 9 / 10: In the Crystal Reports Database Expert, you’ll find that tables are automatically linked when you first add..

April 5, 2012 with 0 Comments

Storing report samples on your iPhone

PocketScanner is a handy application that allow you to scan any document and turn it into a PDF file. You can also upload any PDF to your..

April 5, 2012 with 0 Comments

Speed up your reports – Peforming grouping on server

The Perform Grouping on Server option can significantly reduce report processing time by limiting the amount of data transferred from the..

April 4, 2012 with 0 Comments

How to select / display null / blank dates (write)

At some point you may need to check if a date field is blank. A simple way of doing this is creating a formula to return a true/false value..

April 4, 2012 with 1 Comment

How to view reports SQL query statement

Crystal Reports provides a menu option to view what statement is being sent to the database. Follow these steps to use this option.1. Open..

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

Passing a shared variable from a sub report to your main report

Shared variables, make it easier to pass values from a subreport to the main report. Using shared variables requires two formulas: one to..

April 4, 2012 with 0 Comments

Page numbering starting on second page

When creating a memo type report, you may not want the page number to be displayed/started on the first page. The following example will..

April 4, 2012 with 0 Comments

Joining fields, objects using a text object

One mistake new report designers make is not utilizing text objects to join fields together.  Not doing this may cause your inserted..

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