BOFocus – Crystal Reports Tips – Tricks – Tutorials

Monthly Archives

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

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

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

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

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

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

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

GET SOCIAL

QUICK TIP

When in the formula editor, Start out by typing the first charter of the function, press Ctrl-Space. The keyword auto complete will than show a list of the functions available beginning with the charter you typed in.

ADVERTISMENT