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 options available in the Format Editor are dependent on the type of field that is being formatted.

ADVERTISMENT