Using the picture function
The Picture Function can be used within a formula to print a string “2065555555″ in a telephone number format “(206)..
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..
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..
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..
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..
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..
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..
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..
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..
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,..
RECENT COMMENTS
View Post
View Post
View Post
View Post
View Post